I'm trying to create a Connection String between an MS Access 2003 Database and SQL Server 2005. I want to use OLEDB as the provider. And use SQL Server Authentication. I have added the UserID and Password to the Connection String. When do I need to use "Integrated Security = SSPI" and "Persist Security Info = true/false"?
Is there a book and KB article that describes how these are used?
Thanks for your help.
Is there a book and KB article that describes how these are used?
Thanks for your help.