sql server odbc: Linked server against DB2 using DirectLink driver. -- sql server odbc

Linked server against DB2 using DirectLink driver.

Kjell Nilsen
4/19/2004 9:12:41 PM

sql server odbc:

Hi,

does anyone know if the DataDirect Connect driver for DB2 driver support
four-part-names?

I'm testing this driver and have been able to set up a linked server and
query the database using the openquery syntax, but when I use syntax with
four-part-names or try to view the db2 tables in EM I just get error
messages.

( I get the following when trying to view the tables:
"Error 7399: OLE DB provider 'UNKNOWN' reported an error.

String data translation caused data truncation.]
OLE DB error trace [OLE/DB Provider 'UNKNOWN' IDBSchmaRowset::GetRowset
returned 0x80004005: ]. " )

Tia, Kjell.

Re: Linked server against DB2 using DirectLink driver.

db2team NO[at]SPAM hotmail.com
4/22/2004 10:32:47 AM

Kjell,

I suggest you try with another driver to see if the problem is related
to the driver (ie StarSQL, or the IBM's driver).

Bob

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server odbc group.