Home  |  Linux  | Mysql  | PHP  | XML
From:Richard Quadling Date:Tue Jan 19 13:15:43 2010
Subject:Re: 64 Bit IIS 6 ( 32 Bit mode ) + 32Bit php connect with
MS-SQL Server
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
Navigate in group php.install at sever news.php.net
Previous Next


Your recent visits
Re: [PHP] simplexml - can it do what I need?
LMPX.COM :: Linux, Mysql, Php, Xml
Re: [PHP-INSTALL] Browser tries to download php file
Re: Dumping vars from CGI with Data::Dumper


  
© No Copyright
You are free to use Anything
Site Maintained by Zareef Ahmed
Powered By PHP Consultants