My company has
asked me to find a solution to replace FreeTDS and they've only given me 2
days to prove it can work with all our existing sites and infrastructure!
I've installed ODBC socket server on our MSSQL Server box running W2k server.
I've installed the test client (COM) on my own machine and I can connect to
and query my DSN no problems..so far so good..
I downloaded Tim Uckun's (from PHP Builder article) XML parser class and
test example and installed them on our development web server (linux, php and apache.) I
followed all the instructions in his guide and remembered to change the registry setting for
UseMSDTD to 1.
After a bit of troubleshooting I realised nothing was being returned from
the fsockopen call at all. Not even a false. Naturally, everything else was failing.
I checked the application error log on our SQL Server and I can see events
for the connection/query execution from the COM client, but there are no events to show a connection from the php
class at all.
I'm not getting any error returned to the function in the php class, error no returned is 0.
I'm really keen for us to start using ODBC Socket Server as a FreeTDS alternative, because it will help us
to connect to databases other than MSSQL in our older systems.
If you have any suggestions they would be greatly appreciated. I'm sure it's something really small that I'm
overlooking but I don't have much time for more troubleshooting..
