Thread: Cant connect db of 1 site from other

Hello people
I was trying to connect 1 site's mysql db from other site and wasnt able to do it. Here are few combinations that i tried and failed miserably

1. From my localhost pages, i tried to connect with Site A and Site B using their connection strings respectively.

2. From Site A, i tried to call site B's db.

3. From site B, i tried to call Site A's db.

All attempts failed with following error

[Exception: Exception of type 'System.Exception' was thrown.]
MySql.Data.MySqlClient.NativeDriver.Open() +110

[MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts.]

At line

Code:

Con.Open()

code's working if i am using the same site's db as all 3 locations have same db structure.

Do you use something like this for your connection string?

Code:

connectionString="Database=your_db;Data Source=mysql.domain.com;Port=3306;User Id=your_user_id;Password=your_password;Connect Timeout=600;" 

If you use a full domain or IP as the Data Source, then as long as you provide a valid username and password there should be no reason why you can't connect to any db.

RR, i use this kind of connection string

Code:

connectionString="Server=xx.xx.xx.xx;Database=xx;User=xx;Password=xx;Port=3306;"

I dont know why it doesnt connect

Is there any setting at host's end, which can limit db access from outside the site??

Can you login to the db using mysql administrator or some other db program?

Originally Posted by richyrich

Can you login to the db using mysql administrator or some other db program?

Yes RR, the dbs work fine if they are being used from their respective sites, but they dont work if called from other sites.

I know that when I am connecting to a MySql DB on a linux server from another server I have to go into the control panel and allow the domain name or IP address to the allowed list so the DB knows it can accept connections from that remote server...don't know if you have done this..?

G

Originally Posted by grae.uk

I know that when I am connecting to a MySql DB on a linux server from another server I have to go into the control panel and allow the domain name or IP address to the allowed list so the DB knows it can accept connections from that remote server...don't know if you have done this..?

G

thanx RF for the info
No i havent done this and i m not sure if the client's server is Linux or what!!

But just now i tried calling the db from other site from php page...... and it worked........ no idea why i cant do it with .aspx page!!

Anyway, i'll write a php page for my requirement for the time being.

Originally Posted by micky

thanx RF for the info
No i havent done this and i m not sure if the client's server is Linux or what!!

But just now i tried calling the db from other site from php page...... and it worked........ no idea why i cant do it with .aspx page!!

Anyway, i'll write a php page for my requirement for the time being.

It's becase PHP is just so much better!! lol Glad you found some sort of solution !

Originally Posted by grae.uk

It's becase PHP is just so much better!!

not for me
other day i couldnt connect php with SQL Server.
in this case its just coz, php and mysql are related to each other, i think they worked

Originally Posted by micky

not for me
other day i couldnt connect php with SQL Server.
in this case its just coz, php and mysql are related to each other, i think they worked

You are probably right. I never really got into learning aspx properly and I know php pretty well. Well enough to get by anyway