Neil Brown wrote:[color=blue]
> Does anyone know how to access a MySQL server from vb6?
>
> Any suggestions appreciated.
>
> NB
>
>[/color]
Hmmm. Can you say ODBC ?
Neil Brown wrote:[color=blue]
> Does anyone know how to access a MySQL server from vb6?
>
> Any suggestions appreciated.
>
> NB
>
>[/color]
Hmmm. Can you say ODBC ?
Neil Brown wrote:[color=blue]
> Does anyone know how to access a MySQL server from vb6?
>
> Any suggestions appreciated.
>
> NB
>
>[/color]
Hmmm. Can you say ODBC ?
"Justin C. Le Grice" <legrice@nix2sp am.i4free.co.nz > wrote in message
news:D2mgc.1783 $cY5.125362@new s02.tsnz.net...[color=blue]
> Neil Brown wrote:[color=green]
> > Does anyone know how to access a MySQL server from vb6?
> >
> > Any suggestions appreciated.
> >
> > NB
> >
> >[/color]
> Hmmm. Can you say ODBC ?[/color]
"Justin C. Le Grice" <legrice@nix2sp am.i4free.co.nz > wrote in message
news:D2mgc.1783 $cY5.125362@new s02.tsnz.net...[color=blue]
> Neil Brown wrote:[color=green]
> > Does anyone know how to access a MySQL server from vb6?
> >
> > Any suggestions appreciated.
> >
> > NB
> >
> >[/color]
> Hmmm. Can you say ODBC ?[/color]
"Justin C. Le Grice" <legrice@nix2sp am.i4free.co.nz > wrote in message
news:D2mgc.1783 $cY5.125362@new s02.tsnz.net...[color=blue]
> Neil Brown wrote:[color=green]
> > Does anyone know how to access a MySQL server from vb6?
> >
> > Any suggestions appreciated.
> >
> > NB
> >
> >[/color]
> Hmmm. Can you say ODBC ?[/color]
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.u k> wrote in message
news:c60r86$40l $1@newsg2.svr.p ol.co.uk...[color=blue]
> How do I access MySQL using ODBC then??
>
> "Justin C. Le Grice" <legrice@nix2sp am.i4free.co.nz > wrote in message
> news:D2mgc.1783 $cY5.125362@new s02.tsnz.net...[color=green]
> > Neil Brown wrote:[color=darkred]
> > > Does anyone know how to access a MySQL server from vb6?
> > >
> > > Any suggestions appreciated.
> > >
> > > NB
> > >
> > >[/color]
> > Hmmm. Can you say ODBC ?[/color]
>
>[/color]
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.u k> wrote in message
news:c60r86$40l $1@newsg2.svr.p ol.co.uk...[color=blue]
> How do I access MySQL using ODBC then??
>
> "Justin C. Le Grice" <legrice@nix2sp am.i4free.co.nz > wrote in message
> news:D2mgc.1783 $cY5.125362@new s02.tsnz.net...[color=green]
> > Neil Brown wrote:[color=darkred]
> > > Does anyone know how to access a MySQL server from vb6?
> > >
> > > Any suggestions appreciated.
> > >
> > > NB
> > >
> > >[/color]
> > Hmmm. Can you say ODBC ?[/color]
>
>[/color]
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.u k> wrote in message
news:c60r86$40l $1@newsg2.svr.p ol.co.uk...[color=blue]
> How do I access MySQL using ODBC then??
>
> "Justin C. Le Grice" <legrice@nix2sp am.i4free.co.nz > wrote in message
> news:D2mgc.1783 $cY5.125362@new s02.tsnz.net...[color=green]
> > Neil Brown wrote:[color=darkred]
> > > Does anyone know how to access a MySQL server from vb6?
> > >
> > > Any suggestions appreciated.
> > >
> > > NB
> > >
> > >[/color]
> > Hmmm. Can you say ODBC ?[/color]
>
>[/color]
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" <rlaxton@energy masterllc.com> wrote in message
news:VoSgc.4592 4$951.26774@big news3.bellsouth .net...[color=blue]
> 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.u k> wrote in message
> news:c60r86$40l $1@newsg2.svr.p ol.co.uk...[color=green]
> > How do I access MySQL using ODBC then??
> >
> > "Justin C. Le Grice" <legrice@nix2sp am.i4free.co.nz > wrote in message
> > news:D2mgc.1783 $cY5.125362@new s02.tsnz.net...[color=darkred]
> > > Neil Brown wrote:
> > > > Does anyone know how to access a MySQL server from vb6?
> > > >
> > > > Any suggestions appreciated.
> > > >
> > > > NB
> > > >
> > > >
> > > Hmmm. Can you say ODBC ?[/color]
> >
> >[/color]
>
>[/color]
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" <rlaxton@energy masterllc.com> wrote in message
news:VoSgc.4592 4$951.26774@big news3.bellsouth .net...[color=blue]
> 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.u k> wrote in message
> news:c60r86$40l $1@newsg2.svr.p ol.co.uk...[color=green]
> > How do I access MySQL using ODBC then??
> >
> > "Justin C. Le Grice" <legrice@nix2sp am.i4free.co.nz > wrote in message
> > news:D2mgc.1783 $cY5.125362@new s02.tsnz.net...[color=darkred]
> > > Neil Brown wrote:
> > > > Does anyone know how to access a MySQL server from vb6?
> > > >
> > > > Any suggestions appreciated.
> > > >
> > > > NB
> > > >
> > > >
> > > Hmmm. Can you say ODBC ?[/color]
> >
> >[/color]
>
>[/color]
"Jerry Spence" <1@2.com> wrote in message news:<KiUmc.140 3$NK4.94765@sto nes.force9.net> ...[color=blue]
> 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" <rlaxton@energy masterllc.com> wrote in message
> news:VoSgc.4592 4$951.26774@big news3.bellsouth .net...[color=green]
> > 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.u k> wrote in message
> > news:c60r86$40l $1@newsg2.svr.p ol.co.uk...[color=darkred]
> > > How do I access MySQL using ODBC then??
> > >
> > > "Justin C. Le Grice" <legrice@nix2sp am.i4free.co.nz > wrote in message
> > > news:D2mgc.1783 $cY5.125362@new s02.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 ?
> > >
> > >[/color]
> >
> >[/color][/color]
why there is dialogue prompting when i connect MySQL odbc with VB everytime ??
"Somesh Bartakkay" <smallbee@redif fmail.com> wrote in message
news:8f198e47.0 405110518.27c63 769@posting.goo gle.com...[color=blue]
> "Jerry Spence" <1@2.com> wrote in message[/color]
news:<KiUmc.140 3$NK4.94765@sto nes.force9.net> ...[color=blue][color=green]
> > I'd be interested to know if you got this to work, because I tried it[/color][/color]
and[color=blue][color=green]
> > although connecting is quick, a simple SELECT statement on only 100[/color][/color]
records[color=blue][color=green]
> > takes over a minute!!
> >
> > Jerry
> >
> > "Robin" <rlaxton@energy masterllc.com> wrote in message
> > news:VoSgc.4592 4$951.26774@big news3.bellsouth .net...[color=darkred]
> > > At www.mysql.com they have downloads for the drivers you need to make[/color][/color][/color]
the[color=blue][color=green][color=darkred]
> > > ODBC connection.
> > > After download and install go into Control Panel -> ODBC -> and you[/color][/color][/color]
can[color=blue][color=green][color=darkred]
> > > configure it to your DB from there.
> > >
> > >
> > > "Neil Brown" <neil@cree8uk-REMOVE2REPLY-.freeserve.co.u k> wrote in[/color][/color][/color]
message[color=blue][color=green][color=darkred]
> > > news:c60r86$40l $1@newsg2.svr.p ol.co.uk...
> > > > How do I access MySQL using ODBC then??
> > > >
> > > > "Justin C. Le Grice" <legrice@nix2sp am.i4free.co.nz > wrote in[/color][/color][/color]
message[color=blue][color=green][color=darkred]
> > > > news:D2mgc.1783 $cY5.125362@new s02.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 ?
> > > >
> > > >
> > >
> > >[/color][/color]
>
> why there is dialogue prompting when i connect MySQL odbc with VB[/color]
everytime ??
When this happens to me in msaccess via odbc, it's because my user id or
password is invalid, or blank.
hth.
Comment