MySQL Forums
Forum List  »  Quality Assurance

vb6 connect to mysql
Posted by: melvin tee
Date: October 28, 2008 06:21AM

my program can connect, but cannot edit database...how come??
the program is work well with ms access..
well, this is the code~

Public Function iOpenDatabase(IsReadOnly As Boolean) As Database
Dim dbs As Database
On Error GoTo errdet

Set dbs = OpenDatabase(SERVER, False, IsReadOnly, "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=SERVER; PORT=3306; DATABASE=sims; Uid=root;Pwd=ablesoft; OPTION=3")
Set iOpenDatabase = dbs
Exit Function

errdet:
MsgBox Err.Description, vbInformation, MsgTitle
End
End Function

Options: ReplyQuote


Subject
Views
Written By
Posted
vb6 connect to mysql
6520
October 28, 2008 06:21AM
3328
November 10, 2008 03:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.