Connessione database DB2 AS400 come linked Server da SqlServer

Connessione database DB2 AS400 come linked Server da SqlServer

Post by Paolo Zanoll » Sat, 04 Nov 2000 18:58:44

Qualcuno conosce la sintassi corretta per referenziare le tabelle AS400 ???.

N.B.: L'AS400 collegato con OLEDB e/o ODBC

Grazie 1000


1. Linked server AS400/DB2 trouble again

Hi !
I'm trying to create Linked Server to AS400 DB2 on SQL Server 2000.
Using IBMDA400 (IBM AS400 OLEDB Provider installed from Client Access).

Got an error 7399: OLEDB Provider returned UNKNOWN error.

Source=AS_SERVER;Transport Product=Client
Access;SSL=DEFAULT;Libraries=QGPL;Connect Timeout=90;Host Code Page=037'

Attempted different combinations of theese params...

After that created remote login on AS400.

Please help or correct my LinkedServerProperties...


Posted via

2. ...When Querying a memo?

3. Linked Server w/ AS400 (DB2 and/or Phisycal File) - Multi-Posted

4. quoted identifiers?

5. Linking AS400 DB2 to SQL Server 2000


7. Linked Server to DB2 on AS400

8. exchange public folder

9. Configuring DB2 / AS400 as a Linked server in SQL 2000

10. Oracle DB2/AS400 Access Manager and Oracle DB2/AS400 Transparent Gateway and UNIX connectivity

11. Update of tables between DB2/AS400 and SQLserver 7

12. Database link error after the remote database restarts (comes up after down for a while)

13. Linking SQL server 7 to AS400 using linked feature