RE: mysql connection with VB
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:
dim cnnConnection as adodb.connection
set cnnConnection = new adodb.connection
cnnConnection.open strConnectionString
if err 0 or cnnConnection.State 1 then
'error handling
end if
'do database stuff
cnnConnection.Close
set cnnConnection = nothing
hth,
.ben
-Original Message-
From: Marcelo Miorelli - ProCAD [mailto:[EMAIL PROTECTED]]
Sent: 06 September 2002 17:36
To: [EMAIL PROTECTED]
Subject: mysql connection with VB
Hi list,
I am developing a program in visual basic, ans as I am brand
new to mysql
database, I would like to know from you which are the proper
ways to access
the database from my vb program. I know there could be using
odbc, but I
would rather not to use it at all.
We´re working for windows, but I am pretty inclined to start
with the Linux
as sson as possible. In some months I believe our server will
be running
Linux with Samba.
Hope you are well,
thanks in advance,
Marcello Miorelli
-
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
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 wrong types. An unsigned integer column was previously reported to be of type 3 (Integer) now it is returned as type 5(double). This atleast happens when im using getrows() in the recordset object. Can anybody tell what is going on here ? Im using mysql-3.23.52 and myodbc 2.50.39 on WinME thanks /Dan - 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
RE: ado/mysql problem
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 I know the same issus exist on XP. One can't downgrade mdac on XP ?? So I really would like an other solution. /Dan Ben Joyce wrote: 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 wrong types. An unsigned integer column was previously reported to be of type 3 (Integer) now it is returned as type 5(double). This atleast happens when im using getrows() in the recordset object. Can anybody tell what is going on here ? Im using mysql-3.23.52 and myodbc 2.50.39 on WinME thanks /Dan - 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
RE: ado/mysql problem
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 find anything :( Ben Joyce wrote: 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 I know the same issus exist on XP. One can't downgrade mdac on XP ?? So I really would like an other solution. /Dan Ben Joyce wrote: 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 wrong types. An unsigned integer column was previously reported to be of type 3 (Integer) now it is returned as type 5(double). This atleast happens when im using getrows() in the recordset object. Can anybody tell what is going on here ? Im using mysql-3.23.52 and myodbc 2.50.39 on WinME thanks /Dan - 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
RE: Using mySQL in Batch mode
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 Hello mySQL users, I'm a new mySQL user, just installed it two days ago. I have a quick question... I have a .sql script that I want to run on mySQL server. I have a Windows XP machine and when I read the mySQL manual, I think they were talking about a Unix machine. This is what the manual said to do... shell mysql batch-file But my command line looks like this... mysql so how do I run the script? This is probably a real simple question, but I can't figure it out yet. Thanks --Horacio - 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
RE: script for complete Database dump?
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 any single MySQL script that would backup my complete database? thanks! Kai - 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
secure mySQL connection
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 -- ben joyce // [EMAIL PROTECTED] // +44 (0)7958 933718 // http://www.babelfish.co.uk - 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
