Create Linked Server to Informix DB

Question

Create Linked Server to Informix DB

JMSM

SSCertifiable

Points: 5440
More actions
November 24, 2009 at 6:05 am

#213031

Hello,
I need to create one linked server between SQL Server 2005 and an Informix database.
We've installed the drivers and i can create the ODBC to Informix database but when creating the linked server the provider for Informix doesn't appears.
Should i install anything else so that the Informix Provider apppears? or there's any other solution that i can't remember?
Hope u can help me.
Thank and Regards,
JMSM 😉

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

You need to install the OLEDB provider for Informix. I don't remember where it comes from, but I remember there's a tools CD that contains the OLEDB provider (and many other things). I'm talking about IDS9, I don't even know if there's a newer version, but it could be a start point.

Hope this helps

Gianluca

-- Gianluca Sartori

spaghettidba SSC Guru Points: 105732 More actions · Answer 2

I did a quick search:

Informix latest version should be 11.5 (it's a long time since I last worked with it :-))

You need to install the CSDK package, that should contain the OLEDB provider. You should also set up some things on the Informix side. I think that CSDK contains a sql script that you will have to run on your Informix server.

-- Gianluca Sartori

spaghettidba SSC Guru Points: 105732 More actions · Answer 3

spaghettidba

SSC Guru

Points: 105732

November 24, 2009 at 6:43 am

#1083416

Double post

-- Gianluca Sartori

JMSM SSCertifiable Points: 5440 More actions · Answer 4

Thanks a lot.

I'll look you're post and after i'll tell u something.

Once more, thanks a lot,

Regards,

JMSM 😉

alen teplitsky SSC-Dedicated Points: 30014 More actions · Answer 5

can someone help a brother out?

i installed this on a SQL 2005 server but i'm getting a cannot initialize provider error

spaghettidba SSC Guru Points: 105732 More actions · Answer 6

I think you'd better start a new thread for this question.

Unfortunately that's a very little information to work on, I don't think I can help you.

-- Gianluca Sartori

Hunk Wang SSC Enthusiast Points: 161 More actions · Answer 7

What is your server configuration? OS ? 32-bit or 64-bit?

Commit to Never Ending Improvement

alen teplitsky SSC-Dedicated Points: 30014 More actions · Answer 8

testing on 32 bit SQL 2005 SP3

i think i'm hitting it but the latest error is "incorrect database or cursor name format"