ASP Connection Strings

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

Tags: , , ,

ASP

Powered by BlogEngine.NET 1.6.0.0
Theme by Mads Kristensen