Hi
Thanks to all of you. I've got the file already.
Regards
Eugénio
Robert Henkel wrote:
> Try going here for the file
>
> http://www.mysql.com/Downloads/Contrib/MyTool-DLL_for_VB_and_MySQL.zip
> and go to this page for some info on the dll
> http://www.icarz.com/mysql/
> Good Luck!
> -----Original Message-----
> From: Warren van der Merwe [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 11, 2001 7:37 AM
> To: 'Eugénio Veiga'
> Cc: [EMAIL PROTECTED]
> Subject: RE: how to access mysql using vb as front end
>
> 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
>
> ---------------------------------------------------------------------
> 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
