Re: 64 Bit IIS 6 ( 32 Bit mode ) + 32Bit php connect with MS-SQL Server

From: Date: Tue, 19 Jan 2010 13:46:25 +0000
Subject: Re: 64 Bit IIS 6 ( 32 Bit mode ) + 32Bit php connect with MS-SQL Server
References: 1 2 3 4 5 6  Groups: php.general php.install 
Request: Send a blank email to php-general+get-301215@lists.php.net to get a copy of this message
2010/1/19 Edward S.P. Leong <edwardspl@ita.org.mo>: > 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=C6C3E9EF-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

« previous php.general (#301215) next »