ID: 18169
Comment by: gautam dot webprogram at yahoo dot com
Reported By: joesterg at hotmail dot com
Status: No Feedback
Bug Type: MSSQL related
Operating System: Windows 2000 Server
PHP Version: 4.1.2
New Comment:
I want to connect php with MS SQL Server 2000 I have used the folloing
code in PHP:
<?
$connection = mysql_connect ("localhost","user name","password");
if (!$connection) {
echo "Couldn't make a connection!";
exit;
}
?>
The code doesn't execute.
Previous Comments:
------------------------------------------------------------------------
[2006-09-09 01:18:11] aireater at gmail dot com
I still have the same issue with the latest Windows binary 5.1.6 and MS
SQL Server 2005 Express, Standard, Enterprise on Windows XP, 2003
Server. It never works.
------------------------------------------------------------------------
[2006-04-20 01:24:43] timdilbert at gmail dot com
Just out of curiousity I was wondering if this was fixed in PHP5 and
MSSQL 2005??
I haven't tried using COM just yet, but I will be when I get home (on
MSSQL 2000). But I was having the same problem with PHP5 and inserting
UTF-8 encoding into MSSQL Server 2000.
I will post if this fixed my problem. If not, I'm really sorry guys.. I
love PHP, but I might be be rebuilding my entire site is C# because
Unicode support is absolutly vital to our company and success.
------------------------------------------------------------------------
[2004-04-15 06:07:34] samlinxp at msn dot com
I have the same problem.
My setup is:
Windows XP Server, with Apache 2.0.47/PHP 4.3.6RC3 and Microsoft SQL
Server 2000
Hope this problem can be solved soon. This is quite important
especially at Asia Pacific's regions (CHN, HK, TW, JP, KR.. etc)
------------------------------------------------------------------------
[2003-06-29 21:33:00] [EMAIL PROTECTED]
Please try using this CVS snapshot:
http://snaps.php.net/php4-STABLE-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php4-win32-STABLE-latest.zip
------------------------------------------------------------------------
[2002-12-18 18:18:47] fvu at wanadoo dot nl
If you're using PHP on a Windows platform you can use the PHP COM
extension to communicate with SQL Server via ADO. The PHP COM
extension is capable of translating UTF-8 to UCS-2 and back if you
specify so as the third parameter:
$oDb = new COM('ADODB.Connection', NULL, CP_UTF8);
This way you can use Unicode UTF-8 within PHP and Unicode UCS-2 within
SQL Server with all the translations done for you automatically.
HTH, Freddy Vulto
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/18169
--
Edit this bug report at http://bugs.php.net/?id=18169&edit=1
