ADODB.Recordset error '800a0bb9' - Pleazzze

[mrkipling]

ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

can anyone help me with this error message, Ive trawled my way through
hundreds of posts about it and still cannot find an answer,
All of my .asp pages are resulting in the same error message , so i
figure it has to be somthing to do with either the database or the
include file. This is the code from one of the pages

<%@LANGUAGE=&quot;VBSCRIPT&quot;%>
<!--#include file=&quot;Connections/connhotpipe.asp&quot; -->
<%
set Recordset1 = Server.CreateObject(&quot;ADODB.Recordset&quot
Recordset1.ActiveConnection = MM_connhotpipe_STRING
Recordset1.Source = &quot;SELECT * FROM IndexPageData&quot;
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0


My site works fine on my local server running IIS 5 but when i upload
it to a Remote server (

http://www2.domaindlx.com)

it gives the above error
message.

I have run a test page to Using the code: -

The path to this page is: <B> <%= Server.MapPath(&quot;\&quot%> </B>

Which gives me the following result

The path to this page is: d:\www2

Now this is not the correct path it should be giving me on the remote
server is it ?

I am also using an auto insert date function in the Acces 2000 table
that these pages link to, Could this have anything to do with it ???

Any help would be most appreciated

Thanks MArk