Re: VB6 + MySQL

Hello Shawn,

Thanks for the reply...

> 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

What I mean is to have the possibility to add a new user to the MySQL
database system (the same way I can with PHPmyAdmin).
This way I could program a User Managment System and use only my app.
I'm not talking about users to my application. That is programmed and
stored in a table. I'm talking about users of MySQL so that I can connect
to MySQL as 'root', 'admin' or other user that I might want to create.

> 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

I'll probably agree with you when you say thet client applications shouldn't
perform any backup operation. However, as far as I know, to do a SQL
dump I need to be at the server. In this case, the server is in one of our
company's offices but not the one I work at. In that case how can I do
a weekly backup?

>> 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.

I was thinking that using the ODBC driver SSL (or other encryption)
method was not possible. It's great that is does but... It's hard to
configure and for now I think I will just implement all the funcionality
I need. After that I will think about that. Just a couple of question...
Do I need to program the encryption along with my app or can it be
implemented at any time? Do the client computers need any additional
software?

>> 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!
> 
> Are you MySQL certified?  www.mysql.com/certification

Thanks for the info and the links. I really appreciate. :)



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