Connecting Godaddy server to Remote server database

Question

0.00/5 (No votes)

See more:

Hi,

I had hosted the website with mysql database in Godaddy,and it was working fine, but i had the other database which was located at some other place,when i am trying Connect with my credientls,it was not working , please Specify How to connect to that databse From my godaddy server

(It means Setting in web.config,iis7 in godaddy server )

Note:- My credentials are prefect, and same connecting string was Connecting to the my server database,
Connecting string was

HTML

<add name="cona" connectionstring="server=serveripaddress;database=databasename;uid=root;pwd=pwd;allow zero datetime=yes" />

Please specify me the Solution
.
Thank Q In adavanced

[edit]HTML tags encoded, code block added - OriginalGriff[/edit]

Posted 5-Jul-12 22:42pm

sivakumarmr10

Updated 6-Jul-12 0:26am

OriginalGriff

v2

Add a Solution

Comments

bbirajdar 6-Jul-12 5:10am

Did you try posting the question in Daddy's forums?

bbirajdar 6-Jul-12 5:11am

is your SQL server on a public IP ?

[no name] 6-Jul-12 6:56am

no is an Mysql in linux
it My Company own server,
It is not general shared Server like Godaddy etc...
Thanks

bbirajdar 6-Jul-12 7:23am

Get the help from your network administrator. He will put your SQL server on a public IP. Then you will be able to access it from anywhere in the world via internet.. Read the Solution 1 by OriginalGriff carefully.... He has explained everything very clearly...

[no name] 6-Jul-12 7:29am

it was my own , but we can able to acess that database from every where

for example: a windows application is Accessing the same Server with same Connecting String
they can able to Access this mysql server database from every where in the world

I think it was not the Problem

bbirajdar 6-Jul-12 7:42am

I am repeating the same question for the third time.... Is your SQL server on public IP?..Are you able to ping the SQL server from a system outside your local network ? Your words like 'accessing from everywhere' does not make any sense..'a windows application is Accessing the same Server with same Connecting String' but from where ? LAN or anything else? The 'where' is important here ..Try to be a little technical...Otherwise you will be wasting your time and ours...

[no name] 6-Jul-12 7:50am

yes its public ip, i can able to Ping my mysql server from outside network also ,we can access that from internet and intranet ,

bbirajdar 6-Jul-12 8:08am

Ok.. You are able to ping it means the connection can be made..You are close to solving the issue. Now comes the port number.. MySQL default port is 3306. Check with godaddy if the 3306 port is open on the server. Then only the application on godaddy can connect to your MySQL database server. Also confirm that the MySQL is set to allow remote connections.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2012-07-06T00:28:00

Two possibilties that I can think of:
1) The IP is worng, or is local to your network.
2) The DB server is set not to accept remote connections.

Check the IP address you are using first: if it starts with 192 then it is a local IP, not internet, so you won't be able to see it from GoDaddy.
If it doesn't, then try connecting via Visual studio.

Try setting up a connection in VS with the Server Explorer pane:
1) Open Server Explorer.
2) Right click "Data connections" and select "Add connection"
3) In the dialog that follows, select your DataSource, and database, specify the security info, and press the "Test connection" button.
4) When the connection works, press "OK"
5) Highlight your database in the Server Explorer pane, and look at the Properties pane. A working example of the connection string will be shown, which you can copy and paste into your app or config file.