Connection Error

[anon1971]

The code below works fine on win 2003 server running SQL Express 2003 but it gives an error when I upgraded to Win 2011 SQL Express Server 2008 R2. I am stumped...


Error
ADODB.Connection error '800a0e7a'

Provider cannot be found. It may not be properly installed.

/apps/cs/login.asp, line 20



Code
set rs = Server.CreateObject ("ADODB.Recordset")
Set conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString = "Provider=SQLNCLI;Server=SERVER\SQLEXPRESS;Database=GE_Data;Trusted_Connection=yes;"
Conn.Open

 

[gmmastros]

You need to download and install the native client driver.

http://www.microsoft.com/download/en/details.aspx?id=16978

Scroll down to: Microsoft® SQL Server® 2008 R2 Native Client

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[anon1971]

Thats not it, it has somthing to do with ASP on IIS 7.5 that just want work

 

[gmmastros]

Did you try installing the native client driver on the IIS computer?

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[anon1971]

Wow really 4 12hour days upgrading our server a this is what stumpped me LOL. All I can do is laugh!!! Below is is the fix, thanks guys...

Does Not Work With IIS 7.5
Provider=SQLNCLI;Server=SERVER\SQLEXPRESS;Database=GE_Data;Trusted_Connection=yes;

Does WORK WITH IIS 7.5
Provider=SQLOLEDB;Server=SERVER\SQLEXPRESS;Database=GE_Data;Trusted_Connection=yes;