Printable View
Hail,
I have a website on an external webserver that offers to have MySQL DBs on it. I was wondering if it was possible to connect through a VB app or ODBC (DAO) to a SQL DB that is not local host? I'm assuming this would mean that I'd have to connect through the net right? Is it just a question of entering the address where I would usually enter a server name\IP or do I need like MySQL drivers on the PC I'm connecting from?
You will probably find that the Webserver provider will provide you with an IP for the MySQL database and you will set the password yourself. You can just set the IP and password as you would normally in your connect string and away you go.
Not too smart doing it that way though as it is entirely visible on the NET as to what you are doing.
The best way is to have code running on your web server that passes the SQL data through to the database locally (so that access information is not visible on the net) and link to the webserver with a secure / encrypted link.
If you want to link to the webserver (and hence to the database) with VB you can define the encryption for yourself. Just a simple alogorithm that can be decoded and encoded at the webserver end quickly is all you will need.
.
Sounds simple enough, thanks a lot, I'll look into it...
What you are really creating here is a personal web service. You can take the implimentation to whatever complexity you desire.
Well if you are not transfering personal information or anything, wouldn't it be easier to just pass it into the database so you don't have to mess around with creating a web service that decrypts the encrypted information, and establishing a secure link to the db? Like if I am creating a piece of software to link up to a sql db on a webserver so that a user can post information that will be public anyways (w/e the user uploads to the db will be visible on the website), you wouldn't need a secure link would you? Correct me if I am wrong - I am just starting into this :) :wave:
This is in .NET btw - sry I posted in Classic, this topic just applies so well to my problem, thanks!
You are correct. If all you wish to do is connect to the database then there are many tools out there that you can do the job with. DBManager being my choice any day.
http://www.dbtools.com.br/EN/dbmanager.php
:thumb: