Answered
ASP.NET database connection failure
I'm trying set up a database connection between an ASP.NET C#
site and my SQL server database using DW CS3. I'm getting the
generic Unauthorized error code. ("HTTP Error Code 401
Unauthorized").
I've tried to create connections to the SQL server using both a SQL server connection and also using the OLE DB connection. When I use the OLE DB connection I've tried using the "Build" wizard button. The wizard has a "Test Connection" on the "Connection" tab. When I test the connection here, it says that I the connection is successful. However, when I test using the connection string dialog box, I get the Unauthorized error. The following is the connection information. I know the information is correct because I am able to use MS Visual Web Developer to connect to the DB using the same information (actually I'm using the SQL server connection rather than the OLE connection in VWD).
I've given the itembank_user all permissions in the DB. Is there something I'm missing here, or is there some bug in DW CS3's ASP.NET connection. Have others of you been able to create ASP.NET connections using DW3?
"Provider=SQLOLEDB.1;
Password=itembank_pw;
Persist Security Info=True;
User ID=itembank_user;
Initial Catalog=ItemBank;
Data Source=dpsat01"
Thanks much for any help.
Steve
I've tried to create connections to the SQL server using both a SQL server connection and also using the OLE DB connection. When I use the OLE DB connection I've tried using the "Build" wizard button. The wizard has a "Test Connection" on the "Connection" tab. When I test the connection here, it says that I the connection is successful. However, when I test using the connection string dialog box, I get the Unauthorized error. The following is the connection information. I know the information is correct because I am able to use MS Visual Web Developer to connect to the DB using the same information (actually I'm using the SQL server connection rather than the OLE connection in VWD).
I've given the itembank_user all permissions in the DB. Is there something I'm missing here, or is there some bug in DW CS3's ASP.NET connection. Have others of you been able to create ASP.NET connections using DW3?
"Provider=SQLOLEDB.1;
Password=itembank_pw;
Persist Security Info=True;
User ID=itembank_user;
Initial Catalog=ItemBank;
Data Source=dpsat01"
Thanks much for any help.
Steve
AdChoices