Dear All,
I had config the php.ini as the following :
extension=php_mssql.dll
Then run the cli "iisreset" and reboot the web server machine...
After that, there is NO any MS-SQL within the phpinfo()...
So, would you mind to help more ?
Thanks !
Edward.
2010/1/18 Edward S.P. Leong
> Dear All,
>
> I had config the php.ini as the following :
> extension=php_mssql.dll
>
> Then run the cli "iisreset" and reboot the web server machine...
> After that, there is NO any MS-SQL within the phpinfo()...
> So, would you mind to help more ?
>
> Thanks !
>
> Edward.
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
1 - Can you confirm that the ini file you are editing is the one that
is reported in phpinfo() as the file being used?
2 - At a command prompt, change directory to your PHP installation and type ...
php -m
See if you have any errors being reported.
If the INI file is in an unusual location, then use ...
php -c
instead; e.g.
php -c D:\PHP\INI\php-cli.ini -m
php -c C:\windows\php-isapi.ini -m
etc.
--
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling
å¼è¿° Richard Quadling
> 1 - Can you confirm that the ini file you are editing is the one that
> is reported in phpinfo() as the file being used?
Yes, BUT there is no MSSQL info of it...
> 2 - At a command prompt, change directory to your PHP installation =20
> and type ...
>
> php -m
>
> See if you have any errors being reported.
>
> If the INI file is in an unusual location, then use ...
>
> php -c
T:\php5>php -c t:\php5\php.ini -m
PHP Warning: PHP Startup: Unable to load dynamic library =20
'T:\PHP5\ext\php_mssql
..dll' - The specified module could not be found.
in Unknown on line 0
[PHP Modules]
bcmath
calendar
com_dotnet
ctype
date
dom
filter
ftp
gd
hash
iconv
json
libxml
mbstring
mcrypt
mysql
odbc
pcre
Reflection
session
SimpleXML
SPL
standard
tokenizer
wddx
xml
xmlreader
xmlwriter
zlib
[Zend Modules]
T:\php5\ext>dir php_mssql.dll
Volume in drive T is Data
Volume Serial Number is DC85-706F
Directory of T:\php5\ext
2009/12/16 ä¸å 05:06 49,232 php_mssql.dll
1 File(s) 49,232 bytes
0 Dir(s) 52,215,365,632 bytes free
T:\php5\ext>
BTW : when running the cli of php -c t:\php5\php.ini -m, the system =20
prompt me there is no "MSVCR71.dll" found...
So, how can I install the dll file for test ( php -m ) again ?
Thanks !
Edward.
------------------------------------------------------------ ----
ITA Web Site : http://www.ita.org.mo
E-mail Address : ita@ita.org.mo
2010/1/19
> å¼è¿° Richard Quadling
>
>> 1 - Can you confirm that the ini file you are editing is the one that
>> is reported in phpinfo() as the file being used?
>
> Yes, BUT there is no MSSQL info of it...
>
>> 2 - At a command prompt, change directory to your PHP installation =C2=
=A0and
>> type ...
>>
>> php -m
>>
>> See if you have any errors being reported.
>>
>> If the INI file is in an unusual location, then use ...
>>
>> php -c
>
> T:\php5>php -c t:\php5\php.ini -m
> PHP Warning: Â PHP Startup: Unable to load dynamic library
> 'T:\PHP5\ext\php_mssql
> .dll' - The specified module could not be found.
> Â in Unknown on line 0
> [PHP Modules]
> bcmath
> calendar
> com_dotnet
> ctype
> date
> dom
> filter
> ftp
> gd
> hash
> iconv
> json
> libxml
> mbstring
> mcrypt
> mysql
> odbc
> pcre
> Reflection
> session
> SimpleXML
> SPL
> standard
> tokenizer
> wddx
> xml
> xmlreader
> xmlwriter
> zlib
>
> [Zend Modules]
>
> T:\php5\ext>dir php_mssql.dll
> Â Volume in drive T is Data
> Â Volume Serial Number is DC85-706F
>
> Â Directory of T:\php5\ext
>
> 2009/12/16  ä¸å 05:06     =C2=
=A0 Â 49,232 php_mssql.dll
> Â Â Â Â Â Â Â 1 File(s) Â Â =
  49,232 bytes
