Im currently running a SQL SERVER 2008 R2.
and I need to connect to AVAYA CMS database to generate reports.
I found out that it can be done with the help of informix oledb as a provider.
The computer i was using already had an IBM INFORMIX DRIVER when i checked the computer's odbcad32.exe.
also access rights was given there, [ip of the server,username,password,database name, etc] and
upon clicking Test Connection it prompts a success in connection.
My problem is when im trying to do a Linked Server on my sql server, in the provider dropdown
the informix provider is not listed.
A. How can i check the applied configuration if the previous user missed a setting?
B. How can i access the database configured on odbcad32.exe and link it to my sql server(odbc informix download link or steps on downloading and configuring)
All i want is to establish a connection with the database to
make a local-web-based analytics so i can easily show historical data and its interpretation.
Any help to this is very much appreciated.
-dexterdg
and I need to connect to AVAYA CMS database to generate reports.
I found out that it can be done with the help of informix oledb as a provider.
The computer i was using already had an IBM INFORMIX DRIVER when i checked the computer's odbcad32.exe.
also access rights was given there, [ip of the server,username,password,database name, etc] and
upon clicking Test Connection it prompts a success in connection.
My problem is when im trying to do a Linked Server on my sql server, in the provider dropdown
the informix provider is not listed.
A. How can i check the applied configuration if the previous user missed a setting?
B. How can i access the database configured on odbcad32.exe and link it to my sql server(odbc informix download link or steps on downloading and configuring)
All i want is to establish a connection with the database to
make a local-web-based analytics so i can easily show historical data and its interpretation.
Any help to this is very much appreciated.
-dexterdg