|
 |
asp_databases thread: RE: Fail to Open A Recordset
Message #1 by <hijazia@c...> on Sun, 28 Jul 2002 11:46:41 +0300
|
|
yes you have to include the adovbs.inc which is located at c:\program files\common files\system\ado
best regards
Ali Hijazi
>
> From: "Hassan Ali" <technofriend@i...>
> Date: 2002/07/27 Sat AM 06:29:23 GMT+03:00
> To: "ASP Databases" <asp_databases@p...>
> Subject: [asp_databases] RE: Fail to Open A Recordset
>
> if you are still getting the error
> "arguments are of wrong types..."
>
> have you included the adovbs.inc file for you are giving the constant
> names like adOpenDynamic ... in the line below.
>
> rsUsers.Open "Login",objConn,adOpenDynamic,adLockOptimistic,adCmdTable
>
> try including the file
> <! -- #include file="adovbs.inc" --> should be there in your folder or
> define te path to it.
>
> Cheers
> Hassan Ali
>
>
> http://www.adopenstatic.com/faq/800a0bb9.asp
>
>
> > -----Original Message-----
> > From: ozgen [mailto:bk_mandyt@d...]
> > Sent: 21. juli 2002 12:16
> > To: ASP Databases
> > Subject: [asp_databases] Fail to Open A Recordset
> >
> >
> > I am trying to open a recordset by writing this:
> >
> > ---------------------------------------------------------------
> > dim objConn
> > set objConn = Server.CreateObject("ADODB.Connection")
> > objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
> > "Data Source=d:\mydocuments\dissertation\database\university.mdb"
> >
> > Dim rsUsers
> > Set rsUsers=Server.CreateObject("ADODB.Recordset")
> >
> > rsUsers.Open "Login",objConn,adOpenDynamic,adLockOptimistic,adCmdTable
> > ----------------------------------------------------------------
> >
> > However, there is an error message on the line rsUsers.Open.....
> >
> > Error Type:
> > ADODB.Recordset (0x800A0BB9)
> > Arguments are of the wrong type, are out of acceptable range, or are in
> > conflict with one another.
> >
> > I want to let users to add new user records to the login table.
> >
> > Thank you so much.
>
Message #2 by "Hassan Ali" <technofriend@i...> on Sat, 27 Jul 2002 06:29:23
|
|
if you are still getting the error
"arguments are of wrong types..."
have you included the adovbs.inc file for you are giving the constant
names like adOpenDynamic ... in the line below.
rsUsers.Open "Login",objConn,adOpenDynamic,adLockOptimistic,adCmdTable
try including the file
<! -- #include file="adovbs.inc" --> should be there in your folder or
define te path to it.
Cheers
Hassan Ali
http://www.adopenstatic.com/faq/800a0bb9.asp
> -----Original Message-----
> From: ozgen [mailto:bk_mandyt@d...]
> Sent: 21. juli 2002 12:16
> To: ASP Databases
> Subject: [asp_databases] Fail to Open A Recordset
>
>
> I am trying to open a recordset by writing this:
>
> ---------------------------------------------------------------
> dim objConn
> set objConn = Server.CreateObject("ADODB.Connection")
> objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
> "Data Source=d:\mydocuments\dissertation\database\university.mdb"
>
> Dim rsUsers
> Set rsUsers=Server.CreateObject("ADODB.Recordset")
>
> rsUsers.Open "Login",objConn,adOpenDynamic,adLockOptimistic,adCmdTable
> ----------------------------------------------------------------
>
> However, there is an error message on the line rsUsers.Open.....
>
> Error Type:
> ADODB.Recordset (0x800A0BB9)
> Arguments are of the wrong type, are out of acceptable range, or are in
> conflict with one another.
>
> I want to let users to add new user records to the login table.
>
> Thank you so much.
Message #3 by "ozgen" <bk_mandyt@d...> on Sun, 21 Jul 2002 12:15:45
|
|
I am trying to open a recordset by writing this:
---------------------------------------------------------------
dim objConn
set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=d:\mydocuments\dissertation\database\university.mdb"
Dim rsUsers
Set rsUsers=Server.CreateObject("ADODB.Recordset")
rsUsers.Open "Login",objConn,adOpenDynamic,adLockOptimistic,adCmdTable
----------------------------------------------------------------
However, there is an error message on the line rsUsers.Open.....
Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
I want to let users to add new user records to the login table.
Thank you so much.
Message #4 by "Kim Iwan Hansen" <kimiwan@k...> on Sun, 21 Jul 2002 13:30:50 +0200
|
|
http://www.adopenstatic.com/faq/800a0bb9.asp
> -----Original Message-----
> From: ozgen [mailto:bk_mandyt@d...]
> Sent: 21. juli 2002 12:16
> To: ASP Databases
> Subject: [asp_databases] Fail to Open A Recordset
>
>
> I am trying to open a recordset by writing this:
>
> ---------------------------------------------------------------
> dim objConn
> set objConn = Server.CreateObject("ADODB.Connection")
> objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
> "Data Source=d:\mydocuments\dissertation\database\university.mdb"
>
> Dim rsUsers
> Set rsUsers=Server.CreateObject("ADODB.Recordset")
>
> rsUsers.Open "Login",objConn,adOpenDynamic,adLockOptimistic,adCmdTable
> ----------------------------------------------------------------
>
> However, there is an error message on the line rsUsers.Open.....
>
> Error Type:
> ADODB.Recordset (0x800A0BB9)
> Arguments are of the wrong type, are out of acceptable range, or are in
> conflict with one another.
>
> I want to let users to add new user records to the login table.
>
> Thank you so much.
|
|
|
View Cart
