Now I had setup a PHP forum. I need to transfer an old forum which is driven by ASP + Access database.
There is no tool for me to transfer data from the two different database.

So I want use Navicat (a MySQL database management tool) to import the old data to the new database on zymic.

But as we know, I can only know my MySQL address is "Localhost", the Navicat need a true hostname or IP address to link the database.

How could I know my zymic MySQL database's IP address?

we dont allow remote connections to our database so Navicat wont be able to connect to our server at all

Hello

I am using vb.net 2005 with reference MySQL Connector Net 6.1.6 I am making application to select or insert data to my database.

I have a connection problem, when I try to open connection to my database I get following error:

"Unable to connect to any of the specified MySQL hosts."

Connection string I am using look like this:

"Data Source=MyServerName;Database=MyDatabaseName;Uid=MyUserName;Pwd=MyPassword"

Part of thr code looks like this:


Dim query As String = "SELECT * FROM Table"
Dim connection As New MySqlConnection("Data Source=MyServerName;Database=MyDatabaseName;Uid=MyUserName;Pwd=MyPassword")
If Not connection.State = ConnectionState.Open Then
connection.Open()
End If

Is there even possible to connect to zymic mysql database with vb.net application?


Thanks.

we are not a vb host and again we do not allow remote connections to our database

How could we solve with out knowing the host name? and not using localhost!

the only hostname that is for MySQL on Zymic is localhost