>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
Driver={SQL Server Native Client 11.0};server=<IPAddress or just a dot for local machine>[, <port if not default>]\instanceName;database=myDb;Trusted_Connection=yes;
{SQL Server} is the old 2000 driver, prefer newer ones like {SQL Server Native Client 11.0}.
A typical connection to local SQLExpress instance Northwind database:
Driver={SQL Server Native Client 11.0};server=.\SQLExpress;database=Northwind;Trusted_Connection=yes;