>Hi,
>
>I am trying to connect to an Oracle database with the SQLSTRINGCONNECT() function. I send A STRING WITH THE DSN,UID,PWD which brings up a dialogue box with the userid and password entered also requiring the server name. Is there a parameter (like dsn) to send the server name?
>The connect works fine once I manually enter the server name.
>
>TIA
The correct syntax is:
lnHandle = sqlstringconnect('Driver=Microsoft ODBC for Oracle;ConnectString=server_name;UID=myuserid;PWD=mypassword;')
Mark McCasland
Midlothian, TX USA