Web Development

Ask something
Question Locked

Ubuntu with PHP and connecting to ODBC

0 helpful
2 replies

by larson

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a Ubuntu 8.04 with apache and php installed. I keep getting the following error when trying to connect to my MSSQL database.
I switched my IP with X's.

Driver={SQL Server};Server=XX.XXX.XX.XX;Database=SBM01;: Missing extension for odbc

Can anyone tell me what I need to do to get odbc working for ubuntu and php?

Thank you,
Kyle

2 replies

by poffey21

http://www.unixodbc.org/doc/FreeTDS.html That guide helped me out a lot. One thing to note, I was able to get it running under root, and was having problems under apache until I realized that it saved a .odbc.ini file in the /root directory. That will need to be copied to the /etc directory.

This discussion is closed to new replies.