>
>Thank you, I will try SQL Server authentication.
>BTW, how do you build the connection string to connect to the SQL server? If a user has to enter a password for the SQL server authentication, do they enter it when they login or you have some sort of config file where you keep the connection information? I am struggling with the security part. Another question are you keeping your connection open throughout the life of the application?
>
>Thank you again.
>
You are welcome.
I keep the connection properties, including user name and password in a plain XML file. User is not prompted. On start-up of the application I have a class that opens this XML file, gets all the data necessary for creating a connection and creates a connection. I keep the connection open throughout the life of the application. Keep in mind that I only have (currently) two VFP applications that use SQL Server. One is used by a customer with only 3 users. The other one I use - in-house- for my company use . So I can't say that I have great deal of experience. I am currently working on converting a fairly large application to SQL Server (this is my main application).
HTH.
"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