I wonder if anyone can help us?
We a trying to create a linked server to access a UniVerse database from
SQL Server. The OLE DB provider that we are using is Informix.UniOLEDB.
We are able to access our UniVerse database by creating an ODBC System DSN
and using OLE DB provider for ODBC Drivers and this is OK.
For performance reasons (we think), we want to use OLE DB directly without
using and ODBC data source. We are not sure how to create our linked
server, what do we enter in datasource, provider string and location.
Any help that you can give us will be much appreciated!!