>>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;
>

Thanks for that information, Cetin.

Making those changes and trying the SQLStringConnect, it still asks for a DSN. It was my remembering that SQLStringConnect would connect without a DSN, nor would it require one. Am I mis-remembering?