[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

How can I connect to remote database?

Posted on 2004-10-18
1
Medium Priority
?
245 Views
Last Modified: 2010-04-23
I'm currently developing an application using VB.net and MySQL , which is an application that can send and recieve customer information from remote database to computer in different locations. Please suggest methods beside using ASP.net ? Thanks for your help.  
0
Comment
Question by:jpytse
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 19

Accepted Solution

by:
arif_eqbal earned 1000 total points
ID: 12345228
you can connect to the MySQL database on a remote machine and send and recieve data. All you need to establish a connection is a connection string with remote database IP Address and authentication details.

You can connect using ODBC or MySQLDirect .NET Data Provider

using MySQLDirect .NET Data Provider your connection string will be

oMySqlConn.ConnectionString = "User ID=YourUsername;" & _
                              "Password=YourPassword;" & _
                              "Host=xxxx.xxxx.xxxx.xxxx;" & _
                              "Port=3306;" & _
                              "Database=YourDatabaseName;" & _
                              "Direct=true;" & _
                              "Protocol=TCP;" & _
                              "Compress=false;" & _
                              "Pooling=true;" & _
                              "Min Pool Size=0;" & _
                              "Max Pool Size=100;" & _
                              "Connection Lifetime=0"


xxxx.xxxx.xxxx.xxxx=IP Address of remote machine

Using ODBC


oConn.Open "Driver={mySQL};" & _
           "Server=db1.database.com;" & _
           "Port=3306;" & _
           "Option=131072;" & _
           "Stmt=;" & _
           "Database=mydb;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"


Now if your program apart from accessing the database will access other Remote machines and pass on some data, you can go for a webservice.


0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to create and use a custom WaterMark textbox class.  The custom WaterMark textbox class allows you to set the WaterMark Background Color and WaterMark text at design time.   IMAGE OF WATERMARKS STEPS Create VB …
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Suggested Courses

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question