Check the TNSNAMES.ORA file on the machine that it IS working on. Look for the "myserver" alias that you are using for the DBQ or SERVER connect string parameter. This information has to appear in the TNSNAMES.ORA file on all the other workstations.
This text file can be found in the Oracle Client installation folder under something like .\Network\Admin. Mine is in C:\Oracle\Ora92\Network\Admin
>Mark,
>
>Thanks for the reply.
>
>I have double checked the name of the driver and everything matches including case.
>
>My first problem with using the Oracle driver was solved by adding:
>'dbq=myserver;'
>to the SQLSTRINGCONNECT() function in place of 'server=myserver;'
>
>However, on another PC we can't connect to the Oracle database using either the MS or Oracle drivers.
Mark McCasland
Midlothian, TX USA