Hi all,

I'm sorry this is OOT question.

I'm using XP pro. and VS.Net installed in my computer
I'm trying make an ASP page and I use Visual Interdev 6.0. for ASP and  I'm
having problem with this code :

<%
dim rsK,strCon,kata,sql
kata = request.querystring("kata")
if (kata <> "") then
 strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.mdb;Persist
Security Info=False"
 sql = "select * from data"
 set rsK = Server.createObject("ADODB.Recordset")
 rsKamus.open sql,strCon,adOpenDynamic ,adLockPessimistic , adcmdText
else
 response.write("test")
end if
%>

Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/coba/Page1.asp, line 9

does anyone know what wrong with the code ?. Is it caused by VS.NET ?

T.I.A


----------------------------------------------------------------------------

 Ikuti polling TELKOM Memo 166 di www.plasa.com dan menangkan hadiah masing-masing Rp 250.000 tunai

 ----------------------------------------------------------------------------

Are you including the file adovbs.inc at the top of your asp page?

Mark


-----Original Message-----
From: M. Yadi [mailto:bjs52@t...]
Sent: Friday, January 01, 2010 3:26 AM
To: ASP.NET
Subject: [aspx] [OOT] ASP


Hi all,

I'm sorry this is OOT question.

I'm using XP pro. and VS.Net installed in my computer
I'm trying make an ASP page and I use Visual Interdev 6.0. for ASP and  I'm
having problem with this code :

<%
dim rsK,strCon,kata,sql
kata = request.querystring("kata")
if (kata <> "") then
 strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.mdb;Persist
Security Info=False"
 sql = "select * from data"
 set rsK = Server.createObject("ADODB.Recordset")
 rsKamus.open sql,strCon,adOpenDynamic ,adLockPessimistic , adcmdText
else
 response.write("test")
end if
%>

Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/coba/Page1.asp, line 9

does anyone know what wrong with the code ?. Is it caused by VS.NET ?

T.I.A


----------------------------------------------------------------------------

 Ikuti polling TELKOM Memo 166 di www.plasa.com dan menangkan hadiah
masing-masing Rp 250.000 tunai

 ---------------------------------------------------------------------------
-