Friday, March 23, 2012

opendatasouce and ingres database

Dear all,

I want to connect to an Ingres Database in Sql Server 2000 using OPENDATASOUCE

But I don't know the syntax about OPENDATASOURCE when connect to an Ingres Database?

Thanks you

Hi,

The OPENDATASOURCE syntax is quite simple: OPENDATASOURCE (provider_name, init_string). In order to connect to the Ingres this way, you need an OLE DB provider for Ingres. Microsoft does not ship one, but there're 3rd party ones available on the market. The corresponding vendor documents the provider and all the relevant connection string tokens, that is the right place to look for this information.

HTH,

Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment