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
 SQL Server Administration (2000)
 Linked Server to AS/400

Author  Topic 

wsantos99
Starting Member

2 Posts

Posted - 2001-10-22 : 16:00:28
I'm trying to make a Linked Server to the AS/400. I used an ODBC from Client Access. After the configuration is done I can see all tables from the AS/400 but when I made a simple select statement it raise me an error. The statement and the message are the followings:

Select * from
Test400.S105B7AM.KANFIL.APRCTL

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver (32-bit)]Driver not capable.]


There are something wrong with the configuration or it only that the ODBC Driver from Client Access is not capable to work with this SQL feature.

Thanks for any help....

Waldemar


   

- Advertisement -