 |  |  |  |  |  |  |  |
How To Connect Remote Mysql Database
 |
Hello everybody ,
Im created an Application in vb6.0 . In that application i have to store data in a web Mysql database.How can i connect tht
Im created an Application in vb6.0 . In that application i have to store data in a web Mysql database.How can i connect tht
Hi,
Assuming you have experience with ADO, you should download and install MySQL Connector, and then, use a connection string like:
server_address can be also a name.
server_port will be 3306 most of time.
Hope this helps.
Assuming you have experience with ADO, you should download and install MySQL Connector, and then, use a connection string like:
Driver={MySQL ODBC 3.51 Driver};
Database=database_name;
Server=server_address;
Port=server_port;
Option=19;
Stmt=;
Uid=username;
Pwd=passwordserver_address can be also a name.
server_port will be 3306 most of time.
Hope this helps.
Last edited by Alvein; Sep 21st, 2005 at 12:16 am. Reason: Fix formatting
Damn it, I still dream of her....:(
•
•
•
•
Originally Posted by murali1 
Hello everybody ,
Im created an Application in vb6.0 . In that application i have to store data in a web Mysql database.How can i connect tht
I'm the same murali , but my application write by java. It can only connect in local mysql, but doesn't connect in internet mysql.
Except you to help me.
•
•
•
•
Originally Posted by murali1
Hello everybody ,
Im created an Application in vb6.0 . In that application i have to store data in a web Mysql database.How can i connect tht
i m with same problem here
•
•
Join Date: May 2006
Posts: 1,810
Reputation: 
Solved Threads: 117
•
•
•
•
Originally Posted by ajaym83
pls anybody have the ans
i m with same problem here
Assignment Help | Web Design Company | Homework Help | 498a
Programming Help | Need Help ? | Job Interview | Top 10 Hosts
Programming Help | Need Help ? | Job Interview | Top 10 Hosts
To connect to a MySQL server on a remote system:
mysql -h hostname -u root -p root
here hostname is (ex:192.168.20.27 for remote system)
"root " is the username.
-p is password you should provide.(Ex""root")
mysql -h hostname -u root -p root
here hostname is (ex:192.168.20.27 for remote system)
"root " is the username.
-p is password you should provide.(Ex""root")
•
•
Join Date: May 2006
Posts: 1,810
Reputation:
Solved Threads: 117
Connecting to mysql server as root should be discouraged .
Assignment Help | Web Design Company | Homework Help | 498a
Programming Help | Need Help ? | Job Interview | Top 10 Hosts
Programming Help | Need Help ? | Job Interview | Top 10 Hosts
•
•
Join Date: Feb 2007
Posts: 66
Reputation:
Solved Threads: 4
Junior Poster in Training
Murali, did you solve the problem?
This code a couple of minor bugs with string line continuations, but those are easy enough to fix:
http://www.base64.co.uk/mysql-odbc-driver/
1. Follow the link for the MySQL ODBC Driver and install it (if you haven't already).
2. Be sure to select the Microsoft Remote Data Object 2.0 in your project References.
3. Add your internet service provider as a Remote Database Access host through your control panel (i.e. %.fios.verizon.net).
The first time you attempt to make a connection, the MySQL ODBC Driver install will prompt you to confirm the connection with a pop-up window. It should not come up again.
I had to use my Control Panel User ID and Password to make this work. Virtual ID's did not work (i.e. MyAccountLogin_MyPHPUserID). The only virtual reference that did work was for the actual database itself (i.e. MyAccountLogin_MyDatabaseName).
The only thing left out of this sample is how to pull data fields from the result set. The comments suggest "reference it like !username", but I prefer using something like this:
strName = .rdoColumns.Item("Name")
Lastly, case matters for the table names in your SQL statements. If you have a table named "Products" in your database and you issue a query for a table named "products", it will bomb.
Everything after that should be relatively easy to figure out.
Hope this helps!
http://www.base64.co.uk/mysql-odbc-driver/
1. Follow the link for the MySQL ODBC Driver and install it (if you haven't already).
2. Be sure to select the Microsoft Remote Data Object 2.0 in your project References.
3. Add your internet service provider as a Remote Database Access host through your control panel (i.e. %.fios.verizon.net).
The first time you attempt to make a connection, the MySQL ODBC Driver install will prompt you to confirm the connection with a pop-up window. It should not come up again.
I had to use my Control Panel User ID and Password to make this work. Virtual ID's did not work (i.e. MyAccountLogin_MyPHPUserID). The only virtual reference that did work was for the actual database itself (i.e. MyAccountLogin_MyDatabaseName).
The only thing left out of this sample is how to pull data fields from the result set. The comments suggest "reference it like !username", but I prefer using something like this:
strName = .rdoColumns.Item("Name")
Lastly, case matters for the table names in your SQL statements. If you have a table named "Products" in your database and you issue a query for a table named "products", it will bomb.
Everything after that should be relatively easy to figure out.
Hope this helps!
|
Similar Threads
- shortcut on client to connect to remote database filemaker (MS Access and FileMaker Pro)
- Using PHP to connect to remote MSSQL database (PHP)
- can i use mysql database with asp (ASP)
- php adodb library connect remote mysql (PHP)
- connecting java to mysql database (Java)
- Php code confusion. Not sure how to describe (PHP)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Advice on VB6 and Access 2000, please.
- Next Thread: How to create Setup/install
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
