The SQLSETPROP() does stop the dialog from displaying but now I DON'T get a valid connection handle.
I believe the problem is in my connection string. The following works if I use the MS driver. But it does not work with the Oracle driver. With the Oracle driver, a dialog asks for a Service name (which is blank in the dialog). If I type in 'myserver' into the dialog, I do get a valid connection. However, 'server=myserver;' already exists in the string.
There must be a different setting I need when using the Oracle driver?
myconn = SQLSTRINGCONNECT("driver=Oracle ODBC Driver;uid=myid;pwd=mypass;server=myserver;")
How can I fix the above string to stop the dialog from appearing?
Thanks,
Jerry
>Try with this
>
>SQLSETPROP(0,"DispLogin",3)
>
>HTH
>
>
>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,