Author: mcbrown
Date: 2006-06-22 12:01:10 +0200 (Thu, 22 Jun 2006)
New Revision: 2469
Log:
Documenting the common 10061 connection error, our most popular reported error that somehow doesn't exist in the manual!
Prompted by a query on the C/ODBC mailing list.
Modified:
trunk/refman-4.1/connector-odbc.xml
trunk/refman-4.1/problems.xml
trunk/refman-5.0/connector-odbc.xml
trunk/refman-5.0/problems.xml
trunk/refman-5.1/connector-odbc.xml
trunk/refman-5.1/problems.xml
Modified: trunk/refman-4.1/connector-odbc.xml
===================================================================
--- trunk/refman-4.1/connector-odbc.xml 2006-06-22 08:26:37 UTC (rev 2468)
+++ trunk/refman-4.1/connector-odbc.xml 2006-06-22 10:01:10 UTC (rev 2469)
@@ -7592,6 +7592,32 @@
<question>
<para>
+ When connecting or using the <guibutton>Test</guibutton>
+ button in <literal>ODBC Data Source
+ Administrator</literal> I get error 10061 (Cannot connect
+ to server)
+ </para>
+
+ </question>
+
+ <answer>
+
+ <para>
+ This error can be raised by a number of different issues,
+ including server problems, network problems, and firewall
+ and port blocking problems. For more information, see
+ <xref linkend="can-not-connect-to-server"/>.
+ </para>
+
+ </answer>
+
+ </qandaentry>
+
+ <qandaentry>
+
+ <question>
+
+ <para>
The following error is reported when using transactions:
</para>
Modified: trunk/refman-4.1/problems.xml
===================================================================
--- trunk/refman-4.1/problems.xml 2006-06-22 08:26:37 UTC (rev 2468)
+++ trunk/refman-4.1/problems.xml 2006-06-22 10:01:10 UTC (rev 2469)
@@ -301,6 +301,16 @@
</para>
<para>
+ The error (2003) <literal>Can't connect to MySQL server on
+ '<replaceable>server</replaceable>' (10061)</literal> indicates
+ that the network connection has been refused. You should check
+ that there is a MySQL server running, that it has network
+ connections enabled, the network port you specified is the one
+ configured on the server, and that the TCP/IP port you are using
+ has not been blocked by a firewall or port blocking service.
+ </para>
+
+ <para>
Start by checking whether there is a process named
<command>mysqld</command> running on your server host. (Use
<command>ps xa | grep mysqld</command> on Unix or the Task
@@ -3318,8 +3328,8 @@
character's <quote>sort value.</quote> Characters with the same
sort value (such as ‘<literal>E</literal>’,
‘<literal>e</literal>’, and
- ‘<literal>é</literal>’) are treated as the same
- character.
+ ‘<literal>é</literal>’) are treated as the
+ same character.
</para>
</section>
Modified: trunk/refman-5.0/connector-odbc.xml
===================================================================
--- trunk/refman-5.0/connector-odbc.xml 2006-06-22 08:26:37 UTC (rev 2468)
+++ trunk/refman-5.0/connector-odbc.xml 2006-06-22 10:01:10 UTC (rev 2469)
@@ -7605,6 +7605,32 @@
<question>
<para>
+ When connecting or using the <guibutton>Test</guibutton>
+ button in <literal>ODBC Data Source
+ Administrator</literal> I get error 10061 (Cannot connect
+ to server)
+ </para>
+
+ </question>
+
+ <answer>
+
+ <para>
+ This error can be raised by a number of different issues,
+ including server problems, network problems, and firewall
+ and port blocking problems. For more information, see
+ <xref linkend="can-not-connect-to-server"/>.
+ </para>
+
+ </answer>
+
+ </qandaentry>
+
+ <qandaentry>
+
+ <question>
+
+ <para>
The following error is reported when using transactions:
</para>
Modified: trunk/refman-5.0/problems.xml
===================================================================
--- trunk/refman-5.0/problems.xml 2006-06-22 08:26:37 UTC (rev 2468)
+++ trunk/refman-5.0/problems.xml 2006-06-22 10:01:10 UTC (rev 2469)
@@ -301,6 +301,16 @@
</para>
<para>
+ The error (2003) <literal>Can't connect to MySQL server on
+ '<replaceable>server</replaceable>' (10061)</literal> indicates
+ that the network connection has been refused. You should check
+ that there is a MySQL server running, that it has network
+ connections enabled, the network port you specified is the one
+ configured on the server, and that the TCP/IP port you are using
+ has not been blocked by a firewall or port blocking service.
+ </para>
+
+ <para>
Start by checking whether there is a process named
<command>mysqld</command> running on your server host. (Use
<command>ps xa | grep mysqld</command> on Unix or the Task
@@ -3278,8 +3288,8 @@
character's <quote>sort value.</quote> Characters with the same
sort value (such as ‘<literal>E</literal>’,
‘<literal>e</literal>’, and
- ‘<literal>é</literal>’) are treated as the same
- character.
+ ‘<literal>é</literal>’) are treated as the
+ same character.
</para>
</section>
Modified: trunk/refman-5.1/connector-odbc.xml
===================================================================
--- trunk/refman-5.1/connector-odbc.xml 2006-06-22 08:26:37 UTC (rev 2468)
+++ trunk/refman-5.1/connector-odbc.xml 2006-06-22 10:01:10 UTC (rev 2469)
@@ -7605,6 +7605,32 @@
<question>
<para>
+ When connecting or using the <guibutton>Test</guibutton>
+ button in <literal>ODBC Data Source
+ Administrator</literal> I get error 10061 (Cannot connect
+ to server)
+ </para>
+
+ </question>
+
+ <answer>
+
+ <para>
+ This error can be raised by a number of different issues,
+ including server problems, network problems, and firewall
+ and port blocking problems. For more information, see
+ <xref linkend="can-not-connect-to-server"/>.
+ </para>
+
+ </answer>
+
+ </qandaentry>
+
+ <qandaentry>
+
+ <question>
+
+ <para>
The following error is reported when using transactions:
</para>
Modified: trunk/refman-5.1/problems.xml
===================================================================
--- trunk/refman-5.1/problems.xml 2006-06-22 08:26:37 UTC (rev 2468)
+++ trunk/refman-5.1/problems.xml 2006-06-22 10:01:10 UTC (rev 2469)
@@ -301,6 +301,16 @@
</para>
<para>
+ The error (2003) <literal>Can't connect to MySQL server on
+ '<replaceable>server</replaceable>' (10061)</literal> indicates
+ that the network connection has been refused. You should check
+ that there is a MySQL server running, that it has network
+ connections enabled, the network port you specified is the one
+ configured on the server, and that the TCP/IP port you are using
+ has not been blocked by a firewall or port blocking service.
+ </para>
+
+ <para>
Start by checking whether there is a process named
<command>mysqld</command> running on your server host. (Use
<command>ps xa | grep mysqld</command> on Unix or the Task
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r2469 - in trunk: refman-4.1 refman-5.0 refman-5.1 | mcbrown | 22 Jun |
