Accessing the database over Internet.

Question

I am a programmer in Visual Basic 6.0 and I am using MySQL database. In our office, I am using MySQL ODBC connector 3.5 as DSN connector via LAN networking. The company demands to create a solution so that employees to work from their homes. I didn't commit since they aren't able to access the program because LAN connection is limited to our office. Is it possible to access the database VIA Internet using MySQL ODBC Connector 3.5? If this is possible, can you provide the steps that I need to follow?

Answer 1

Yes. It seems possible to access the database from your company's server VIA Internet using MySQL ODBC Connector. Before you can do this, visit the following website, and download the version of MySQL Connector that suits you. To be noticed that this product received updates since the version 3.5. The developer is providing all the steps that you need to follow regarding this process on the following website. There are tutorials for newer versions also. Just select the version from the left menu.