Hi Bryan; First I would direct you to the MyODBC mailing list, as it is generally the place where we VB programmers converse. At any rate, you need MyODBC installed (check the products heading of the MySQL web site for the MyODBC download), and your connection string is wrong. I would detail it, but as I recently wrote an article that has an explanation of connection strings and a sample one, I will instead just make a shameless plug: check out www.dynamergy.com/mike/articles/blobaccessvb.html and you should find what you need.
Mike Hillyer Dynamergy Software -----Original Message----- From: Bryan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 2:00 AM To: [EMAIL PROTECTED] Subject: Connect to Database over the Internet Hello All: I would appreciate some help on how to configure my application code or the computer which mysql resides on so it can be accesed over the intenet. Putting aside the obvious security concerns how can I achieve this. The application is written in VB using ADO to access the database. Currently this is the connect string I currently use to connect to the database. .ConnectionString = "Data Source = REGIONAL;SERVER=xx.xx.xx.xxx;User ID = root; Password " It works fine connecting to the database when run on the same computer which contains the MYSQL database. When I try the application from a remote computer configured it does not connect. No firewall is involved. I suspect I need to configure certain networking protocols on the host/ server machine, but am lost as to what I should be doing. The operating system is XP professional. Any suggestions. Thanks -=Bryan=- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
