D
Domenick
I have tables linked via ODBC (IBM Client Access for iSeries aka AS/400) in
my database. I want to be able to have other people on my network run these
queries as well. We all have the same ODBC driver that points to the same
library(directory) and tables, but the DSN's have different names on
differnet machines. I may have a User DSN named CLI01 while my coworker might
have one called AS4. They both point to the same place, but if she tries to
run the query from her machine, she gets 'ODBC failed' error message. If I go
to her machine and create a new user DSN with the same name as mine, the
queries run fine. How can I set this up so that all users who have their ODBC
set up correctly can run the queries - regardless of the local DSN name on
their machine? Can it prompt them for the name of the DSN (on their machine)
that points to the correct location?
Thanks.
my database. I want to be able to have other people on my network run these
queries as well. We all have the same ODBC driver that points to the same
library(directory) and tables, but the DSN's have different names on
differnet machines. I may have a User DSN named CLI01 while my coworker might
have one called AS4. They both point to the same place, but if she tries to
run the query from her machine, she gets 'ODBC failed' error message. If I go
to her machine and create a new user DSN with the same name as mine, the
queries run fine. How can I set this up so that all users who have their ODBC
set up correctly can run the queries - regardless of the local DSN name on
their machine? Can it prompt them for the name of the DSN (on their machine)
that points to the correct location?
Thanks.