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

["Edward S.P. Leong" <edwardspl@xxxxxxxxxx>]

Richard Quadling wrote:

2010/1/19 Edward S.P. Leong <edwardspl@xxxxxxxxxx>:
  

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
  

Sorry,

Would you mind to tell me which for connecting MS-SQL 2000 and PHP ?

Thanks !

Edward.