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