September 6, 2013 at 8:42 am
Not sure what forum to post in but I have the DSN/ODBC setup and working properly except for 1 thing. i can see and access the odbc data using the openquery option but when i try to directly select the data i get error about not able to obtain the dbschema_columns. the odbc driver/software does provide the column information. after doing some tracking down/support work i have discovered that a system table from the odbc vendor has all the column name per table. HOWEVER, one of the columns in that table is FORMAT. which i suspect is the problem but the vendor says it is not.
select * from openquery(LINKEDSERVER,'select * from SYSTEM_COLUMNS')
throws an error back to me.
Msg 7342, Level 16, State 1, Line 1
An unexpected NULL value was returned for column "[MSDASQL].FORMAT" from OLE DB provider "MSDASQL" for linked server "LINKEDSERVER". This column cannot be NULL.
I was wondering if the support person from vendor is correct in saying that the column name FORMAT is not the problem, or is it?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy