Hi Mark,

Thanks for the reply. I did try your syntax but still got asked for the server. I suspect that the fault lies in incorrect ODBC setup by me. For now, I am getting around it by stuffing the keyboard with the appropriate string - which works just fine.

Rgds

>The correct syntax is:
>
>lnHandle = sqlstringconnect('Driver=Microsoft ODBC for Oracle;ConnectString=server_name;UID=myuserid;PWD=mypassword;')