SQL Connection in Dreamweaver
Maybe I'm being dense today. This usually works for me...
When I try to add a SQL Connection in the Databases panel, I generate the connection string in web.config:
"Persist Security Info=False;
Data Source=example.edu;
Initial Catalog=databasename;
User ID=xxxxxxxx;
Password=zzzzzzzz"
When testing, it results in the (uninformative) error:
"HTTP error code 500 internal server error"
I've tried variations, including using the OLE SQL connection, setting Persist Security Info to "True," replacing the User ID and Password with SSPI (Windows NT integrated) security, all in various combinations. None work. Using the OLE connection gives me access to the Windows Data Link Properties window, which allows me to put in my settings, and they test successfully in that window. However, when OK'd and back in the Dreamweaver OLE DB Connection window, the generated string results in the same 500 error.
The testing server model is ASP.NET VB.
Any suggestions?
When I try to add a SQL Connection in the Databases panel, I generate the connection string in web.config:
"Persist Security Info=False;
Data Source=example.edu;
Initial Catalog=databasename;
User ID=xxxxxxxx;
Password=zzzzzzzz"
When testing, it results in the (uninformative) error:
"HTTP error code 500 internal server error"
I've tried variations, including using the OLE SQL connection, setting Persist Security Info to "True," replacing the User ID and Password with SSPI (Windows NT integrated) security, all in various combinations. None work. Using the OLE connection gives me access to the Windows Data Link Properties window, which allows me to put in my settings, and they test successfully in that window. However, when OK'd and back in the Dreamweaver OLE DB Connection window, the generated string results in the same 500 error.
The testing server model is ASP.NET VB.
Any suggestions?
