>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
Ashley,
I Haven't worked with Oracle, but with SQLServer, the parameter is simply called "server" (I'm not using any DSN either) :
SQLStringConnect("driver=sql server;server=server_name_goes_here;database=MyDB;uid=MeMyselfAndI;pwd=secret")
Hope this helps!
Sylvain Demers