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
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.