Re: PHP & MSSQL on Linux

Hmm.. if you're using a function like mssql_error or something like that, it's likely coming from the driver and not php.. Did you see this on the docs page? I have spent the last 2 days trying to get PHP to connect to MSDE on Windows 2003 Web Edition. Although initally PHP would connect to the database without a problem, it would then refuse to connect, hitting F5 enough times would eventually connect to the database. As you can imagine this intermittent problem was hard to trace. I was using PHP 5.0.5 (although 5.0.4 has the same problem) on a Windows 2003 Web Edition SP1 server, and was trying to connect to MSDE Rel A. Solution: ~~~~~~~~~ Firstly MSDE needed to be installed with the following arguments: SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0. Secondly it was necessary to delete ntwdblib.dll from c:\php Thirdly I downloaded the SQL 2000 evaluation and installed only the client tools on a seperate PC (Ent. Manager will now connect to the database). Lastly I copied the version of ntwdblib.dll from the PC with Ent. Manager on it (ver 2000.80.2039.0) to c:\windows\system32\ After a re-boot no more connection problems. Pls note that this is only for 2003 Web Edition with MSDE, this problem does not seem to occour with Standard Edition -Micah On Tuesday 01 November 2005 3:18 pm, php@swimwebs.com wrote: > The error I'm getting is from the PHP function. Both mssql_connect and > PEAR are returning the same error. As far as I can tell, mssql only > returns the last line of an error message so I can't be sure that the > error I'm seeing is from MSSQL or PHP. Running TCPdump shows no > traffic is going to my sql database from the webserver. But when I run > tsql,it shows that communication occurred. > > This looks like a problem with my PHP configuration but I'm at a loss as > to what it is. > > Robbert > > Micah Stevens <micah@raincross-tech.com> wrote on 11/01/2005, 11:55:52 > > PM: > > Is it from php or the mssql driver? If it's from the driver, then the > > library is installed at least partially correctly. If it's from php, > > perhaps not. > > > > From there you can narrow it down by checking the connection parameters > > outside of php to make sure they're right, is there a mssql client for > > linux? > > > > If the driver is loading, I would hope it would give better error > > messages than just 'connection failed'.. but as I've never used the > > driver I might be wrong. > > > > You can also packet sniff the network during the connection attempt to > > see what goes on there, there's lots of clues that could be helpful in > > the packet stream. > > > > -Micah > > > > On Tuesday 01 November 2005 2:30 pm, php@swimwebs.com wrote: > > > A few months back I wrote the list asking for help making a connection > > > to a MS SQL database from our linux webserver. At that time I was able > > > to make a successfull connection on Fedora Core 1 after installing > > > php-mssql.rpm and a freetds rpm. When I upgradd to FC4, I was unable > > > to continue my project because the RPMs had not been built for > > > PHP5.0.4, whic is the version we run now. > > > > > > Today, I was able to get the version of php-mssql I needed and > > > installed it successfully. I am able to make a connection to our ms > > > sql server using tsql. There is a mssql.ini file in the php.d > > > directory and the mssql.so file is in /usr/lib/php/modules/. Using the > > > get_loaded_extensions fuction, I see that mssql is a loaded module and > > > the phpinfo() function shows me mssql configuration files. All > > > indicators tell me that I should be able to connect. > > > > > > Obvsiously, since I'm posting to the list, you can guess that it's not > > > working. The error message I get back is useless as I'm only told that > > > the connection failed. Does anyone know anything else I need to check > > > to get the connection working? > > > > > > Thank you, > > > Robbert van Andel > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php