RE: PHP4 on Windows & using MSSQL

Thanks Ollie I guess this means using PHP4 MSSQL functions in Windows and PHP4 Sybase functions in Linux? On Tue, 2003-02-25 at 04:47, Oliver Cronk wrote: > The MSSQL module for PHP DOES NOT USE ODBC. It uses the C library direct > style of connecting to MSSQL. Use your enterprise manager to configure the > appropriate users and permissions and you should be fine. > > Ollie Cronk > www.cronky.net > > -----Original Message----- > From: Kevin Gordon [mailto:kgordon@paradise.net.nz] > Sent: 24 February 2003 07:09 > To: PHP Mail > Subject: PHP4 on Windows & using MSSQL > > > Hi Everyone, > > >From a Linux session: > ~ # telnet 10.1.1.1 1433 > Trying 10.1.1.1... > Connected to 10.1.1.1. > Escape character is '^]'. > Connection closed by foreign host. > > >From within NT4 Primary Domain Server: > SQL Server Query Analyzer using the user login & password applied in PHP > (and created in MSSQL) Queries processed ok. > > In PHP must I use NT authenticated login / password? > > Both a PHP client on Linux and Windows receive the same error message: > Warning: SQL error: [Microsoft][ODBC SQL Server Driver][Named > Pipes]Specified SQL server not found., SQL state 08001 in SQLConnect in > E:\Inetpub\wwwroot\php\ODBC_Driver.php on line 174 > > The PHP.ini file on NT4 has: > ****************************************************** > [MSSQL] > ; Allow or prevent persistent links. > mssql.allow_persistent = On > > ; Maximum number of persistent links. -1 means no limit. > mssql.max_persistent = -1 > > ; Maximum number of links (persistent+non persistent). -1 means no > limit. > mssql.max_links = -1 > > ; Minimum error severity to display. > mssql.min_error_severity = 10 > > ; Minimum message severity to display. > mssql.min_message_severity = 10 > > ; Compatability mode with old versions of PHP 3.0. > mssql.compatability_mode = Off > > ; Valid range 0 - 2147483647. Default = 4096. > ;mssql.textlimit = 4096 > > ; Valid range 0 - 2147483647. Default = 4096. > ;mssql.textsize = 4096 > > ; Limits the number of records in each batch. 0 = all records in one > batch. > ;mssql.batchsize = 0 > > ; Use NT authentication when connecting to the server > mssql.secure_connection = Off > > ; Specify max number of processes. Default = 25 > ;mssql.max_procs = 25 > > **************************************************************** > ntwdblib.dll is in the correct Windows directory. > > Using a System DNS for ODBC. Should I be using a File DNS? > > Can I open up NT4 PDS to telenet to it? > > Any thoughts, comments? > Many thanks, > > Kevin Gordon > New Zealand > > >