CODEWITHSUNDEEP
mysqlvb.netvisual-studio-2008
Tareq
Tareq

Reputation: 2006

Accessing MySQL database from my VB.NET 2008 Project

I developed a project in VB.NET. In this project I want to use data from MySQL that is resides in my WEB server.

I can communicate with the MySQL server of my localhost but can not communicate with the WEB server.

In my CPanel I added Host from the Remote Database Access.

But I can't communicate with WEB MySQL server.

Upvotes: 1

Views: 2378

Answers (2)

Svetlozar Angelov
Svetlozar Angelov

Reputation: 21660

The first step is to try to connect to the web mysql with MySql Query Browser - that will tell you if the database is open for remote connections ( I assume it would fail)

I guess you have already checked it, but make sure you use the correct ip

EDIT:

As Björn said, your vb code is ok, so the problem is with the connection to the db.

Unfortunately that would be caused by many many reasons.

  • Are you sure you use a real IP from the host (and use it in the mysql settings)?
  • Are you sure you entered the correct remote host in the mysql settigns?
  • Are you sure you have correct connection string in the vb code?

Upvotes: 2

Bjoern
Bjoern

Reputation: 16304

Since your post indicates you can access the DB on your localhost, it doesn't seem to be an issue with the way you're connecting to the DB from your application (.NET-Connector?).

What does the external MySQL-Server say? Access denied? Or can't you reach it from the pc where your application is hosted (aka maybe a firewall regulation, other network etc.)?

Upvotes: 1

Related Questions