Copyright: (C) MySQL AB, 1995-2002, www.mysql.com
Citation: (C) MySQL AB, 1995-2002, www.mysql.com


Makertf Readme File
MySQL ODBC 3.51 Driver DSN Setup Dialog Box

The MySQL ODBC 3.51 Driver DSN setup dialog contains the following controls:

DSN Information:

Data Source Name	Identifies the MySQL ODBC 3.51 Driver, and enter the name that you want to use it as a reference
Description	Description About the Data Source Name

MySQL Connection Parameters:

Host/Server Name	Enter the host name of the MySQL server, to which you want to connect. By default it is 'local host'.
Database Name	Enter the default MySQL database name (catalog name) to be used
User Name	Enter the user name
Pass Word	Password
Port	The TCP/IP port to use if it is not listening to the default one, 3306
SQL Command On Connect	Optional SQL statement that will be executed when connected to server

Driver Options, Advanced:

The option argument is used to tell MyODBC 3.51 that the client isn't 100% ODBC compliant. On Windows, one normally sets the option flag by toggling the different options on the connection screen but one can also set this using OPTION parameter in odbc.ini

Bit	Meaning
1	If the client wants the real width of the column.
2	The client can't handle that MySQL returns the true value of affected rows. If this flag is set then MySQL returns 'found rows' instead. One must have MySQL 3.21.14 or newer to get this to work.
4	Make a debug log in c:\myodbc.log. This is the same as putting MYSQL_DEBUG=d:t:O,c::\myodbc.log in `AUTOEXEC.BAT'
8	Don’t set any packet limit for results and parameters
16	Don't prompt for questions even if driver would like to prompt
32	Enable or disable the dynamic cursor support. This is not allowed in MyODBC.
64	Ignore use of database name in ‘database.table.column’.
128	Force use of ODBC manager cursors (experimental).
256	Disable the use of extended fetch (experimental)
512	Pad CHAR fields to full column length.
1024	SQLDescribeCol () will return fully qualified column names
2048	-Use the compressed server/client protocol
4096	Tell server to ignore space after function name and before '(' (needed by PowerBuilder). This will make all function names keywords!
8192	Connect with named pipes to a mysqld server running on NT.
16384	Change LONGLONG columns to INT columns (Some applications can't handle LONGLONG).
32768	Return 'user' as Table_qualifier and Table_owner from SQLTables (experimental)
65536	Read parameters from the client and odbc groups from `my.cnf'
131072	Add some extra safety checks (should not bee needed but...)

If you want to have many options, you should add the above flags! For example setting option to 12 (4+8) gives you debugging without package limits!

The default ` MYODBC.DLL' or `MYODBC3.DLL' is compiled for optimal performance. If you want to debug MyODBC 3.51  (for example to enable tracing), you should instead use MYODBC3D.DLL. To install this file, copy `MYODBC3D.DLL' over the installed MYODBC3.DLL file.

Test Data Source:

You can test whether your settings are enough to connect to the MySQL server using the button "Test Data Source".

Online Resources:

For more information about MySQL ODBC 3.51 Driver, please refer to the following online resources:

MySQL ODBC Home Page.

MyODBC 3.51 Programmer’s Reference Manual.

Frequently Asked Questions.

© MySQL AB 1995-2002, Venu (venu@mysql.com)