Trouble with Linker Server for Informix

[rmttbone]

I am having trouble creating a linked server that links SQL Server 2000 with Informix.

I am using IBM Informix Client SDK 281.

I have created a System DSN using the IBM Informix 3.82 32 bit driver (ICLITO9B.DLL)

I checked my registery, and the DSN is registered.

I have used both separate procedures belows, and when I attempt to go to the tables, I rec'd this error:

Error 7299: OLE DB provider "MSDASQL' reported an error. Data source name not found and no default driver specified.

First Statement I used:

EXEC sp_addlinkedserver
@Server = 'My Linked Server',
@srvProduct = 'ifxoledbc',
@Provider='MSDASQL'
@provstr = 'Driver={IBM Informix OLE DB Provider};Database=apets;UID=my login;PWD=my password;
PROTOCOL=onsoctcp;HOSTNAME=my server;
Service=1548;SERVER=my server;'

Second Statement I used:

EXEC sp_addlinkedserver
@Server = 'My Linked Server',
@srvProduct = 'ifxoledbc',
@Provider='MSDASQL'
@datasrc = 'my system DSN name'

I also attempted to do a this select query using opendatasource:

Select *

FROM OPENDATASOURCE(
'MSDASQL',
'Data Source=my DSN name;User ID=my login;Password=my password'
).my db.dbo.my table

Error rec'd:

OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]

 

[rmttbone]

Thanks everyone. I found the solution:

p_addlinkedserver @server = 'Name of Linked Server'
, @srvproduct = 'Your System DSN Name'
, @provider = 'MSDASQL'
, @datasrc = 'Your System DSN Name'
, @location = 'Your server'
, @provstr = ''
, @catalog = 'Your Database'