Phil,

Yes you do, or if you have an oracle database I think there is a way to do
it in the tnsnames.ora file but I don't know it off the top of my head. The
setup for a System DSN through the ODBC settings will vary depending upon
the database management system used and the driver version...

"pspyve" wrote in
message ...

Thanks Dove for your reply. I really appreciate it.
Using this set up, Do you need to set up a system DSN in the computers
ODBC settings(ODBC Data Source Administrator), as this is my issue?

Phil S


--
pspyve
------------------------------------------------------------------------
pspyve's Profile:
http://www.excelforum.com/member.php...o&userid=30656
View this thread: http://www.excelforum.com/showthread...hreadid=561885