hi,
first of all: i am a beginner...
i am working with PWS. i stored a database in my directory and want to do just basic things with it. it seems that i can connect to the database as i don't get an error message when i start this code:
<HTML>
<HEAD>
<TITLE>Student Records</TITLE>
</HEAD>
<BODY>
<%
Session.timeout = 15
Set conn = Server.CreateObject("ADODB.Connection"
conn.open "db","username","password"
Set Session("MyDB_conn" = conn
%>
<%
conn.close
set conn = Nothing
%>
</BODY>
</HTML>
whereas when i put something like
<%
strSQLQuery = "SELECT * FROM hallo"
Set rs = Server.CreateObject("ADODB.Recordset"
rs.Open strSQLQuery, conn, 3, 3
%>
in between i get an error message which says that i don't habe permission to read from "hallo"... i don't know what do to because in my point of view i have done everything perfectly alright... i wouldn't even know where to go to get that permission.
here is the full error message. i know it is in german but anyway...
Microsoft OLE DB Provider for ODBC Drivers-Fehler '80040e09'
[Microsoft][ODBC Microsoft Access Driver] Datensätze können nicht gelesen werden. Keine Leseberechtigung auf 'hallo'.
/Default.asp, Zeile 17
please help!
kind regards,
stefan
first of all: i am a beginner...
i am working with PWS. i stored a database in my directory and want to do just basic things with it. it seems that i can connect to the database as i don't get an error message when i start this code:
<HTML>
<HEAD>
<TITLE>Student Records</TITLE>
</HEAD>
<BODY>
<%
Session.timeout = 15
Set conn = Server.CreateObject("ADODB.Connection"
conn.open "db","username","password"
Set Session("MyDB_conn"
= conn%>
<%
conn.close
set conn = Nothing
%>
</BODY>
</HTML>
whereas when i put something like
<%
strSQLQuery = "SELECT * FROM hallo"
Set rs = Server.CreateObject("ADODB.Recordset"
rs.Open strSQLQuery, conn, 3, 3
%>
in between i get an error message which says that i don't habe permission to read from "hallo"... i don't know what do to because in my point of view i have done everything perfectly alright... i wouldn't even know where to go to get that permission.
here is the full error message. i know it is in german but anyway...
Microsoft OLE DB Provider for ODBC Drivers-Fehler '80040e09'
[Microsoft][ODBC Microsoft Access Driver] Datensätze können nicht gelesen werden. Keine Leseberechtigung auf 'hallo'.
/Default.asp, Zeile 17
please help!
kind regards,
stefan