|
 |
asp_databases thread: Error On Read
Message #1 by "Maelaian" <maelaian@s...> on Wed, 19 Sep 2001 14:41:50
|
|
Im tring to set record set with :
43 conn.Open dsn , user, pass
45 set rs = Server.CreateObject("ADODB.RecordSet")
46 RS.Open "select * from Users where UserId = '1'", conn
but i get this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e09'
[Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no
read permission on 'tblUser'.
default.asp, line 46
Message #2 by "Igor" <accesssyst@a...> on Wed, 19 Sep 2001 22:07:23
|
|
Go to your DB ,double click on table "'tblUser",then click "Permissions"
and check all you need.
> Im tring to set record set with :
>
> 43 conn.Open dsn , user, pass
>
> 45 set rs = Server.CreateObject("ADODB.RecordSet")
> 46 RS.Open "select * from Users where UserId = '1'", conn
>
> but i get this error:
>
>
> Microsoft OLE DB Provider for ODBC Drivers error '80040e09'
>
> [Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no
> read permission on 'tblUser'.
>
> default.asp, line 46
Message #3 by "Drew, Ron" <RDrew@B...> on Thu, 20 Sep 2001 08:05:22 -0400
|
|
I would stay away from words that could be/are reserved words. Rename the
Users table to myUsers table and rename the column UserID to myUserID.
Then give it a try and see if it works. Error sounds like it is trying to
read an internal table.
-----Original Message-----
From: Maelaian [mailto:maelaian@s...]
Sent: Wednesday, September 19, 2001 10:42 AM
To: ASP Databases
Subject: [asp_databases] Error On Read
Im tring to set record set with :
43 conn.Open dsn , user, pass
45 set rs = Server.CreateObject("ADODB.RecordSet")
46 RS.Open "select * from Users where UserId = '1'", conn
but i get this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e09'
[Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no
read permission on 'tblUser'.
default.asp, line 46
$subst('Email.Unsub')
|
|
|
View Cart
