Connect to remote SQL Server
-
Hey, my name is Yahav and i am a .NET programer (and PHP expert but never mind...) In my currect program, i am tring to connect to my website SQL server (server type - mySql). i have downloaded the dll C# lib to do that connect and i have got mySQL "test connection program" who checks the sql connection and give me to edit the program the link to download: http://dev.mysql.com/downloads/[^] the problem is when i entering my host address (pearservices.com) or the ip address 62.90.136.206 i got error: "host address {my home address} could not connect to this SQL server." ({my home address} = my home ip address) but when i entering localhost (mean my own mysql server that i have insalled on my computer) its works very well someone can explain me why i get this error, and how can i connect to remote server, if this is a problem with my website host, do you have a hosts that give me the abillty to do that? thanks you very motch, Yahav. P.S.: Sorry, my engish is not very well.
Gindi Bar Yahav - Web & Software defeloper.
-
Hey, my name is Yahav and i am a .NET programer (and PHP expert but never mind...) In my currect program, i am tring to connect to my website SQL server (server type - mySql). i have downloaded the dll C# lib to do that connect and i have got mySQL "test connection program" who checks the sql connection and give me to edit the program the link to download: http://dev.mysql.com/downloads/[^] the problem is when i entering my host address (pearservices.com) or the ip address 62.90.136.206 i got error: "host address {my home address} could not connect to this SQL server." ({my home address} = my home ip address) but when i entering localhost (mean my own mysql server that i have insalled on my computer) its works very well someone can explain me why i get this error, and how can i connect to remote server, if this is a problem with my website host, do you have a hosts that give me the abillty to do that? thanks you very motch, Yahav. P.S.: Sorry, my engish is not very well.
Gindi Bar Yahav - Web & Software defeloper.
Just a couple of possibilities... The database server is not visible or not configured to accept connections from outside of its machine (if the webserver resides in the same machine), or from outside the network, or from a network that includes your home IP. I have never used mySql, but this is what I can think of.
Luis Alonso Ramos Intelectix Chihuahua, Mexico My Blog!
-
Hey, my name is Yahav and i am a .NET programer (and PHP expert but never mind...) In my currect program, i am tring to connect to my website SQL server (server type - mySql). i have downloaded the dll C# lib to do that connect and i have got mySQL "test connection program" who checks the sql connection and give me to edit the program the link to download: http://dev.mysql.com/downloads/[^] the problem is when i entering my host address (pearservices.com) or the ip address 62.90.136.206 i got error: "host address {my home address} could not connect to this SQL server." ({my home address} = my home ip address) but when i entering localhost (mean my own mysql server that i have insalled on my computer) its works very well someone can explain me why i get this error, and how can i connect to remote server, if this is a problem with my website host, do you have a hosts that give me the abillty to do that? thanks you very motch, Yahav. P.S.: Sorry, my engish is not very well.
Gindi Bar Yahav - Web & Software defeloper.
-
Firewall issues as well, perhaps?
Mabye it can be... but do you know a SQL server (I dont mind use mySql/MS Access/SQL Server) that i can connect with it? i searched the net and didnt find... (and its not like the host will say to me "i gives you the abillty to connect from other machine" ^^") Thanks you very moch for your answers, ill talk today to my host administrator and try to find the problem. Yahav.
Gindi Bar Yahav - Web & Software defeloper.
-
Mabye it can be... but do you know a SQL server (I dont mind use mySql/MS Access/SQL Server) that i can connect with it? i searched the net and didnt find... (and its not like the host will say to me "i gives you the abillty to connect from other machine" ^^") Thanks you very moch for your answers, ill talk today to my host administrator and try to find the problem. Yahav.
Gindi Bar Yahav - Web & Software defeloper.