Hi there
Herewith is the DLL you require (sent on seperate email so as not to clog
the group). This zip file includes the source for the dll as well as some
documentation. Really easy to use and even more so if you already familiar
with ADO.
Regards
Warren
Some sample code
Private Sub Form_Load()
Dim rst as new MYSQL_RS
Dim myDB as new MYSL_CONNECTION
myDB.OpenConnection "localhost", "root", "", "Test"
if mydb.error.number<> 0 then goto errorrun
set rst = mydb.execute("SELECT * FROM test ORDER BY id")
if mydb.error.number<> 0 then goto errorrun
while not rst.eof
text1=trim(rst.fields("Name").value)
rst.movenext
wend
rst.closerecordset
mydb.closeconnection
Exit Sub
ErrorRun:
msgbox "Number : " & mydb.error.number & " Description : " &
mydb.error.description,vbcritical,"Error!"
End Sub
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Africa
Cell (+27-83) 262-9163
Office (+27-31) 767-0249
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> ]On Behalf
> Of Eugénio Veiga
> Sent: 11 May 2001 12:54
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: how to access mysql using vb as front end
>
>
> Hi
>
> I've been looking in mysql.com and I didn't find myvbql.dll.
> The MySql website you
> talk is www.mysql.com?
> You know all the functions and Sub of the dll that can be used ?
>
> Thanks
>
> Eugénio Veiga
>
> Warren van der Merwe wrote:
>
> > Hi
> >
> > I am successfully developing with VB and MYSQL using the
> MYSQL API, which
> > can be found on the mysql website, look at the download
> section and it is
> > called myvbql.dll
> >
> > Similar to ADO, but a little different.
> >
> > Works like a dream
> > Warren
> >
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > Warren van der Merwe
> > Software Director
> > PRT Trading (Pty) Ltd t/a RedTie
> > Durban, South Africa
> > Cell (+27-83) 262-9163
> > Office (+27-31) 767-0249
> >
> > > -----Original Message-----
> > > From: [EMAIL PROTECTED]
> > > [mailto:[EMAIL PROTECTED]
> > > ]On Behalf
> > > Of phani krishna S.V
> > > Sent: 11 May 2001 09:59
> > > To: [EMAIL PROTECTED]
> > > Subject: how to access mysql using vb as front end
> > >
> > >
> > > hi,
> > > i am using vb as frontend.can we use database as mysql.can we
> > > access data using mysql ac database.if so how.pls send me teh
> > > details at the earliest.
> > > regards,
> > > venkat
> > >
> > >
> > > Join 18 million Eudora users by signing up for a free Eudora
> > > Web-Mail account at http://www.eudoramail.com
> > >
> > >
> ---------------------------------------------------------------------
> > > Before posting, please check:
> > > http://www.mysql.com/manual.php (the manual)
> > > http://lists.mysql.com/ (the list archive)
> > >
> > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> > > <[EMAIL PROTECTED]>
> > > Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
> > >
> > >
> > >
> >
> >
> ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
