Forums
This topic is locked
Connection to my sql
Posted 07 Sep 2001 13:20:59
1
has voted
07 Sep 2001 13:20:59 Jean Marc matjmc posted:
I'm trying to connect to my databaseon the external server
i get a error message 10061
when i test the dsn an erro -1
what does it mean
May some one help me ?
Thank you very much
Replies
Replied 07 Sep 2001 14:48:20
07 Sep 2001 14:48:20 Tim Green replied:
Basically this error message means that connection is denied.
If you are connecting to a MySQL Server that is on your network you need to make sure that you are using a user that has been granted remote access privelidges, and you need to ensure that you are using the correct password etc.
If you are using a MySQL Server hosted by an ISP/Host Provider, then again you need to make sure that your username and password are correct, but most importantly you need to find out from your ISP/Host Provider whether remote access is enabled or not, as not all ISP/Host Providers actually enable this.
Hope this helps
Tim Green
Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>
If you are connecting to a MySQL Server that is on your network you need to make sure that you are using a user that has been granted remote access privelidges, and you need to ensure that you are using the correct password etc.
If you are using a MySQL Server hosted by an ISP/Host Provider, then again you need to make sure that your username and password are correct, but most importantly you need to find out from your ISP/Host Provider whether remote access is enabled or not, as not all ISP/Host Providers actually enable this.
Hope this helps
Tim Green
Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>
Replied 07 Sep 2001 14:59:06
07 Sep 2001 14:59:06 Keith Slater replied:
Hey if its not enabled how would they enable it??
Also if connecting to a remote location you said you have to put the port in, do you put the IP addres and then the port like: 192.165.2.3:4444??
thanks
Keith Slater
Also if connecting to a remote location you said you have to put the port in, do you put the IP addres and then the port like: 192.165.2.3:4444??
thanks
Keith Slater
Replied 09 Sep 2001 02:44:37
09 Sep 2001 02:44:37 Tim Green replied:
Basically you will have to contact them to get them to enable remote access.
If the MySQL server is one you have administrative rights to then you need to amend your user to allow for connection from any external IP.
As far as the port is concerned, the default port 3306 is used in 99.999% of cases, if you do need to enter a different port there is a box for doing this in your DSN setup for MyODBC.
Tim Green
Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>
If the MySQL server is one you have administrative rights to then you need to amend your user to allow for connection from any external IP.
As far as the port is concerned, the default port 3306 is used in 99.999% of cases, if you do need to enter a different port there is a box for doing this in your DSN setup for MyODBC.
Tim Green
Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>