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!

Register Log in
  • Congratulations strongm 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

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.

Similar threads

MDGarcia
  • Locked
  • Question
ODBC error: Specified driver could not be loaded due to system error 193
Replies
1
Views
430
k5tm
k5tm
woezelmann
  • Locked
  • Question
MDX Sum values of lower level
Replies
1
Views
261
blom0344
blom0344
plocks
  • Locked
  • Question
Create ODBC "default database" Drop-Down Missing Databases
Replies
1
Views
68
SkipVought
S
LAM123
  • Locked
  • Question
Help, script on ODBC is not working
Replies
1
Views
67
SkipVought
S
Jony77
  • Locked
  • Question
Wrong answer after aggregating 1
Replies
1
Views
46
blom0344
blom0344

Part and Inventory Search

Sponsor

Back
Top