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

-----Original Message-----
From: Kevin Gordon [mailto:[EMAIL PROTECTED]
Sent: 24 February 2003 07:09
To: PHP Mail
Subject: PHP4 on Windows & using MSSQL

Hi Everyone,

>From a Linux session:
~ # telnet 1433
Connected to
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:
; 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
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
;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 (
To unsubscribe, visit:

Reply via email to