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.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
"Kjell Nilsen" <xyzzyxnilsen_kjell@.hotmail.com> wrote in message news:<epENJJkJEHA.2244@.tk2m
sftngp13.phx.gbl>...
> 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::GetRowse
t
> returned 0x80004005: ]. " )
> Tia, Kjell.
Wednesday, March 7, 2012
Linked server against DB2 using DirectLink driver.
Labels:
connect,
database,
datadirect,
db2,
directlink,
driver,
linked,
microsoft,
mysql,
oracle,
server,
sql,
supportfour-part-namesi
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment