Very Computer

by **Ahmed Jewaha** » Tue, 02 Apr 2002 16:45:13

Dear All,

Have created a linked server from SQL server 2K to Informix using
Informix OLE DB Provider.

But, when I click on linked server object... I mean on table or view
objects of Linked Server, I'm gettin the following error message...

Error 7302. Could not create an instance of OLE DB Provider
'Ifxoledc'

For your kind information, I managed to open an ADO connection from my
VB 6.0 applicaiton to Informix Database using same provider....

Could you please help me out to create a Linked Server using Informix
OLE DB provider. We have installed Informix SDK client on server.

Appreciate any of your comments/ tips on this...

many thanks in advance...

Regards,

Ahmed Jewahar

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

by **Chris Skorlinski (** » Sat, 06 Apr 2002 01:58:22

The only time I've seen this issue there was a problem with the Informix
driver. You may want to contact Informix technical support to see if the
driver is installed correctly. They may be able to help test the OLE DB
connectivity outside of Enterprise Manager first. Perhaps there is a newer
version or the driver available that fixes your issue.

Best of Luck,

Chris Skorlinski, MCDBA
Microsoft SQL Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.

by **Dennis Redfiel** » Sat, 06 Apr 2002 03:15:55

1) Please let us know the version of the informix driver you are using.
2) when you did your ADO connection test were you running on your server or
a client
3) provide the TSQL code used to create the linked server
4) is this correct: you are able to create a linked server and expand the
tree view to show objects on the
informix box BUT when you expand an individual object you get the error?

[we are using linked informix servers and have no problems (now)]

Quote:
> Dear All,

> Have created a linked server from SQL server 2K to Informix using
> Informix OLE DB Provider.

> But, when I click on linked server object... I mean on table or view
> objects of Linked Server, I'm gettin the following error message...

> Error 7302. Could not create an instance of OLE DB Provider
> 'Ifxoledc'

> For your kind information, I managed to open an ADO connection from my
> VB 6.0 applicaiton to Informix Database using same provider....

> Could you please help me out to create a Linked Server using Informix
> OLE DB provider. We have installed Informix SDK client on server.

> Appreciate any of your comments/ tips on this...

> many thanks in advance...

> Regards,

> Ahmed Jewahar

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

by **Ahmed Jewaha** » Sat, 06 Apr 2002 19:50:54

Hi Dennis,

Thanks for your response. Please find below the details requireb by you:

1) Ifxoledbc.dll (Informix OLE DB Provider)
version : 2.0.0.0
Company: Informix Software

2) The ADO connection using in front-end (VB) application which is
client.

3) I didn't use T-SQL to create linked server. I use linked server
option from SQL Enterprise Manager and given the following as
properties:

a) I choose 'Informix OLE DB provider' from combo as Provider Name

as datasource

Hope the above info will help u to find out the problem.. looking
forward to hearing from you..

appreciate you help...

Best regards,

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

by **Dennis Redfiel** » Sat, 06 Apr 2002 22:33:09

1) we are using 2.50.0 (we had problems with earlier version, also setup
may FAIL to register the informix DLL but I don't think this is your
problem)
2) Retest: Go to the server and run your ADO/VB client on the server cpu.
report back.
3) (I will investigate our properties on this later today)
4) Please confirm: "is this correct: you are able to create a linked server
and expand the
tree view to show objects on the informix box BUT when you expand an
individual object you get the error?"

> Hi Dennis,

> Thanks for your response. Please find below the details requireb by you:

> 1) Ifxoledbc.dll (Informix OLE DB Provider)
> version : 2.0.0.0
> Company: Informix Software

> 2) The ADO connection using in front-end (VB) application which is
> client.

> 3) I didn't use T-SQL to create linked server. I use linked server
> option from SQL Enterprise Manager and given the following as
> properties:

> a) I choose 'Informix OLE DB provider' from combo as Provider Name

> as datasource

> Hope the above info will help u to find out the problem.. looking
> forward to hearing from you..

> appreciate you help...

> Best regards,

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

by **Ahmed Jewaha** » Sun, 07 Apr 2002 14:06:52

Hi,

Thanks for your reply..

2) I tried ADO/VB client on Server and it works well.
4) Yea, It's true that I could create the linked server and the objects
(table and view icon) are visible. But error occured while I try to
expand he objects.

Is there any luck to solve this problem... appreciate your help..

Many thanks in advance..

Regards,

Ahmed Jewahar

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

by **Harald Um** » Sun, 07 Apr 2002 17:50:22

Stupid question:
Have you installed the script $INFORMIXDIR\etc\coledbp.sql on your sysmaster
db on your server.
If not that would explain the inability to see table information.
Harald Ums

Quote:> Hi,

> Thanks for your reply..

> 2) I tried ADO/VB client on Server and it works well.
> 4) Yea, It's true that I could create the linked server and the objects
> (table and view icon) are visible. But error occured while I try to
> expand he objects.

> Is there any luck to solve this problem... appreciate your help..

> Many thanks in advance..

> Regards,

> Ahmed Jewahar

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

by **Ahmed Jewaha** » Sun, 07 Apr 2002 18:24:25

Dear,

Script has executed against sysmater DB... otherwise how could I open an
ADO connection...

Rgds,

Ahmed

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

by **Dennis Redfiel** » Thu, 18 Apr 2002 01:47:59

ahmed,
sorry forgot about your thread. Did you solve the problem. what
happens in QA when you run a TSQL select statement against an object? what
happens when if you use openquery?

Quote:> Dear,

> Script has executed against sysmater DB... otherwise how could I open an
> ADO connection...

> Rgds,

> Ahmed

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

Very Computer

Couldn't create a linked server to INFORMIX using Informix OleDb provider

Couldn't create a linked server to INFORMIX using Informix OleDb provider

Couldn't create a linked server to INFORMIX using Informix OleDb provider

Couldn't create a linked server to INFORMIX using Informix OleDb provider

Couldn't create a linked server to INFORMIX using Informix OleDb provider

Couldn't create a linked server to INFORMIX using Informix OleDb provider

Couldn't create a linked server to INFORMIX using Informix OleDb provider

Couldn't create a linked server to INFORMIX using Informix OleDb provider

Couldn't create a linked server to INFORMIX using Informix OleDb provider

Couldn't create a linked server to INFORMIX using Informix OleDb provider