Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS Query Data Source Not Found Problem

Status
Not open for further replies.

locutis

Programmer
Nov 3, 2006
53
US
I have this MS Query I've been using for some time with many users, no problem. In my data sheet I added another new database query via the MS Query tool (not the wizard) like i'd done before, but now other machines get and [ODBC Driver Manager] [Data Source Name Not Found And No Default Driver Specified], whereas on my machine and a couple others they don't get this error, it runs fine! I checked several times to make sure I used the EXACT same System DSN connection. Arrrgggg!!! Pulling my hair out and about to dump this whole thing. Can anyone please help? I know why this happenes but for the life of me cannot figure out in this instance why it is complaining about not having an ODBC source? Here is an example of the cells and what I mean:

Product Status:
version_id created_time
22493 11/28/2006 (!Refresh Data, OK)
27199 12/26/2006 (!Refresh Data, ERROR)

I tried two different ways:
Data-->Get External Data-->New Database Query
Copying the query row (two cells in this case)

Again, works on two machines, but not on another two. All machines have the same System DSN/ODBC to the same database with no conflicting databases.

So, any help wold REALLY be appreciated and I would be grateful!!!

Thanks,
Jean Luc
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top