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