>>>...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.
I presume that since the book I use was published in 2000, the syntax you describe was not yet available.
Follow up question (I promise to stop asking, today <g>). Does using Connection String without DSN make the data access faster? Or this is just for easier installation/setup?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham