470,848 Members | 1,321 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,848 developers. It's quick & easy.

Accessing MySQL from VB6

Does anyone know how to access a MySQL server from vb6?

Any suggestions appreciated.

NB
Jul 20 '05 #1
13 14023
Neil Brown wrote:
Does anyone know how to access a MySQL server from vb6?

Any suggestions appreciated.

NB

Hmmm. Can you say ODBC ?
Jul 20 '05 #2
Neil Brown wrote:
Does anyone know how to access a MySQL server from vb6?

Any suggestions appreciated.

NB

Hmmm. Can you say ODBC ?
Jul 20 '05 #3
Neil Brown wrote:
Does anyone know how to access a MySQL server from vb6?

Any suggestions appreciated.

NB

Hmmm. Can you say ODBC ?
Jul 20 '05 #4
How do I access MySQL using ODBC then??

"Justin C. Le Grice" <le*****@nix2spam.i4free.co.nz> wrote in message
news:D2*******************@news02.tsnz.net...
Neil Brown wrote:
Does anyone know how to access a MySQL server from vb6?

Any suggestions appreciated.

NB

Hmmm. Can you say ODBC ?

Jul 20 '05 #5
How do I access MySQL using ODBC then??

"Justin C. Le Grice" <le*****@nix2spam.i4free.co.nz> wrote in message
news:D2*******************@news02.tsnz.net...
Neil Brown wrote:
Does anyone know how to access a MySQL server from vb6?

Any suggestions appreciated.

NB

Hmmm. Can you say ODBC ?

Jul 20 '05 #6
How do I access MySQL using ODBC then??

"Justin C. Le Grice" <le*****@nix2spam.i4free.co.nz> wrote in message
news:D2*******************@news02.tsnz.net...
Neil Brown wrote:
Does anyone know how to access a MySQL server from vb6?

Any suggestions appreciated.

NB

Hmmm. Can you say ODBC ?

Jul 20 '05 #7
At www.mysql.com they have downloads for the drivers you need to make the
ODBC connection.
After download and install go into Control Panel -> ODBC -> and you can
configure it to your DB from there.
"Neil Brown" <neil@cree8uk-REMOVE2REPLY-.freeserve.co.uk> wrote in message
news:c6**********@newsg2.svr.pol.co.uk...
How do I access MySQL using ODBC then??

"Justin C. Le Grice" <le*****@nix2spam.i4free.co.nz> wrote in message
news:D2*******************@news02.tsnz.net...
Neil Brown wrote:
Does anyone know how to access a MySQL server from vb6?

Any suggestions appreciated.

NB

Hmmm. Can you say ODBC ?


Jul 20 '05 #8
At www.mysql.com they have downloads for the drivers you need to make the
ODBC connection.
After download and install go into Control Panel -> ODBC -> and you can
configure it to your DB from there.
"Neil Brown" <neil@cree8uk-REMOVE2REPLY-.freeserve.co.uk> wrote in message
news:c6**********@newsg2.svr.pol.co.uk...
How do I access MySQL using ODBC then??

"Justin C. Le Grice" <le*****@nix2spam.i4free.co.nz> wrote in message
news:D2*******************@news02.tsnz.net...
Neil Brown wrote:
Does anyone know how to access a MySQL server from vb6?

Any suggestions appreciated.

NB

Hmmm. Can you say ODBC ?


Jul 20 '05 #9
At www.mysql.com they have downloads for the drivers you need to make the
ODBC connection.
After download and install go into Control Panel -> ODBC -> and you can
configure it to your DB from there.
"Neil Brown" <neil@cree8uk-REMOVE2REPLY-.freeserve.co.uk> wrote in message
news:c6**********@newsg2.svr.pol.co.uk...
How do I access MySQL using ODBC then??

"Justin C. Le Grice" <le*****@nix2spam.i4free.co.nz> wrote in message
news:D2*******************@news02.tsnz.net...
Neil Brown wrote:
Does anyone know how to access a MySQL server from vb6?

Any suggestions appreciated.

NB

Hmmm. Can you say ODBC ?


Jul 20 '05 #10
I'd be interested to know if you got this to work, because I tried it and
although connecting is quick, a simple SELECT statement on only 100 records
takes over a minute!!

Jerry

"Robin" <rl*****@energymasterllc.com> wrote in message
news:Vo*******************@bignews3.bellsouth.net. ..
At www.mysql.com they have downloads for the drivers you need to make the
ODBC connection.
After download and install go into Control Panel -> ODBC -> and you can
configure it to your DB from there.
"Neil Brown" <neil@cree8uk-REMOVE2REPLY-.freeserve.co.uk> wrote in message
news:c6**********@newsg2.svr.pol.co.uk...
How do I access MySQL using ODBC then??

"Justin C. Le Grice" <le*****@nix2spam.i4free.co.nz> wrote in message
news:D2*******************@news02.tsnz.net...
Neil Brown wrote:
> Does anyone know how to access a MySQL server from vb6?
>
> Any suggestions appreciated.
>
> NB
>
>
Hmmm. Can you say ODBC ?



Jul 20 '05 #11
I'd be interested to know if you got this to work, because I tried it and
although connecting is quick, a simple SELECT statement on only 100 records
takes over a minute!!

Jerry

"Robin" <rl*****@energymasterllc.com> wrote in message
news:Vo*******************@bignews3.bellsouth.net. ..
At www.mysql.com they have downloads for the drivers you need to make the
ODBC connection.
After download and install go into Control Panel -> ODBC -> and you can
configure it to your DB from there.
"Neil Brown" <neil@cree8uk-REMOVE2REPLY-.freeserve.co.uk> wrote in message
news:c6**********@newsg2.svr.pol.co.uk...
How do I access MySQL using ODBC then??

"Justin C. Le Grice" <le*****@nix2spam.i4free.co.nz> wrote in message
news:D2*******************@news02.tsnz.net...
Neil Brown wrote:
> Does anyone know how to access a MySQL server from vb6?
>
> Any suggestions appreciated.
>
> NB
>
>
Hmmm. Can you say ODBC ?



Jul 20 '05 #12
"Jerry Spence" <1@2.com> wrote in message news:<Ki******************@stones.force9.net>...
I'd be interested to know if you got this to work, because I tried it and
although connecting is quick, a simple SELECT statement on only 100 records
takes over a minute!!

Jerry

"Robin" <rl*****@energymasterllc.com> wrote in message
news:Vo*******************@bignews3.bellsouth.net. ..
At www.mysql.com they have downloads for the drivers you need to make the
ODBC connection.
After download and install go into Control Panel -> ODBC -> and you can
configure it to your DB from there.
"Neil Brown" <neil@cree8uk-REMOVE2REPLY-.freeserve.co.uk> wrote in message
news:c6**********@newsg2.svr.pol.co.uk...
How do I access MySQL using ODBC then??

"Justin C. Le Grice" <le*****@nix2spam.i4free.co.nz> wrote in message
news:D2*******************@news02.tsnz.net...
> Neil Brown wrote:
> > Does anyone know how to access a MySQL server from vb6?
> >
> > Any suggestions appreciated.
> >
> > NB
> >
> >
> Hmmm. Can you say ODBC ?



why there is dialogue prompting when i connect MySQL odbc with VB everytime ??
Jul 20 '05 #13

"Somesh Bartakkay" <sm******@rediffmail.com> wrote in message
news:8f**************************@posting.google.c om...
"Jerry Spence" <1@2.com> wrote in message

news:<Ki******************@stones.force9.net>...
I'd be interested to know if you got this to work, because I tried it and although connecting is quick, a simple SELECT statement on only 100 records takes over a minute!!

Jerry

"Robin" <rl*****@energymasterllc.com> wrote in message
news:Vo*******************@bignews3.bellsouth.net. ..
At www.mysql.com they have downloads for the drivers you need to make the ODBC connection.
After download and install go into Control Panel -> ODBC -> and you can configure it to your DB from there.
"Neil Brown" <neil@cree8uk-REMOVE2REPLY-.freeserve.co.uk> wrote in message news:c6**********@newsg2.svr.pol.co.uk...
> How do I access MySQL using ODBC then??
>
> "Justin C. Le Grice" <le*****@nix2spam.i4free.co.nz> wrote in message > news:D2*******************@news02.tsnz.net...
> > Neil Brown wrote:
> > > Does anyone know how to access a MySQL server from vb6?
> > >
> > > Any suggestions appreciated.
> > >
> > > NB
> > >
> > >
> > Hmmm. Can you say ODBC ?
>
>


why there is dialogue prompting when i connect MySQL odbc with VB

everytime ??

When this happens to me in msaccess via odbc, it's because my user id or
password is invalid, or blank.
hth.

bobb
Jul 20 '05 #14

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by sanjay gupta | last post: by
reply views Thread by Bob M | last post: by
4 posts views Thread by Phil Townsend | last post: by
1 post views Thread by zMisc | last post: by
4 posts views Thread by scout3014 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.