![]() ![]() If you are using Anatella 64-bit, you must use the 64-bit “Microsoft ODBC Administrator” software to define your ODBC DSN. To add more confusion, these 2 different “Microsoft ODBC Administrator” software looks (nearly) exactly the same. When using a 64-bit Windows OS, there is a little “twist” related to the “Microsoft ODBC Administrator”: There are actually 2 completely different “Microsoft ODBC Administrator” software: one for 32 bit applications and one for 64 bit applications. The easiest way to run the “ Microsoft ODBC Administrator” is to click the “ Open the MSWindow ODBC Manager” button located at the bottom of the “ Manage OBC Connections” window: You’ll find additional information for the proper setup of an ODBC connection to an Oracle, Teradata, MySQL& Sybase database in the sections 5.1.6.3. The technique is the same for all the databases (Oracle, Teradata, SQL Server, My SQL, DB2, etc.). In the below example, we’ll create a “link” to access the content of a “MySQL database”. The first operation that you need to do when working with a “Type 1” ODBC datasource is to use the the “ Microsoft ODBC Administrator” to create a “link” (also named an “ODBC DSN”) toward the database that you want to use. You are now ready to install the driver.Let’s give a small example of usage. On your Linux computer, execute the command: tar xvzf unixODBC-2.3.0.tar.gz.Īt a command prompt, execute the command: CPPFLAGS="-DSIZEOF_LONG_INT=8".Īt a command prompt, execute the command: export CPPFLAGS.Īt a command prompt, execute the command: "./configure -prefix=/usr -libdir=/usr/lib64 -sysconfdir=/etc -enable-gui=no -enable-drivers=no -enable-iconv -with-iconv-char-enc=UTF8 -with-iconv-ucode-enc=UTF16LE".Īt a command prompt (logged in as root), execute the command: make.Īt a command prompt (logged in as root), execute the command: make install. UnixODBC-2.3.1 is not supported with this release of the Microsoft ODBC Driver 11 for SQL Server. Then click the appropriate link to save the file unixODBC-2.3.0.tar.gz to your computer. Click the Download link on the left side of the page to go to the download page. On SUSE Linux Enterprise, zypper remove unixODBC. On Red Hat Enterprise Linux 5 or 6, execute the following command: yum remove unixODBC. Remove any older installed version of unixODBC (for example, unixODBC 2.2.11). If the installation script is unable to complete, configure and build the proper driver manager yourself. For more information, see the ODBC driver installation instructions for Linux This part of the process can take up to five minutes to complete.Īfter the script stops running, follow the instructions on the screen to install the unixODBC Driver Manager. Type YES to proceed with unpacking the files. ![]() Execute the following command to begin the unixODBC Driver Manager installation. unixODBC-2.3.1 is not supported with this release of the Microsoft ODBC Driver 11 for SQL Server. Then click the appropriate link to download unixODBC-2.3.0 (not unixODBC-2.3.1). ![]() If your computer cannot access an external site via FTP, get unixODBC-2.3.0.tar.gz. When you are ready to install, and if your computer can access an external site via FTP, execute the following command. To see a list of the available options, execute the following command. You can run build_dm.sh to install the unixODBC Driver Manager. To extract the files, execute the following command: tar xvzf msodbcsql-.0.tar.gz.Ĭhange to the msodbcsql-.0 directory and there you should see a file called build_dm.sh. ![]() Make sure that you have the *.tar.gz file that matches your version of Linux. Go to the directory where the Microsoft SQL Server ODBC Driver download placed the file called msodbcsql-.0.tar.gz. If you are installing the Preview for SUSE Linux, the file name is msodbcsql-.0.tar.gz. These instructions refer to msodbcsql-.0.tar.gz, which is the installation file for Red Hat Linux. ![]()
0 Comments
Leave a Reply. |