Linking Informix tables to SQL Server 2000

Posted in 2003

Topics: Installation, Setup & Upgrades, Stored Procedures & SPL, Connectivity: ODBC / JDBC / .NET, Security, Permissions & Auditing, Networking & sqlhosts Configuration

Scott Adams — 17 Jul 2003 08:55:29 -0700 — source: Usenet: comp.databases.informix

I am having difficulty creating a linked server (Informix) in Microsoft SQL Server 2000. I have successfully installed the Informix OLEDB driver; the driver is version 3.81. Using SetNet32 that was installed with the SDK v2.8, I can successfully connect to my Informix database. I can also successfully connect to my Informix tables using a system DSN (I have tested this by importing data into Excel using the DSN.) I have also executed some stored procedures (sp_addlinkedserver and sp_addlinkedsrvlogin) that were supposed to create the linked server, but I have not been successful. I would appreciate it if someone could help me out. My connection information follows: Server name: dapa_live Host name: mx Service: dapa_live Protocol: onsoctcp Database name: dapa (UserID and Password are required as well) Thanks. Scott Adams

↪ replying to Scott Adams

Paul Watson — Thu, 17 Jul 2003 17:20:09 +0100 — source: Usenet: comp.databases.informix

AFAIR you need to tell the informix end that you want to use OLE, I believe the procedure is in the manual but I can't remember what it is Scott Adams wrote: > > I am having difficulty creating a linked server (Informix) in > Microsoft SQL Server 2000. I have successfully installed the Informix > OLEDB driver; the driver is version 3.81. Using SetNet32 that was > installed with the SDK v2.8, I can successfully connect to my Informix > database. I can also successfully connect to my Informix tables using > a system DSN (I have tested this by importing data into Excel using > the DSN.) I have also executed some stored procedures > (sp_addlinkedserver and sp_addlinkedsrvlogin) that were supposed to > create the linked server, but I have not been successful. I would > appreciate it if someone could help me out. My connection information > follows: > > Server name: dapa_live > Host name: mx > Service: dapa_live > Protocol: onsoctcp > Database name: dapa > (UserID and Password are required as well) > > Thanks. > > Scott Adams -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #