asking about VB - MySQL

Hi, I'm new with MySQL, me and my friend want to
develop program using VB 6 and MySQL,
We want to know is it possible?
How i can connect VB 6 and MySQL? Does anybody has a
sample script/source code (maybe simple program)?
Kindly send me the source code or web site link.
We will appreciate that, sorry if this question has
been asked before

Regards
Edwin




______________________________________________________
Yahoo! for Good
Donate to the Hurricane Katrina relief effort.
http://store.yahoo.com/redcross-donate3/


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: asking about VB - MySQL

Dim cnn as Connection
Dim sServer as String

On Error Goto errHandler
sServer = GetDataServerIP

Set cnn = New Connection
cnn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
& "SERVER=" & sServer & ";" _
& "DATABASE=" & sDataBase & ";" _
& "UID=" & sUser & "; PWD=" & sPWD & ";OPTION=3;"

'With DSN
'cnn.connectionString = "Provider=MSDASQL.1;Persist Security Info=False;Data
Source=" & sDataBase
cnn.Open

....

-----Mensaje original-----
De: edwin [mailto:edwinmln@yahoo.com]
Enviado el: Miércoles, 05 de Octubre de 2005 02:07
Para: win32@lists.mysql.com
Asunto: asking about VB - MySQL


Hi, I'm new with MySQL, me and my friend want to
develop program using VB 6 and MySQL,
We want to know is it possible?
How i can connect VB 6 and MySQL? Does anybody has a
sample script/source code (maybe simple program)?
Kindly send me the source code or web site link.
We will appreciate that, sorry if this question has
been asked before

Regards
Edwin




______________________________________________________
Yahoo! for Good
Donate to the Hurricane Katrina relief effort.
http://store.yahoo.com/redcross-donate3/


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=matias.castilla@hospitali taliano.org.ar


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org