I need to connect to an SQL server (seperate pc) from a form where the user can enter a user name and password. These need to be passed to the SQL server to be used to set permissins on the database. I have an ODBC data source set up that works through Access. Is there anything else I need to set up in the connection in terms of the security type and user name/password combination to get this to work via a web app??? I have tried setting up different users with permissions on the database but keep getting errors?
how do I pass the user name and password to the SQL server????
Connection string used was
<cfquery name = cnnstr= Provider=sqloledb datasource=test
username=uername password=pwd>
this generated the following error
Error Diagnostic Information
ODBC Error Code = 28000 (Invalid authorization specification)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.
Data Source = "TEST"
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:47).
how do I pass the user name and password to the SQL server????
Connection string used was
<cfquery name = cnnstr= Provider=sqloledb datasource=test
username=uername password=pwd>
this generated the following error
Error Diagnostic Information
ODBC Error Code = 28000 (Invalid authorization specification)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.
Data Source = "TEST"
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:47).