Hi
I am trying to establish a Microsoft SQL Server OLE Db connection to our Contact Centre Informix Db
I can create a local ODBC connection on my PC without any issues.
However, when I try to create an OLEDB connection on our SQL Server I get many errors including the following:-
Test connection failed because of an error in initiating provider. Multiple Step OLE DB Operation generated errors. Check each OLE DB status value, if available. No work was done.
and
Test connection failed because of an error in initiating provider. No error message available, result code DB_ERRORSOCCURRED (0x80040E21).
If I try to establish a linked SQL Server connection despite registering the ifxoldbc provider I get the following error
Failed to retrieve data for the request
An exception occurred while executing a transact SQL statement or batch
The OLE DB IBM Informix OLE DB Provider has not been registered Error 7403
Can anybody help?
Thx
