Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQLColumns() returning no default values, wrong nullable information

Status
Not open for further replies.

aleksander3

Programmer
Jul 27, 2006
1
US
I have an ODBC connection to a MS Access 2003 DB. When I call the SQLColumns() function, the column in the result set for default values, nothing is ever there. Also columns that have the required property set to yes, SQLColumns returns that those columns can be nullable. Is there some compatibility issue with Access and ODBC? The Access driver is version 4.00.6304.00.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top