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