RE: RE: PHP4 on Windows & using MSSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I use this combination very successfully. I stick with ODBC for the SQL access though.

<>< Ryan

-----Original Message-----
From: Oliver Cronk [mailto:oliver@tpoll.com]
Sent: Wednesday, February 26, 2003 3:23 AM
To: Kevin Gordon
Cc: PHP Mail
Subject:  RE: PHP4 on Windows & using MSSQL


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


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux