Recordset Paging works in IIS6 but not in IIIS7
- by Spudhead
Hi there,
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