Recordset Paging works in IIS6 but not in IIIS7

Question

I've got a recordset/paging set up - works fine in IIS6 but when I run the site on an IIS7 server I get the following error:

    Microsoft OLE DB Provider for SQL Server  error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

/orders.asp, line 197

the code looks like this:

  Set objPagingConn = Server.CreateObject("ADODB.Connection")

objPagingConn.Open CONN_STRING

Set objPagingRS = Server.CreateObject("ADODB.Recordset") objPagingRS.PageSize = iPageSize objPagingRS.CacheSize = iPageSize objPagingRS.Open strSQL, objPagingConn, adOpenStatic, adLockReadOnly, adCmdText

iPageCount = objPagingRS.PageCount iRecordCount = objPagingRS.RecordCount

Line 197 is the objPagingConn,Open ... line. I've got about 10 sites like this to migrate - is there a simple fix in IIS7???

Help is greatly appreciated! Many thanks, Martin

Spudhead Spudhead · Accepted Answer · 2010-04-07T14:53:47

After many, many experiments I found a connection string that worked:

Provider=SQLOLEDB.1;Server=123.123.123.123,1433;Initial Catalog=mydb;Persist Security Info=True;User ID=sqladmin;Password=password;

I hope this helps someone else who comes across the same problem - it's been bugging me for so long!

Recordset Paging works in IIS6 but not in IIIS7

3 Answers