469,327 Members | 1,199 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,327 developers. It's quick & easy.

i have a problem

Hi,

When I try to access my MySQL database with VB5 through ODBC, I get the dreaded error message "Error: 3027. Can't update. Database or object is read-only".

On the internet I found several others who experience the same problems. Yet nowhere I can find a satisfactory solution.

So, what's going on? What am I doing wrong? All help is greatly appreciated.

Below is the VB5 code I'm using. The error is of course on the "rs.AddNew" statement.

Greetings,
elena


This is my ASP code

<%
Dim db
Dim rs
Set db=Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.RecordSet")
db.open sDSN
rs.open "SELECT * FROM cont_angajati" ,db,2,2,1
do while NOT rs.EOF
if Request.Form("id")=rs("id") then
Response.Write("Acest id exista in baza de date!!!!")
ElseIf Request.Form("id")<>"" and Request.Form("password")<>"" and Request.Form("confirm")<>"" and Request.Form("password")=Request.Form("confirm") then
'sSQL="INSERT INTO cont_angajati ([id],[parola],[conf_parola]) values('"&Request.Form("id")&"','"&Request.Form("p assword")&"','"&Request.Form("confirm")&"')"
'db.execute(sSQL)
rs.AddNew
rs("id")=Request.Form("id")
rs("parola")=Request.Form("password")
rs("conf_parola")=Request.Form("confirm")
rs.Update
Response.Write("Va multumim ca v-ati inscris")
exit do
else
Response.Write("Campul 'Parola' trebuie sa fie acelasi cu campul 'Confirmare parola'!")
Response.Write("<br />")
Response.Write("<br />")
Response.Write("SAU")
Response.Write("<br />")
Response.Write("<br />")
Response.Write("Nu ati completat toate campurile!")
exit do
end if
rs.MoveNext
Loop
%>
Apr 3 '07 #1
0 814

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

11 posts views Thread by Kostatus | last post: by
117 posts views Thread by Peter Olcott | last post: by
18 posts views Thread by Ian Stanley | last post: by
28 posts views Thread by Jon Davis | last post: by
6 posts views Thread by Ammar | last post: by
2 posts views Thread by Mike Collins | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.