Check these: http://lists.ibiblio.org/pipermail/freetds/2005q3/018777.html http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.clients/2007-01/msg00021.html
Cheers Szemir On November 30, 2007 16:02, Johnny Stork wrote: > Yes all of your suggestions have been done. I can also connect from > another machine fine with the SQL-Server Client Tools and EM. No > firewalls between these machines either. No need at this stage to > confirm/test PHP mssql support since I have not even gotten to that > stage yet, just trying to connect directly with freetds first. If I cant > connect with tsql then there would be no point adding in the extra > layers of php to test the connection, which uses the freetds driver. > > One question though...is unixodbc necessary? I was under the impression > that an ODBC driver/layer was included with freetds? > > Shawn wrote: > > Lets start with the basics. (I'm sure you've done all this, but just to > > be sure....) > > > > Can you ping 192.168.10.72? (can you confirm netowrking to that box is > > operational?) > > > > Have you loaded up a test page that only has <?php phpinfo(); ?> ? - > > this will tell you if Apache/PHP has the required support. > > > > I have successfully connected to SQL Server in the past (MSSQL 2000) > > using PHP, but that was more just proof of concept for me. So, I know > > it can be done. The question is what part is failing for you.... > > > > The "tsql" command - is that a command line command? (looks like it...) > > I've never used it so don't know the details there. If it helps I > > connected with PEAR DB (MDB2 now), to hide the low level details of > > which database I was talking to. > > > > Hope that helps in some way, as little as that was.. :) > > > > Shawn > > > > Johnny Stork wrote: > >> I am trying to make a connection to a SQL-Server 2005 host from a Linux > >> (RHEL5, PHP 5.2.5) but am having problems. I have not made such a > >> connection before but did my research, installed freeTDS, rebuild > >> apache/php with mssql support but cant seem to make a connection with > >> the "tsql -S 192.168.111.111 -U username" although I can telnet to port > >> 1433 on the sql-server host? Am I missing something? Or maybe there is > >> something specific that needs to be configed on the sql-server host? > >> Below are the errors I get when trying to connect with tsql. > >> > >> Any ideas/suggestions? > >> > >> > >> [EMAIL PROTECTED]:~# tsql -S 192.168.10.72 -U sa > >> locale is "en_US.UTF-8" > >> locale charset is "UTF-8" > >> Password: > >> Msg 20009, Level 9, State 0, Server OpenClient, Line 0 > >> Server is unavailable or does not exist. > >> There was a problem connecting to the server > >> > >> > >> > >> _______________________________________________ > >> clug-talk mailing list > >> [email protected] > >> http://clug.ca/mailman/listinfo/clug-talk_clug.ca > >> Mailing List Guidelines (http://clug.ca/ml_guidelines.php) > >> **Please remove these lines when replying > > > > _______________________________________________ > > clug-talk mailing list > > [email protected] > > http://clug.ca/mailman/listinfo/clug-talk_clug.ca > > Mailing List Guidelines (http://clug.ca/ml_guidelines.php) > > **Please remove these lines when replying > > _______________________________________________ > clug-talk mailing list > [email protected] > http://clug.ca/mailman/listinfo/clug-talk_clug.ca > Mailing List Guidelines (http://clug.ca/ml_guidelines.php) > **Please remove these lines when replying _______________________________________________ clug-talk mailing list [email protected] http://clug.ca/mailman/listinfo/clug-talk_clug.ca Mailing List Guidelines (http://clug.ca/ml_guidelines.php) **Please remove these lines when replying
