Mohammed Basheer
asked on
Pervasive ODBC with excel
HI
I had an excel spreadsheet with datasource of Pervasive client interface ODBC configured. It was working perfectly. Yesterday i have changed the ODBC datasource name. and i get some error. How do i change the path for the Excle sheet for the new datasource name?
The error messages are here:
"The microkeranl cannot find the specified file (Betrieve Error 12)"
"Invalid Connectiong string attribute"
Thanks for any help
I had an excel spreadsheet with datasource of Pervasive client interface ODBC configured. It was working perfectly. Yesterday i have changed the ODBC datasource name. and i get some error. How do i change the path for the Excle sheet for the new datasource name?
The error messages are here:
"The microkeranl cannot find the specified file (Betrieve Error 12)"
"Invalid Connectiong string attribute"
Thanks for any help
Yes, I did recreate all DSNs. as your advise, i tried to edit the query, gives me error:
"[Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified".
Is there any tweak in registry or somewhere else to edit the previous odbc configuration for this excel file?
Where actually this information stored? I searched the Microsoft KB, but didnt find any helpful document
Thanks for any help
"[Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified".
Is there any tweak in registry or somewhere else to edit the previous odbc configuration for this excel file?
Where actually this information stored? I searched the Microsoft KB, but didnt find any helpful document
Thanks for any help
Looking at the XLS file for a sheet that has a query, there is a "DSN=" value. I don't know how you would change it in Excel but it should be configurable.
ASKER
Would you please let me know how do i find it and change?!!
Thanks
Thanks
Google is your friend.. THe following might help.. I haven't tried it (I don't use Excel).
http://groups.google.com/group/microsoft.public.excel.querydao/browse_thread/thread/ae4b75fe92d13aaf/a3eb42ee0cd118d7%23a3eb42ee0cd118d7?sa=X&oi=groupsr&start=1&num=3
and
https://www.experts-exchange.com/questions/21173159/Create-ODBC-with-a-macro-and-modify-macro-based-on-current-PC's-settings.html
http://groups.google.com/group/microsoft.public.excel.querydao/browse_thread/thread/ae4b75fe92d13aaf/a3eb42ee0cd118d7%23a3eb42ee0cd118d7?sa=X&oi=groupsr&start=1&num=3
and
https://www.experts-exchange.com/questions/21173159/Create-ODBC-with-a-macro-and-modify-macro-based-on-current-PC's-settings.html
ASKER
I found a nice Query edit add-in for excel. It did the job! Pls find that here:
http://vangelder.orcon.net.nz/
Thanks for all your help..:)
http://vangelder.orcon.net.nz/
Thanks for all your help..:)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
As far as changing Excel, you'll probably have to go into Excel, then "Data" then "Import External Data" and then "Edit Query" tobring up MS Query and then change the DSN it's pointing to.