Hi Jerry,
myconn = SQLSTRINGCONNECT("driver=Oracle ODBC Driver;uid=myid;pwd=mypass;dbq=ORACLE_SERVICE_NAME;")
MartinJ
>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