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
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