>>...the connection string specifies both the Driver and the Server.
>>lcConnString = "Driver={SQL Server};Server=(local);TrustedConnection=True"
>I was confusing the connection string with a sample connection string in the VFP and SQL Server book, which was:
>"DSN=northwind;UID=sa;PWD;DATABASE=northwind"
>
>Thank you for very much for clarifying it for me.
Ah, yes. I forgot about that form of the Connection String. If you have an existing DSN, the Driver and Server, along with other properties, are read from there.
I've mostly gotten away from creating DSNs, because connection strings can be so much more flexible.