I need to be able to create an ODBC data source to SQL Server 2008 R2 Express on another computer. I am able to create a DSN using SQLConfigDataSource but it does not allow me to set the user ID and password.
The SQL Server Express on the remote system is configured for SQL authentication. I need to create the data source with the sa user id and password. I am using the SQL API directly and not going through a class library. If, after i run
SQLConfigDataSource, I use the control panel to select SQL authentication, set the user id to "sa" and the password appropriately, the conneciton works.
Anticipating the canned response that it is a security issue, this particular application is running in an environment where security is not an issue.
It is important that I be able to do this programatically. This application is designed for people that are not computer literate and I cannot assume their ability to ...
Go to the complete details ...