MS-SQL Connect on DV 4.0 Media Storage

Question

I'm really at a standstill. Trying to connect to MS-SQL database with php on my mediateemple DV 4.0 server.

I managed to get it to work with our DV 3.5 using these instructions

http://kb.mediatemple.net/questions/233/Using+%28remote%29+MS-SQL+databases+with+PHP+on+a+%28dv%29

But the same actions do not work with 4.0.

I even tried installing FreeTDS and reinstalling the 64-bit version: FreeTDS-Devel-0.64-1.el5.rf.x86_64.rpm

and then I changed

[FreeTDS] Description = v0.63 with protocol v8.0 Driver = /usr/lib/libtdsodbc.so.0 - changed to /usr/lib64/libtdsodbc.so.0 

after I did this, he got rid of all the errors that I saw, but I still see

 Warning: odbc_connect(): SQL error: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source, SQL state S1000 in SQLConnect in /var/www/vhosts/housingworks.org/httpdocs/p/dbtest.php on line 9 

this is where i run the test: http://www.housingworks.org/p/dbtest.php

HELP!

Answer 1

I am not 100% sure why you are getting these errors, since you should be able to use this (mt) Wiki to connect to MySQL in all of our services. Try to give us a call regarding this connection error, and one of our senior technicians will be able to get everything you need. [phone].