To finish your ODBC configuration, click OK.įor help with MySQL Connector/ODBC Driver, see the MySQL Connector/ODBC Developer Guide. The ODBC data source you added will now appear in your System DSN list.To confirm the connection, click Test.From the Database drop-down list, select the database you want to access.Next to "User" and "Password", enter the MySQL username and password.For "Port", enter the TCP/IP port: 3306.Enter the hostname of the RDC host: .edu.Optionally, enter a description of the source.In the "MySQL Connector/ODBC" dialog box, next to "Data Source Name", enter a name for this server connection (for example,.To the MySQL documentation, is recommended for most users.) (The Unicode driver handles data from any character set and, according The "Create Data Source" window will list two MySQL ODBC drivers (one for ANSI and one for Unicode) select the Unicode driver unless you know you need the ANSI driver, and then clickįinish.In the "ODBC Data Source Administrator" window, select the System DSN tab, and then click.Panel, select Administrative Tools, and then Data To create an ODBC data source for your MySQL database on the RDC: If you do not have your welcome letter, email the RDC Administration team ( for help. To follow these instructions, you will need information contained in your RDC MySQL database welcome letter (in email). From the list of downloads, find the installer file (MSI or ZIP) you prefer for your version of Windows (32- or 64-bit), and then, next to the preferred installer type, click Download.The MySQL Connector/ODBC driver allows ODBC applications to communicate with MySQL servers.įollowing are instructions for downloading and installing the MySQL Connector/ODBC driver (to install the MySQL connector, you must be logged into your workstation as an administrator):Ĭonnector/ODBC page, and under "Generally Available (GA) Releases", make sure Microsoft Windows is the platform selected. To configure an ODBC data source for MySQL, you must have the MySQL Connector/ODBC driver installed on your workstation. Download and install the MySQL Connector/ODBC driver This is accomplished through the use of an ODBC data source, which associates a name with database connection information.įollowing are instructions for setting up an ODBC data source to connect to your MySQL database on the Research Database Complex ( RDC) at Indiana University. Download and install the MySQL Connector/ODBC driverĪny program that uses Open Database Connectivity (ODBC) to connect to a remote database needs a way to identify the type of database and the computer to which it is connecting.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |