Mark:

I just can't seem to get the Microsoft Oracle driver to work in our environment. When I set up a DSN, using the server name without '.world' in the box, it doesn't work. It also doesn't work when I use the SQLStringConnect command:

lnHandle = SQLStringConnect('Driver=Microsoft ODBC for Oracle;UID=myID;PWD=myPassword;connectstring=servername;')

But this does work:

lnHandle = SQLStringConnect('Driver=Oracle ODBC Driver;UID=myID;PWD=myPassword;DBQ=servername.world;')

as well as the regular DSN entry using the Oracle driver. I've also read in the documentation for the Oracle driver that the database has to be Oracle 8 or
better. Apparently this driver doesn't work with Oracle 7, and I am not able to install the earlier NT drivers without getting errors.

Linda