Re: VB6 + MySQL

Hello Nuno,

My responses are intermingled below...

Nuno Vaz Oliveira wrote:
>
> Hello!
>
> I'm thinking to develop a database interface for our company and I 
> thought "great" when I discovered that Visual Basic 6 was able to 
> interact with MySQL. That's because VB6 is very easy and PHP (even 
> being fast, but its hard for me) gets slower because the source code 
> for HTML pages needs to go from the server to the client and big pages 
> must carry the data and the tags, images, css, formating, etc...
>
> However I'm not going to start a project without knowing that VB6+ODBC 
> Driver is able to do all the needed operations to 
> connect/read/write/insert/update a database.
>
Yes, the ODBC drivers have been doing all of those things for a long time.

> Additionaly I would like to know if I can manage users from VB and to 
> backup the DB.
>
"Manage users" is a vague term. Do you mean:
a) manage MySQL database login accounts
or
b) manage application user information

You can backup the DB but this is generally not an action performed by 
client applications. There are number of methods available for backing 
up a MySQL server. A good place to start reading for ideas would be: 
http://dev.mysql.com/doc/refman/5.0/en/disaster-prevention.html

> If anyone can tell me something about it I appreciate. I would also 
> "like" (Not Mandatory) to use a secure connection (SSL) but I don't 
> know if this is possible using VB6/ODBC Driver.
>
Yes, the ODBC drivers support SSL connections. This is harder to setup 
on Windows systems as they typically are not shipped with the same set 
of SSL tools as Linux systems but it is possible and has been tested.

Other options for encrypting network transfers:
* a VPN connection from the client to the server
* an SSH connection between the client and the server.
> Note: The MySQL Database will be served from our company server.
> (Any links to tutorials/tips/recommendations/forums about this subject 
> are also welcome)
>
The manual has a fairly good quantity of material covering the ODBC 
drivers and their uses and configuration. You may want to start here: 
http://dev.mysql.com/doc/refman/5.0/en/myodbc-connector.html

> Thanks
>
> - Nuno
My pleasure!

-- 
Shawn Green, Support Engineer
MySQL Inc., USA, www.mysql.com
Office: Blountville, TN

Are you MySQL certified?  www.mysql.com/certification
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    
 / /|_/ / // /\ \/ /_/ / /__   
/_/  /_/\_, /___/\___\_\___/   
       <___/   www.mysql.com


-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]