Very Computer

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!!

The way I added an OLEDB source for SQL Server 7 was to first register the
OLEDB DLL file on the SQL Server machine itself so it showed up as an
available driver. Then when creating the linked server, I would choose the
OLE DB provider and fill in the Connection String with the right Data Source
and login information and the connection worked.

Hope that helps.

Jon