Connect to DB400 using linked servers from SQL Server

[manty]

hi all,

I have been trying to connect db2 udb using linked servers from SQL server, but so far highly unsuccessful.

It would be great if you can provide me a code snippet regarding the driver details to be used, (i have used OLEDB native driver), how to establish the connection, connection string details and other relevant information.

Thanks,
Manoj

[abercrombieande]

Re: Connect to DB400 using linked servers from SQL Server

Two example using different drivers. Make sure you have them installed before you try to use them.


---MSDASQL
EXEC master.dbo.sp_addlinkedserver @server = N'OBDCNAME', @srvproduct=N'Product', @provider=N'MSDASQL', @datasrc=N'SERVERNAME', @catalog=N'CATALOGNAME'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'ODBCNAME',@useself=N'False',@locallo gin=NULL,@rmtuser=N'USERID',@rmtpassword='PASSWORD '

--IBMDA400
EXEC master.dbo.sp_addlinkedserver @server = N'OBDCNAME', @srvproduct=N'Product', @provider=N'IBMDA400', @datasrc=N'SERVERNAME', @catalog=N'CATALOGNAME'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'ODBCNAME',@useself=N'False',@locallo gin=NULL,@rmtuser=N'USERID',@rmtpassword='PASSWORD '