Sorry made a typo in my last email - I mean't to say wouldn't recommend it rather than would (in reference to using MSSQL from Linux). Hope you get the issue sorted Cheers Ollie -----Original Message----- From: Kevin Gordon [mailto:kgordon@paradise.net.nz] Sent: 26 February 2003 08:23 To: Oliver Cronk Cc: PHP Mail Subject: RE: PHP4 on Windows & using MSSQL Thanks Ollie. I will check Tcp or Named Pipes. I have found a Linux Journal article dated 14 Feb 2003 using a FreeTDS driver and ODBC to MSSQL and will try that. Cheers, Kevin On Tue, 2003-02-25 at 23:25, Oliver Cronk wrote: > 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
