Setup LAMP on Ubuntu with MyODBC support.
Go to terminal:
Now hand edit (or create, if it does not exist already) /etc/odbc.ini
Here's an example odbc.ini:
Remember to start and stop mysql and apache:
sudo apt-get install apache2 mysql-server php5 php5-odbc libapache2-mod-php5 php5-xsl php5-gd php-pear libapache2-mod-auth-mysql php5-mysql libmyodbc
Now hand edit (or create, if it does not exist already) /etc/odbc.ini
Here's an example odbc.ini:
[ODBC Data Sources] odbcname = MyODBC 3.51 Driver DSN [odbcname] Driver = /usr/lib/odbc/libmyodbc.so Description = MyODBC 3.51 Driver DSN SERVER = my.database.server.com PORT = USER = USER Password = XXXXXX Database = DBNAME OPTION = 3 SOCKET = [Default] Driver = /usr/local/lib/libmyodbc3.so Description = MyODBC 3.51 Driver DSN SERVER = localhost PORT = USER = root Password = Database = test OPTION = 3 SOCKET =
Remember to start and stop mysql and apache:
sudo /etc/init.d/mysql start sudo /etc/init.d/apache2 start sudo /etc/init.d/mysql stop sudo /etc/init.d/apache2 stop sudo /etc/init.d/mysql restart sudo /etc/init.d/apache2 restart