Yes, but I have never personally used Linux to connect to MSSQL so I can't really help you on that one. Although I hear that several people have done this I would really recommend it (as Linux isn't a supported client O/S for MSSQL). It is *fairly* straightforward on Windows - the hardest bit is making sure you have all the correct DLL's in the right places etc etc. I use MySQL/ Postgres these days so I can't really remember all the stuff I had to do to get MSSQL working with PHP but I will have a think and let you know if I think of anything that might be useful. After having another quick look at your error message at the bottom of your original email it might be worth looking at your MSSQL Server connection config dialogs - make sure that TCP/IP has been enabled (looks like you might just have named pipes). Regards Ollie Cronk -----Original Message----- From: Kevin Gordon [mailto:kgordon@paradise.net.nz] Sent: 25 February 2003 08:05 To: Oliver Cronk Cc: PHP Mail Subject: 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 > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
