General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Connecting to Oracle
We connect to an Oracle database in our application. If I use the Microsoft driver to connect, I get a connection handle returned with no problem.
But if I use the Oracle driver to connect, I get a dialog asking for a Service Name. After I enter the Service Name, I then get a valid connection handle.
Below are both of my connection strings, why does the Oracle example force me to re-enter my Service name (myserver), which is already set in the connection string?
***MS. This works without a prompt.
myconn = SQLSTRINGCONNECT("driver=Microsoft ODBC for Oracle;uid=myid;pwd=mypass;server=myserver;")
***This will connect, but a 'Oracle ODBC driver connect' dialog appears
***first, forcing me to enter a Service Name, which is blank.
myconn = SQLSTRINGCONNECT("driver=Oracle ODBC Driver;uid=myid;pwd=mypass;server=myserver;")
Thanks,
Jerry
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