Hi all
I've got a customer who has been using an Openlink ODBC driver to create queries in Excel from an Informix database.
We have now moved on to native Informix ODBC drivers and the queries won't work even if the DSN's are named the same as they were when the query was created, I get ODBC Error: Data Source name Not Found and No Default Driver Specified.
I've tried editing the Microsoft Query file and changing the line that references the Openlink ODBC to the Informix one but I still get the same error.
Is there any way round this other than recreating the queries - which he obviously doesn't want to spend time doing.
Thanks in advance
Clegg
I've got a customer who has been using an Openlink ODBC driver to create queries in Excel from an Informix database.
We have now moved on to native Informix ODBC drivers and the queries won't work even if the DSN's are named the same as they were when the query was created, I get ODBC Error: Data Source name Not Found and No Default Driver Specified.
I've tried editing the Microsoft Query file and changing the line that references the Openlink ODBC to the Informix one but I still get the same error.
Is there any way round this other than recreating the queries - which he obviously doesn't want to spend time doing.
Thanks in advance
Clegg