error message

[FOXPROG]

I am receiving the error message
"ADODB.Connection(0x800a0BB9)
arguments are of the wrong type , are out of acceptable range, or are in conflict with one another" but the same ASP code works perfect on my other server. I am attempting to connect to a MS ACCESS database when this error occurs any thoughts?

Thanks
Frank

 

[GaryC123]

Can you post the relevant code for your data access Saturday 12.00

20.00

3.00am

Sunday [img http

 

[FOXPROG]

Here it is.

<!--#INCLUDE FILE=&quot;_ScriptLibrary/Recordset.ASP&quot;-->
<SCRIPT LANGUAGE=&quot;JavaScript&quot; RUNAT=&quot;server&quot;>
function _initRecordset1()
{
var DBConn = Server.CreateObject('ADODB.Connection');
DBConn.ConnectionTimeout = Application('Connection2_ConnectionTimeout');
DBConn.CommandTimeout = Application('Connection2_CommandTimeout');
DBConn.CursorLocation = Application('Connection2_CursorLocation');
DBConn.Open(Application('Connection2_ConnectionString'), Application('Connection2_RuntimeUserName'), Application('Connection2_RuntimePassword'));
var cmdTmp = Server.CreateObject('ADODB.Command');
var rsTmp = Server.CreateObject('ADODB.Recordset');
cmdTmp.ActiveConnection = DBConn;
rsTmp.Source = cmdTmp;
cmdTmp.CommandType = 1;
cmdTmp.CommandTimeout = 10;
cmdTmp.CommandText = 'select * from user';
rsTmp.CacheSize = 10;
rsTmp.CursorType = 3;
rsTmp.CursorLocation = 3;
rsTmp.LockType = 3;
Recordset1.setRecordSource(rsTmp);
Recordset1.open();
if (thisPage.getState('pb_Recordset1') != null)
Recordset1.setBookmark(thisPage.getState('pb_Recordset1'));
}
function _Recordset1_ctor()
{
CreateRecordset('Recordset1', _initRecordset1, null);
}
function _Recordset1_dtor()
{
Recordset1._preserveState();
thisPage.setState('pb_Recordset1', Recordset1.getBookmark());
}
</SCRIPT>

 

[GaryC123]

The above is within a javascript tag not ASP. Saturday 12.00

20.00

3.00am

Sunday [img http

 

[FOXPROG]

I am new at this does that mean it is a javascript problem and not and asp problem?