>It's been awhile and I'm trying to connect to a MSSQL server with the following
>
>myconnstr = "driver = SQL Server; server=IPaddress; database=myDB; uid=myID; pwd=myPassword"
>
>when I issue the myconnection = SQLStringConnect(myconnstr) it keeps popping up asking me to select a DNS.
>
>What am I forgetting?
>tia
Hi Dorris,
Other than the driver written as Gregory Adam suggested, I would recommend you to add
;APP=YourApplicationName which is not necessary but very helpful if you are debugging using SQL Server Profiler (I also set WSID to SYS(0), but I think if you do not set it it will still work with the client's computer name anyways)
Cheers,
Hugo
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges