General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only