Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

trying to use a linked server ODBC... Expand / Collapse
Posted Friday, September 6, 2013 8:42 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, March 30, 2015 10:29 AM
Points: 74, Visits: 177
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?
Post #1492280
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse