by Nathan
9. February 2009 14:26
This is an example of a connection string for ASP (JScript and VBScript)
var connString = "Provider=sqloledb; Network Library=DBMSSOCN; Data Source=10.1.1.1;User
ID=exampleUser; Password=examplePassword;Connection
Timeout=90;Application Name=MyApplication;"
I came across the following errors in my ASP Code when my connection string was not setup correctly.
Microsoft OLE DB Provider for SQL Server error '80040e4d'
Invalid authorization specification
The problem was my original connection string did not have the userid and password credentials
Invalid connection string attribute
Invalid Data in either Password and/or Username or Initial Catalog etc