linked server to informix - OLE DB Provider

Tom Lehr

unread,

Nov 21, 2001, 3:24:31 PM11/21/01

to

hi
when i use ODBC, i can connect to informix from sql server 2000 just
fine. when i try to set up a linked server, i get "error 7399:
Ifxoledbc reported an error".

for odbc, the server name is "ol_vasidb2", the host name is "hpl03",
the service is "sqlexec", the protocol is "olsoctcp" and database name
is "wlms".

in the linked server in enterprise manager using the Informix OLEDB
Provider, i use "Ifxoledbc" or "Ifxoledbc.2" and use a login with
password that i know works (i set this in the security tab).

the problem seems to be the Data Source. when i use "vasidb2", i get
an error as mentioned before. when i try to fully qualify it with
wlsm@ol_vasidb2, i get a different error "OLE DB Provider 'UNKNOWN'
reported an error.

the ifxoledc.dll version i have is "2.10.0.10287" and i am on windows
2000 with latest service pack, if that matters.

can anyone shed some light here?
thanks in advance!

tom

Ahmed Jewahar

unread,

Nov 22, 2001, 4:47:15 AM11/22/01

to

Tom,

Are using Informix Driver or Intersolv ? Please advise.

You said that you could connect from SQL server to Informix using ODBC. Could you please tell me how you connected ?

To setup a linked server, I suggest you to create a ODBC System DSN, hope that you might have done that. If so, try the following steps to configure a linked server:

Choose other data source and select OLE DB provider for ODBC Drivers as Provider name.

Type the ODBC System DSN name as Data Source.

Hope this will help.

Thanks
ahmed jewahar

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Tom Lehr

unread,

Nov 25, 2001, 3:00:39 PM11/25/01

to

i am using informix driver. when i connect thru ole db for odbc data sources, the linked server is fine. it is when i trtry to use straight ole db provider for informix (ifxoledbc) that i get a return error from ifxoledc.dll.

thanks!

Tom C. Lehr
Business Analyst
Werner Enterprises - Value Added

_alt.0

Ahmed Jewahar

unread,

Nov 26, 2001, 7:43:07 AM11/26/01

to

Tom,

To enable your Informix database for OLE DB access, you must run the SQL registration script, 'COLEDBP.SQL', against 'sysmater' database as user Informix. Script file is coming along with SDK Kit.

You may check with your database administrator before you run the script.

Please let me know if it works fine. Hope this will help you.

Thanks!

Ahmed Jewahar
Business Analyst(Technical Support)
DHL Country Office - Saudi Arabia.
ajew...@sa.dhl.com

Myung-Jwa Kim

unread,

Jan 14, 2002, 8:08:28 PM1/14/02

to

I want to open informix database in sql server 2000.
Finally, I want to move the data into Oracle box.
Since I can't move the data from informix to Oracle
directly by some nontechnical reason.

I made connection from Sql server(2000) to Oracle by
linked server. Now I need to find how to connect to
informix from sql server,

Thanks in advance,

Myung-Jwa,

>.
>

Ahmed Jewahar

unread,

Jan 15, 2002, 12:09:36 AM1/15/02

to

SDK Kit can be downloaded from Microsoft Site.

>>I made connection from Sql server(2000) to Oracle by
>>linked server. Now I need to find how to connect to
>>informix from sql server,<<

You can create a linked server from SQL to Informix either using ODBC
DNS nor OLE DB Provider. If you have already created ODBC DSN use that.
If you don't you have to create one. I hope that you might have Informix
driver.

Any question, please feel free to contact me.

Ahmed Jewahar