If you're in VB and want to connect to a mySQL database then why not use
myODBC? it's what it's there for.
A simple connection string would be:
strConnectionString="DRIVER={MySQL}; SERVER=server;
DATABASE=database; UID=username; PWD=password;"
To access and manipulate the data use ADO:
When I saw this mail arrive I thought the subject read "Using mySQL in
Biatch mode", I did chuckle a little :)
> -Original Message-
> From: Horacio Santoyo [mailto:[EMAIL PROTECTED]]
> Sent: 05 September 2002 21:13
> To: [EMAIL PROTECTED]
> Subject: Using mySQL in Batch mode
>
>
> Hell
Hmm. I'm not sure what to suggest... sorry! :(
> -Original Message-
> From: Dan Johansson [mailto:[EMAIL PROTECTED]]
> Sent: 05 September 2002 18:30
> To: Ben Joyce
> Cc: [EMAIL PROTECTED]
> Subject: Re: ado/mysql problem
>
>
> Yes, I have now. Do not
ahhh, hmm, erk...
have you checked the MDAC site and MSKB for known bugs?
> -Original Message-
> From: Dan Johansson [mailto:[EMAIL PROTECTED]]
> Sent: 05 September 2002 15:19
> To: Ben Joyce
> Cc: [EMAIL PROTECTED]
> Subject: Re: ado/mysql problem
>
>
>
Yep, I had issues too... I've dropped back to MDAC2.5 and all is well.
.b
> -Original Message-
> From: Dan Johansson [mailto:[EMAIL PROTECTED]]
> Sent: 05 September 2002 15:03
> To: [EMAIL PROTECTED]
> Subject: ado/mysql problem
>
>
> Hi
> After uppgrade mdac from 2.5 to 2.7 I get wr
use mySQLdump.
c:\mysql\bin\mysqldump.exe
there is a switch for dumping the whole DB.
heh,
.b
> -Original Message-
> From: Kai Vermehr [mailto:[EMAIL PROTECTED]]
> Sent: 03 September 2002 13:10
> To: MySQL List
> Subject: script for complete Database dump?
>
>
> is there a
Hi. I'm connecting to a remote mySQL server via myODBC from a VB
application. Is this connection secure? If not, how can I make it so?
Would I have to encrypt the data myself somehow or is there some sort of
secure connex like SSL for port 80?
Any help appreciated.
Cheers,
.ben
-