VB6 + MySQL

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.

Additionaly I would like to know if I can manage users from VB and to backup
the DB.

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.

Note: The MySQL Database will be served from our company server.
(Any links to tutorials/tips/recommendations/forums about this subject are
also welcome)

Thanks

- Nuno



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

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

> 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/myodbc?unsub=gcdmo-myodbc@m.gmane.org

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

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/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: VB6 + MySQL

Hi Nuno,

Nuno Vaz Oliveira wrote:
> Hello Shawn,
>
> Thanks for the reply...
>
>> Hello Nuno,
>>
>> My responses are intermingled below...
>>
>> "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.
>
Yes, assuming that the account you are connecting with has at least
SUPER privileges, you can issue any of the commands needed to affect
login accounts and their privilege settings
http://dev.mysql.com/doc/refman/5.0/en/user-account-manageme nt.html


>> 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.h tml
>
> 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?
>
The backup utility "mysqldump" can be run against any MySQL database it
can reach. All you need to do is to specify the necessary --host and
--port options when you call the program. The presumes that the login
account you are attempting to connect with will have the privileges to
login from an outside address.

>>>
>> 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?
>
AFAIK, the ability to use an SSL certificate is built into the ODBC
drivers. However the production of those certificates are not natively
supported on Windows without 3rd party software. You can generate your
certs on a central machine and distribute them with your application
then tell your drivers to use your certs during the connection phase.
Again, I have not had a lot of experience using SSL on Windows but IIRC
it was the generation of the certificate files that took me the longest
to get correct.
>>
> Thanks for the info and the links. I really appreciate. :)
>
Any time!

--
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/myodbc?unsub=gcdmo-myodbc@m.gmane.org