Linked Server Error Msg 7312 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Linked Server Error Msg 7312

Author

Topic

elomon
Starting Member

37 Posts

Posted - 2003-01-13 : 12:20:49

I've created a linked server on my SQL2K to DB2 on a mainframe. I can select some columns but I'm getting an error when I try to select DB2 datatype text:
select * from openquery(MyLinkedServer,
'select myText from DB2Owner.tblName')

Error:
Server: Msg 7350, Level 16, State 2, Line 1
Could not get the column information from the OLE DB provider 'IBMDADB2'.

I can select any other datatype just fine. Any ideas on a workaround?

ps - I tried 4 part naming but that throws 'Invalid use of schema ...' which is expected as per the Books on line.

Edited by - elomon on 01/13/2003 12:22:51

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-01-13 : 12:31:27

The OLE DB provider you're using is not identifying text data properly. There may be a setting for that provider that will make it function properly. These can be found under the Server Options tab on the Property sheet for the linked server, or they may have to be indicated in the connection string. You should check the documentation for the provider you're using. There might be some more info here:

http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/document.d2w/report?fn=db2v7agdb2age70.htm

elomon
Starting Member

37 Posts

Posted - 2003-01-13 : 12:37:55

Thanks for the reply & much thanks for the link. I'll toy with that and the link looks very, very helpful.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources