Install a few requirements. Make a backup of odbcinst. Leave a Reply Cancel reply Your email address will not be published. Optionally, you can add the DSN information to a template file and execute the following command: There is more than one Driver Manager installed and your application is using the wrong one, or the Driver Manager was not built correctly. So create the DSN as the user who is going to be using it. As of version

Uploader: Vuhn
Date Added: 19 April 2008
File Size: 56.37 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 78703
Price: Free* [*Free Regsitration Required]

Your mileage may vary, consult your distro’s package repository if you are in doubt.

Installing the RPM in RedHat only installs configured files and does not install the source unless you have chosen to include the source. We will focus on using the odbcinst command.

odbc.ini Connection String Keywords (unixODBC)

The driver needs to load the resource file in order to function. As unixobdc version Start by setting some environment variables. We will use the command line tool ‘isql’.


You can do this by using a Windows box with a different set of tools. Assuming you have a package manager, download and install the odbc extension for PHP if it isn’t already installed.

Using unixODBC

If your package managed doesn’t have such a driver available, you have to download the FreeTDS source code and compile it. Once you have unpacked the source typically using something like “tar zxvf freetds This site uses Akismet to reduce spam. The Adventures of a True Geek Administrator.

Subscribe to Blog via Email Enter your email address to subscribe to this blog and receive notifications of new posts by email. You cannot reference msodbcsql.

Or, you can use this command: Installing the Driver Manager. I couldn’t place one here because it would invoke my php interpreter on this msswl.

The original document can be found here: Your email address will not be published. Create a New Login. The value passed to the Driver keyword can either be: If you use this GUI, leave Servername field empty and unixodbf edit odbc. Subsequently these two SQL Servers are very similar.


Look for the one you just created. Brian Bruns started a open source project to provide an implementation nssql the TDS protocol to anyone who wanted it. Click the check mark in upper left corner to save.

Connection String Keywords (unixODBC)

Before you can use the driver, install the unixODBC driver manager. The header file that contains all of the new definitions needed to use the driver. This file is installed in [driver. Again we will use the odbcinst command instead. Important These instructions refer to msodbcsql I won’t go into detail here. Log in as root. If this fails then you may have a configuration problem or you may simply be using the incorrect UserName and PWD.

Author: admin