> Â Â Â Â Â Â Â 0 Dir(s) Â 52,215,36=
5,632 bytes free
>
> T:\php5\ext>
>
> BTW : when running the cli of php -c t:\php5\php.ini -m, the system promp=
t
> me there is no "MSVCR71.dll" found...
> So, how can I install the dll file for test ( php -m ) again ?
>
> Thanks !
>
> Edward.
>
>
>
>
>
> ------------------------------------------------------------ ----
> ITA Web Site : http://www.ita.org.mo
> E-mail Address : ita@ita.org.mo
>
>
It seems you are missing one (or more) of the MS Visual C Runtime files.
http://www.microsoft.com/downloads/details.aspx?FamilyID=3D9 b2da534-3e03-43=
91-8a4d-074b9f2bc1bf&displaylang=3Den
is where I'd go next.
But, first, I'd confirm this issue.
If you have depends.exe (http://www.dependencywalker.com/) to open the
php_mssql.dll and see if it reports the missing file in the same way -
look at the bottom of the bottom panel.
Whilst PHP _can_ find the php_mssql.dll file, it is unable to load it
due to missing libraries required by the dll.
--=20
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
Zend Certified Engineer : http://zend.com/zce.php?c=3DZEND002498&r=3D213474=
731
ZOPA : http://uk.zopa.com/member/RQuadling
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
But having said all of that, the php_mssql.dll uses a very old library
which may give you issues.
For the time being, using ODBC (php_odbc is built in for PHP on
Windows) is a much safer solution. You can also use the latest SQL
Native Client driver so you can talk to SQL7, 2000, 2005, 2008.
If you are used to using a DNS-less connection, then ...
$Conn = odbc_pconnect("Driver={SQL Server Native Client
10.0};Server={$Server};Database={$Database};MARS_Connection= Yes;",
$User, $Password, SQL_CUR_USE_DRIVER);
will give you the connection without the need to have a DNS entry.
--
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling
Richard Quadling wrote:
>But having said all of that, the php_mssql.dll uses a very old library
>which may give you issues.
>
>For the time being, using ODBC (php_odbc is built in for PHP on
>Windows) is a much safer solution. You can also use the latest SQL
>Native Client driver so you can talk to SQL7, 2000, 2005, 2008.
>
>If you are used to using a DNS-less connection, then ...
>
>$Conn = odbc_pconnect("Driver={SQL Server Native Client
>10.0};Server={$Server};Database={$Database};MARS_Connection =Yes;",
>$User, $Password, SQL_CUR_USE_DRIVER);
>
>will give you the connection without the need to have a DNS entry.
>
>
Hello to you,
Where can we download the SQL Native Client driver for talking to MS-SQL
( eg : 2000 ) ?
Thanks !
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
2010/1/19 Edward S.P. Leong
> Richard Quadling wrote:
>
>>But having said all of that, the php_mssql.dll uses a very old library
>>which may give you issues.
>>
>>For the time being, using ODBC (php_odbc is built in for PHP on
>>Windows) is a much safer solution. You can also use the latest SQL
>>Native Client driver so you can talk to SQL7, 2000, 2005, 2008.
>>
>>If you are used to using a DNS-less connection, then ...
>>
>>$Conn = odbc_pconnect("Driver={SQL Server Native Client
>>10.0};Server={$Server};Database={$Database};MARS_Connectio n=Yes;",
>>$User, $Password, SQL_CUR_USE_DRIVER);
>>
>>will give you the connection without the need to have a DNS entry.
>>
>>
> Hello to you,
>
> Where can we download the SQL Native Client driver for talking to MS-SQL
> ( eg : 2000 ) ?
>
> Thanks !
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C 3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en
and you also have the option of an official MS SQL driver for PHP
http://www.codeplex.com/SQLSRVPHP
--
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling
--------------030004030208020602060100
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Richard Quadling wrote:
>2010/1/19 Edward S.P. Leong
>
>
>>Richard Quadling wrote:
>>
>>
>>
>>>But having said all of that, the php_mssql.dll uses a very old library
>>>which may give you issues.
>>>
>>>For the time being, using ODBC (php_odbc is built in for PHP on
>>>Windows) is a much safer solution. You can also use the latest SQL
>>>Native Client driver so you can talk to SQL7, 2000, 2005, 2008.
>>>
>>>If you are used to using a DNS-less connection, then ...
>>>
>>>$Conn = odbc_pconnect("Driver={SQL Server Native Client
>>>10.0};Server={$Server};Database={$Database};MARS_Connecti on=Yes;",
>>>$User, $Password, SQL_CUR_USE_DRIVER);
>>>
>>>will give you the connection without the need to have a DNS entry.
>>>
>>>
>>>
>>>
>>Hello to you,
>>
>>Where can we download the SQL Native Client driver for talking to MS-SQL
>>( eg : 2000 ) ?
>>
>>Thanks !
>>
>>--
>>PHP General Mailing List (http://www.php.net/)
>>To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>>
>>
>
>http://www.microsoft.com/downloads/details.aspx?FamilyId=C6 C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en
>
>
Sorry,
Would you mind to tell me which for connecting MS-SQL 2000 and PHP ?
Thanks !
Edward.
--------------030004030208020602060100--
2010/1/20 Edward S.P. Leong
> Richard Quadling wrote:
>
> 2010/1/19 Edward S.P. Leong
>
>
> Richard Quadling wrote:
>
>
>
> But having said all of that, the php_mssql.dll uses a very old library
> which may give you issues.
>
> For the time being, using ODBC (php_odbc is built in for PHP on
> Windows) is a much safer solution. You can also use the latest SQL
> Native Client driver so you can talk to SQL7, 2000, 2005, 2008.
>
> If you are used to using a DNS-less connection, then ...
>
> $Conn = odbc_pconnect("Driver={SQL Server Native Client
> 10.0};Server={$Server};Database={$Database};MARS_Connection= Yes;",
> $User, $Password, SQL_CUR_USE_DRIVER);
>
> will give you the connection without the need to have a DNS entry.
>
>
>
>
> Hello to you,
>
> Where can we download the SQL Native Client driver for talking to MS-SQL
> ( eg : 2000 ) ?
>
> Thanks !
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
>
> http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C 3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en
>
>
> Sorry,
>
> Would you mind to tell me which for connecting MS-SQL 2000 and PHP ?
>
> Thanks !
>
> Edward.
>
Either ODBC or the MS SQL driver for PHP. Which ever suits you.
Both require the MS SQL Native Client (go for the latest).
That's it really.
--
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling
2010/1/20 Richard Quadling
> 2010/1/20 Edward S.P. Leong
>> Richard Quadling wrote:
>>
>> 2010/1/19 Edward S.P. Leong
>>
>>
>> Richard Quadling wrote:
>>
>>
>>
>> But having said all of that, the php_mssql.dll uses a very old library
>> which may give you issues.
>>
>> For the time being, using ODBC (php_odbc is built in for PHP on
>> Windows) is a much safer solution. You can also use the latest SQL
>> Native Client driver so you can talk to SQL7, 2000, 2005, 2008.
>>
>> If you are used to using a DNS-less connection, then ...
>>
>> $Conn = odbc_pconnect("Driver={SQL Server Native Client
>> 10.0};Server={$Server};Database={$Database};MARS_Connection= Yes;",
>> $User, $Password, SQL_CUR_USE_DRIVER);
>>
>> will give you the connection without the need to have a DNS entry.
>>
>>
>>
>>
>> Hello to you,
>>
>> Where can we download the SQL Native Client driver for talking to MS-SQL
>> ( eg : 2000 ) ?
>>
>> Thanks !
>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>>
>>
>> http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C 3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en
>>
>>
>> Sorry,
>>
>> Would you mind to tell me which for connecting MS-SQL 2000 and PHP ?
>>
>> Thanks !
>>
>> Edward.
>>
>
> Either ODBC or the MS SQL driver for PHP. Which ever suits you.
>
> Both require the MS SQL Native Client (go for the latest).
>
> That's it really.
>
> --
> -----
> Richard Quadling
> "Standing on the shoulders of some very clever giants!"
> EE : http://www.experts-exchange.com/M_248814.html
> Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
> ZOPA : http://uk.zopa.com/member/RQuadling
>
Microsoft SQL Server 2008 Native Client
Microsoft SQL Server 2008 Native Client (SQL Native Client) is a
single dynamic-link library (DLL) containing both the SQL OLE DB
provider and SQL ODBC driver. It contains run-time support for
applications using native-code APIs (ODBC, OLE DB and ADO) to connect
to Microsoft SQL Server 2000, 2005, or 2008. SQL Native Client should
be used to create new applications or enhance existing applications
that need to take advantage of new SQL Server 2008 features. This
redistributable installer for SQL Native Client installs the client
components needed during run time to take advantage of new SQL Server
2008 features, and optionally installs the header files needed to
develop an application that uses the SQL Native Client API.
Audience(s): Customer, Partner, Developer
X86 Package (sqlncli.msi) - 4549 KB -
http://go.microsoft.com/fwlink/?LinkId=123717&clcid=0x409
X64 Package (sqlncli.msi) - 7963 KB -
http://go.microsoft.com/fwlink/?LinkId=123718&clcid=0x409
IA64 Package (sqlncli.msi) - 11112 KB -
http://go.microsoft.com/fwlink/?LinkId=123719&clcid=0x409
Microsoft SQL Server 2005 Driver for PHP
The SQL Server 2005 Driver for PHP is a PHP 5 extension that allows
for accessing data in all Editions of SQL Server 2005 and SQL Server
2008 (including Express Editions) from within PHP scripts. The driver
provides a procedural interface for accessing data and makes use of
PHP features, including PHP streams to read and write large objects.
With this release, the source code for the driver is available here:
http://go.microsoft.com/fwlink/?LinkID=123842&clcid=0x409 . The SQL
Server 2005 Driver for PHP relies on the Microsoft SQL Server Native
Client to communicate with SQL Server. For more information about SQL
Server Native Client, visit the SQL Server Native Client page on MSDN.
Audience(s): Developer, DBA
Download site - http://go.microsoft.com/fwlink/?LinkID=123470
--
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
This is a multi-part message in MIME format.
--------------010002060305030605020403
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Richard Quadling wrote:
>>http://www.microsoft.com/downloads/details.aspx?FamilyId=C 6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en
>>
>>
>>Sorry,
>>
>>Would you mind to tell me which for connecting MS-SQL 2000 and PHP ?
>>
>>Thanks !
>>
>>Edward.
>>
>>
>>
>
>Either ODBC or the MS SQL driver for PHP. Which ever suits you.
>
>Both require the MS SQL Native Client (go for the latest).
>
>That's it really.
>
Sorry,
My means is which package support for connecting MS-SQL 2000 from php ?
Due to I don't know which package ( file name ) I download it on the
download site is suitable for me to use...
Thanks !
Edward.
--------------010002060305030605020403
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
Sorry,
Would you mind to tell me which for connecting MS-SQL 2000 and PHP ?
Thanks !
Edward.
Either ODBC or the MS SQL driver for PHP. Which ever suits you.
Both require the MS SQL Native Client (go for the latest).
That's it really.
2010/1/20 Edward S.P. Leong
> Richard Quadling wrote:
>
> http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C 3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en
>
>
> Sorry,
>
> Would you mind to tell me which for connecting MS-SQL 2000 and PHP ?
>
> Thanks !
>
> Edward.
>
>
>
> Either ODBC or the MS SQL driver for PHP. Which ever suits you.
>
> Both require the MS SQL Native Client (go for the latest).
>
> That's it really.
>
> Sorry,
>
> My means is which package support for connecting MS-SQL 2000 from php ?
> Due to I don't know which package ( file name ) I download it on the
> download site is suitable for me to use...
>
> Thanks !
>
> Edward.
>
As you are running IIS + PHP in 32bit mode, I'd stick with the x86 packages.
--
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling
--------------040705040204020807090304
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Richard Quadling wrote:
>2010/1/20 Edward S.P. Leong
>
>
>>Richard Quadling wrote:
>>
>>http://www.microsoft.com/downloads/details.aspx?FamilyId=C 6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en
>>
>>
>>Sorry,
>>
>>Would you mind to tell me which for connecting MS-SQL 2000 and PHP ?
>>
>>Thanks !
>>
>>Edward.
>>
>>
>>
>>Either ODBC or the MS SQL driver for PHP. Which ever suits you.
>>
>>Both require the MS SQL Native Client (go for the latest).
>>
>>That's it really.
>>
>>Sorry,
>>
>>My means is which package support for connecting MS-SQL 2000 from php ?
>>Due to I don't know which package ( file name ) I download it on the
>>download site is suitable for me to use...
>>
>>Thanks !
>>
>>Edward.
>>
>>
>>
>
>As you are running IIS + PHP in 32bit mode, I'd stick with the x86 packages.
>
>
>
Hello,
Do you means the x86 is suitable for me now ?
Thanks !
Edward.
--------------040705040204020807090304--
2010/1/20 Edward S.P. Leong
> Richard Quadling wrote:
>
> 2010/1/20 Edward S.P. Leong
>
>
> Richard Quadling wrote:
>
> http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C 3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en
>
>
> Sorry,
>
> Would you mind to tell me which for connecting MS-SQL 2000 and PHP ?
>
> Thanks !
>
> Edward.
>
>
>
> Either ODBC or the MS SQL driver for PHP. Which ever suits you.
>
> Both require the MS SQL Native Client (go for the latest).
>
> That's it really.
>
> Sorry,
>
> My means is which package support for connecting MS-SQL 2000 from php ?
> Due to I don't know which package ( file name ) I download it on the
> download site is suitable for me to use...
>
> Thanks !
>
> Edward.
>
>
>
> As you are running IIS + PHP in 32bit mode, I'd stick with the x86 packages.
>
>
>
> Hello,
>
> Do you means the x86 is suitable for me now ?
>
> Thanks !
>
> Edward.
>
If you were running 64 bit everything, then obviously, you would use
the 64 bit packages.
But you are running IIS and PHP in 32bit mode, so, for ease of
compatibility, the 32bit packages (x86 rather than x64) are what I
would be using.
In terms of which one you want to use, well, you have to get the Native Client.
From there you can either use odbc (built into PHP for Windows) or use
the MS SQL Driver for PHP.
Both of them use the Native Client.
As the MS SQL driver is fairly new, you may want to stick with the
ODBC route within PHP.
--
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling