Author: paul
Date: 2008-05-20 17:38:46 +0200 (Tue, 20 May 2008)
New Revision: 10786
Log:
r31556@frost: paul | 2008-05-20 10:37:32 -0500
Sync translations
Modified:
trunk/it/refman-common/connector-odbc.xml
trunk/pt/refman-common/connector-odbc.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:31555
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:31325
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:31556
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:31325
Modified: trunk/it/refman-common/connector-odbc.xml
===================================================================
--- trunk/it/refman-common/connector-odbc.xml 2008-05-20 15:38:40 UTC (rev 10785)
+++ trunk/it/refman-common/connector-odbc.xml 2008-05-20 15:38:46 UTC (rev 10786)
Changed blocks: 12, Lines Added: 92, Lines Deleted: 19; 6846 bytes
@@ -289,7 +289,7 @@
<section id="myodbc-introduction">
- <title>Introduction to Connector/ODBC</title>
+ <title>Connector/ODBC Introduction</title>
<para>
ODBC (Open Database Connectivity) provides a way for client
@@ -320,8 +320,7 @@
</para>
<para>
- The following functionality will added or changed as part of
- this development:
+ The following functionality was added or changed as part of 5.1:
</para>
<itemizedlist>
@@ -349,6 +348,23 @@
<listitem>
<para>
+ Implement SQLCancel() (Bug #15601):
+ <ulink url="http://msdn2.microsoft.com/en-us/library/ms714112.aspx">MSDN
+ Article 714112</ulink>.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <para>
+ The following functionality will be added in a version after
+ 5.1:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
Implement native Mac OS X setup library.
</para>
</listitem>
@@ -396,14 +412,6 @@
<listitem>
<para>
- Implement SQLCancel() (Bug #15601):
- <ulink url="http://msdn2.microsoft.com/en-us/library/ms714112.aspx">MSDN
- Article 714112</ulink>.
- </para>
- </listitem>
-
- <listitem>
- <para>
Implement arrays of parameters:
<ulink url="http://msdn2.microsoft.com/en-us/library/ms711818.aspx">MSDN
Article 711818</ulink>.
@@ -914,6 +922,14 @@
</itemizedlist>
+ <note>
+ <para>
+ An OLEDB/ODBC driver for Windows 64-bit is available from
+ <ulink url="http://www.microsoft.com/downloads/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b&displaylang=en">Microsoft
+ Downloads</ulink>.
+ </para>
+ </note>
+
<section id="myodbc-installation-binary-windows-installer">
<title>Installing the Windows Connector/ODBC Driver using an installer</title>
@@ -2783,6 +2799,13 @@
<entry/>
<entry>The character set to use for the connection. Added in 3.51.17.</entry>
</row>
+ <row>
+ <entry><literal>sslverify</literal></entry>
+ <entry/>
+ <entry>If set to 1, the SSL certificate will be verified when used with the
+ MySQL connection. If not set, then the default behaviour
+ is to ignore SSL certificate verification.</entry>
+ </row>
</tbody>
</tgroup>
</informaltable>
@@ -2839,13 +2862,16 @@
<entry><literal>FLAG_DEBUG</literal></entry>
<entry>Trace Driver Calls To myodbc.log</entry>
<entry>Make a debug log in <filename>C:\myodbc.log</filename> on Windows, or
- <filename>/tmp/myodbc.log</filename> on Unix variants.</entry>
+ <filename>/tmp/myodbc.log</filename> on Unix variants.
+ This option was removed in Connector/ODBC 3.51.18.</entry>
</row>
<row>
<entry>8</entry>
<entry><literal>FLAG_BIG_PACKETS</literal></entry>
<entry>Allow Big Results</entry>
- <entry>Don't set any packet limit for results and parameters.</entry>
+ <entry>Don't set any packet limit for results and bind parameters. Without this
+ option, parameter binding will be truncated to 255
+ characters.</entry>
</row>
<row>
<entry>16</entry>
@@ -3127,6 +3153,20 @@
Windows Server 2003:
</para>
+ <tip>
+ <para>
+ Because it is possible to create DSN using either the 32-bit
+ or 64-bit driver, but using the same DNS identifier, it is
+ advisable to include the driver being used within the DSN
+ identifier. This will help you to identify the DSN when using
+ it from applications such as Excel that are only compatible
+ with the 32-bit driver. For example, you might add
+ <literal>Using32bitCODBC</literal> to the DSN identifier for
+ the 32-bit interface and <literal>Using64bitCODBC</literal>
+ for those using the 64-bit Connector/ODBC driver.
+ </para>
+ </tip>
+
<orderedlist>
<listitem>
@@ -3819,6 +3859,15 @@
password with administrator privileges.
</para>
+ <para>
+ For correct operation of ODBC Administrator, you should ensure
+ that the <filename>/Library/ODBC/odbc.ini</filename> file used
+ to set up ODBC connectivity and DSNs are writable by the
+ <literal>admin</literal> group. If this file is not writable by
+ this group then the ODBC Administrator may fail, or may appear
+ to have worked but not generated the correct entry.
+ </para>
+
<warning>
<para>
There are known issues with the OS X ODBC Administrator and
@@ -3826,8 +3875,9 @@
this method. In this case you should use the command-line or
edit the <filename>odbc.ini</filename> file directly. Note
that existing DSNs or those that you create via the
- <command>myodbc3i</command> tool can still be checked and
- edited using ODBC Administrator.
+ <command>myodbc3i</command> or
+ <command>myodbc-installer</command>tool can still be checked
+ and edited using ODBC Administrator.
</para>
</warning>
@@ -6238,10 +6288,8 @@
<para>
For the complete ODBC API reference, please refer to the ODBC
- Programer's Reference at
- <ulink
- url="http://msdn.microsoft.com/library/en-us/odbc/htm/odbcabout_this_manual.asp"
- />.
+ Programmer's Reference at
+ <ulink url="http://msdn.microsoft.com/en-us/library/ms714177(VS.85).aspx"/>.
</para>
<para>
@@ -9173,6 +9221,31 @@
</qandaentry>
+ <qandaentry>
+
+ <question>
+
+ <para>
+ When submitting queries with parameter binding using
+ <literal>UPDATE</literal>, my field values are being
+ truncated to 255 characters.
+ </para>
+
+ </question>
+
+ <answer>
+
+ <para>
+ You should ensure that the
+ <literal>FLAG_BIG_PACKETS</literal> option is set for your
+ connection. This removes the 255 character limitation on
+ bound parameters.
+ </para>
+
+ </answer>
+
+ </qandaentry>
+
</qandaset>
</section>
Modified: trunk/pt/refman-common/connector-odbc.xml
===================================================================
--- trunk/pt/refman-common/connector-odbc.xml 2008-05-20 15:38:40 UTC (rev 10785)
+++ trunk/pt/refman-common/connector-odbc.xml 2008-05-20 15:38:46 UTC (rev 10786)
Changed blocks: 12, Lines Added: 92, Lines Deleted: 19; 6846 bytes
@@ -289,7 +289,7 @@
<section id="myodbc-introduction">
- <title>Introduction to Connector/ODBC</title>
+ <title>Connector/ODBC Introduction</title>
<para>
ODBC (Open Database Connectivity) provides a way for client
@@ -320,8 +320,7 @@
</para>
<para>
- The following functionality will added or changed as part of
- this development:
+ The following functionality was added or changed as part of 5.1:
</para>
<itemizedlist>
@@ -349,6 +348,23 @@
<listitem>
<para>
+ Implement SQLCancel() (Bug #15601):
+ <ulink url="http://msdn2.microsoft.com/en-us/library/ms714112.aspx">MSDN
+ Article 714112</ulink>.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <para>
+ The following functionality will be added in a version after
+ 5.1:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
Implement native Mac OS X setup library.
</para>
</listitem>
@@ -396,14 +412,6 @@
<listitem>
<para>
- Implement SQLCancel() (Bug #15601):
- <ulink url="http://msdn2.microsoft.com/en-us/library/ms714112.aspx">MSDN
- Article 714112</ulink>.
- </para>
- </listitem>
-
- <listitem>
- <para>
Implement arrays of parameters:
<ulink url="http://msdn2.microsoft.com/en-us/library/ms711818.aspx">MSDN
Article 711818</ulink>.
@@ -914,6 +922,14 @@
</itemizedlist>
+ <note>
+ <para>
+ An OLEDB/ODBC driver for Windows 64-bit is available from
+ <ulink url="http://www.microsoft.com/downloads/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b&displaylang=en">Microsoft
+ Downloads</ulink>.
+ </para>
+ </note>
+
<section id="myodbc-installation-binary-windows-installer">
<title>Installing the Windows Connector/ODBC Driver using an installer</title>
@@ -2783,6 +2799,13 @@
<entry/>
<entry>The character set to use for the connection. Added in 3.51.17.</entry>
</row>
+ <row>
+ <entry><literal>sslverify</literal></entry>
+ <entry/>
+ <entry>If set to 1, the SSL certificate will be verified when used with the
+ MySQL connection. If not set, then the default behaviour
+ is to ignore SSL certificate verification.</entry>
+ </row>
</tbody>
</tgroup>
</informaltable>
@@ -2839,13 +2862,16 @@
<entry><literal>FLAG_DEBUG</literal></entry>
<entry>Trace Driver Calls To myodbc.log</entry>
<entry>Make a debug log in <filename>C:\myodbc.log</filename> on Windows, or
- <filename>/tmp/myodbc.log</filename> on Unix variants.</entry>
+ <filename>/tmp/myodbc.log</filename> on Unix variants.
+ This option was removed in Connector/ODBC 3.51.18.</entry>
</row>
<row>
<entry>8</entry>
<entry><literal>FLAG_BIG_PACKETS</literal></entry>
<entry>Allow Big Results</entry>
- <entry>Don't set any packet limit for results and parameters.</entry>
+ <entry>Don't set any packet limit for results and bind parameters. Without this
+ option, parameter binding will be truncated to 255
+ characters.</entry>
</row>
<row>
<entry>16</entry>
@@ -3127,6 +3153,20 @@
Windows Server 2003:
</para>
+ <tip>
+ <para>
+ Because it is possible to create DSN using either the 32-bit
+ or 64-bit driver, but using the same DNS identifier, it is
+ advisable to include the driver being used within the DSN
+ identifier. This will help you to identify the DSN when using
+ it from applications such as Excel that are only compatible
+ with the 32-bit driver. For example, you might add
+ <literal>Using32bitCODBC</literal> to the DSN identifier for
+ the 32-bit interface and <literal>Using64bitCODBC</literal>
+ for those using the 64-bit Connector/ODBC driver.
+ </para>
+ </tip>
+
<orderedlist>
<listitem>
@@ -3819,6 +3859,15 @@
password with administrator privileges.
</para>
+ <para>
+ For correct operation of ODBC Administrator, you should ensure
+ that the <filename>/Library/ODBC/odbc.ini</filename> file used
+ to set up ODBC connectivity and DSNs are writable by the
+ <literal>admin</literal> group. If this file is not writable by
+ this group then the ODBC Administrator may fail, or may appear
+ to have worked but not generated the correct entry.
+ </para>
+
<warning>
<para>
There are known issues with the OS X ODBC Administrator and
@@ -3826,8 +3875,9 @@
this method. In this case you should use the command-line or
edit the <filename>odbc.ini</filename> file directly. Note
that existing DSNs or those that you create via the
- <command>myodbc3i</command> tool can still be checked and
- edited using ODBC Administrator.
+ <command>myodbc3i</command> or
+ <command>myodbc-installer</command>tool can still be checked
+ and edited using ODBC Administrator.
</para>
</warning>
@@ -6238,10 +6288,8 @@
<para>
For the complete ODBC API reference, please refer to the ODBC
- Programer's Reference at
- <ulink
- url="http://msdn.microsoft.com/library/en-us/odbc/htm/odbcabout_this_manual.asp"
- />.
+ Programmer's Reference at
+ <ulink url="http://msdn.microsoft.com/en-us/library/ms714177(VS.85).aspx"/>.
</para>
<para>
@@ -9173,6 +9221,31 @@
</qandaentry>
+ <qandaentry>
+
+ <question>
+
+ <para>
+ When submitting queries with parameter binding using
+ <literal>UPDATE</literal>, my field values are being
+ truncated to 255 characters.
+ </para>
+
+ </question>
+
+ <answer>
+
+ <para>
+ You should ensure that the
+ <literal>FLAG_BIG_PACKETS</literal> option is set for your
+ connection. This removes the 255 character limitation on
+ bound parameters.
+ </para>
+
+ </answer>
+
+ </qandaentry>
+
</qandaset>
</section>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r10786 - in trunk: . it/refman-common pt/refman-common | paul | 20 May |
