connecting to MS SQL with ODBC connect

adavis

I have only connected to a mySQL database in the past.

I need to connect to a MS SQL database with on ODBC connection. The DBA is running some sort of query that I will be using. I'm not sure I understand the process. He doesn't know PHP/mySQL and I don't know very much about ASP/MS SQL/ODBC. Any revelations or advice would be great and much appreciated.

hessian

i wouldn't use the odbc functions. I would use the mssql functions. If you are on a unix box you will need to recompile php (--with-sybase) with freetds supoort (www.freetds.org). The MsSQL functions are not as complete as the MySQL functions, but still better than odbc.

If it is the windows version, you will already have a php module for connecting. You may have to enable it in your php.ini though, but i think it is by default (Been a long time since I used windows as a webserver).

If you must use odbc and on windows, you need to go into the control panel and set up a odbc connection first.

If you are on unix you have a few choices for odbc, just do a google search.

adavis

The server that I will be using is a Unix, where the PHP/mySQL is installed. The MS SQL database is on a NT box. I don't want to develop in the NT box because it doesn't have PHP installed and I don't want to learn ASP if I can help it. The db admin for the db I want to hit said somthing about giving me a join or something because the info I need resides on two different tables. I'm not sure what I will need to do with that, but first I just need to figure out how to connect, then we'll worry about retrieving the data.

I will talk to my Unix server admin on Monday about this. Tell him what I need to accomplish and ask him if our Unix box has freetds support. This is the box where I do all of my development, but the database that I need to hit to retrieve untainted employee info from just happends to reside on this other NT server. Once the employee info is retrieved at login, I will stay on my Unix server and work with my mySQL database.