Todd, We're running the exact configuration you speak of and I can attest that there are no problems with the module that Franks works on or with PHP. I'd be happy to help, so if you could provide some details, that would help.
The first thing I would check is to make sure that the php_mssql.dll module is installed correctly. You can do this by creating a simple script with php_info(); and load that file in your browser. That will tell you if the module is loading and what version is running. As Frank said, the client libraries need to be installed, but since you're running locally, that probably isn't the problem. php_info() should return that MS SQL is installed under the WDDX info or somewhere near there. It will then give you a whole bunch of information about the module. If that shows up, then there is something wrong with your connection script or permission to SQL server. Let me know and I'll be glad to help. I can assure you that the module works very very well in CGI mode. -Flint -----Original Message----- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 10:18 AM To: 'Frank M. Kromann' Cc: [EMAIL PROTECTED] Subject: RE: RE: [PHP-WIN] Getting PHP to behave with MS SQL Server 7 The SQL Server 7 is local so I don't need the client software. I looked at that so-called explanation, and doesn't explain anything -----Original Message----- From: Frank M. Kromann [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 11:41 AM To: Todd Williamsen Cc: [EMAIL PROTECTED] Subject: Re: RE: [PHP-WIN] Getting PHP to behave with MS SQL Server 7 Hi Todd, This is documented on http://www.php.net/manual/en/ref.mssql.php. The client libraries is found on the MS SQL Server CD and if you are running PHP on the same box as the MS SQL Server is installed you have all you need. If you are connecting to a remote MS SQL Server you need to install the client tools on the PHP box. - Frank > Frank, > > I reinstalled PHP and it doesn't like me or my configuration very > well. PHP is installed as CGI. I tried ISAPI filters, but that > crapped out too. Yes, I have rebooted, restarted the services many > many times and still doesn't work. > > What do you mean client libraries? > > I see this mentioned, but I don't get what they are asking, and what > files are they? How come PHP didn't document this or did they just > whip up the documentation for MS SQL? > > -----Original Message----- > From: Frank M. Kromann [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 13, 2002 5:48 PM > To: Todd WIlliamsen > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP-WIN] Getting PHP to behave with MS SQL Server 7 > > > Hi Todd, > > If you are using the ISAPI version you need to restart the web server > in order to use the mssql_extension. > > If you are using CGI and getting undefined function for mssql_connect, > you might have more than one php.ini file on your system ? > > You also need to install the client libraries for mssql server. These > can be found on the server CD, or you can copy ntwdblib.dll from the > server to your cplient pc (the pc running your php scripst). > > - Frank > > > > Ok, I followed the instructions very closely, to what vague > > instruction there are. > > > > I umcommented out the .dll files and I get undefined variable for > > > > mssql_connect() > > > > Now there is barely any documentation on this and the tech support > > has > > > gotten me ZERO results, I am hoping since this is a WINDOWS PHP list > > that someone will be able to help me. > > > > I am running Win2k Server IIS5, MS SQL Server7 > > > > Anyone? > > > > Next is Oracle...anyone with answers on that? LOL!! > > > > > > > > -- > > PHP Windows Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
