Linking Informix tables to SQL Server 2000

[Scott Adams]

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

[Scott Adams]

Using the database information I have provided, can someone help me
assemble the proper parameters I would pass to the stored procedures
sp_addlinkedserver and sp_addlinkedsrvlogin. I feel as if my troubles
are centered here. Thanks.

Scott


Paul Watson <paul@oninit.com> wrote in message news:<3F16CCB9.BC7CE322@oninit.com>...

> 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