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


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.


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")&"')"
Response.Write("Va multumim ca v-ati inscris")
exit do
Response.Write("Campul 'Parola' trebuie sa fie acelasi cu campul 'Confirmare parola'!")
Response.Write("<br />")
Response.Write("<br />")
Response.Write("<br />")
Response.Write("<br />")
Response.Write("Nu ati completat toate campurile!")
exit do
end if
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.