Office XP ODBC drivers???

[kviglas]

Are there any ODBC drivers for the Office XP? I am asking this because I was using Excel 2000 to import some queries from Access 2000 (from tables linked with Oracle 8.1.7). Everything was going on fine but when we installed Office XP, I cannot import some queries, especially the big ones. And I am talking for queries that I was importing to Excel 2000. I have already set ODBC Timeout to 0 but nothing happens.

Any suggestions?

 

[reclusivemonkey]

I am no expert on ODBC, but I feel your pain as I had a similar problem recently. You can download the ODBC drivers from microsoft, but before you try that, have you checked the ODBC Data Source Administrator? Are you using User or System DNS? Try recreating the DNS, and relinking. Are you at work or home? If you are on a corporate machine, and the usual security applies, it could be permissions; that was the issue affecting me. Try looking in the tracing log (you can see where this is from the ODBC Administrator) and if you are on XP, look in the Event Viewer for any errors, this might help. Good Luck!