64 Bit IIS 6 ( 32 Bit mode ) + 32Bit php connect with MS-SQL Server
in [General]
|
Prev: Zend debugger doesn't work
Next: Casting objects.
From: "Edward S.P. Leong" on 18 Jan 2010 07:14 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.
From: Richard Quadling on 18 Jan 2010 08:57 2010/1/18 Edward S.P. Leong <edwardspl(a)ita.org.mo>: > 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 <location_of_php.ini file> -m 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
From: Richard Quadling on 19 Jan 2010 08:11 2010/1/19 <edwardspl(a)ita.org.mo>: > å¼è¿° Richard Quadling <rquadling(a)googlemail.com>: > >> 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  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 <location_of_php.ini file> -m > > 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       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 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(a)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=9b2da534-3e03-4391-8a4d-074b9f2bc1bf&displaylang=en 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. -- ----- 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
From: Richard Quadling on 19 Jan 2010 08:15 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
From: "Edward S.P. Leong" on 19 Jan 2010 08:36
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 ! |