#40796 [NEW]: ODBC connect fails using

[callahal at vaniercollege dot qc dot ca]

From: callahal at vaniercollege dot qc dot ca
Operating system: Windows 2003 svr std
PHP version: 5.2.1
PHP Bug Type: ODBC related
Bug description: ODBC connect fails using

Description:
------------
Setup is
Windows 2003 Server STD, IIS6, PHP 5.2.1
using php-cgi.exe I cannoct connect to my system dsn datasource
which, as shown, is the northwind sample database on Ms_SQL Server 2000.
If I use php5isapi.dll, everything works fine.
However I prefer to use the php-cgi.exe.

All of php.exe, php-cgi.exe and php5isapi.dll work fine with ODBC connects
with PHP version 5.2.0.




Reproduce code:
---------------
if($odbc_db = odbc_connect('Northwind', 'sample', 'sample')){
echo "Connected AOK". eol ;
}else{
die("Could not connect to ODBC data source Northwind");
}

Expected result:
----------------
I should connect


--
Edit bug report at [url]http://bugs.php.net/?id=40796&edit=1[/url]
--
Try a CVS snapshot (PHP 4.4): [url]http://bugs.php.net/fix.php?id=40796&r=trysnapshot44[/url]
Try a CVS snapshot (PHP 5.2): [url]http://bugs.php.net/fix.php?id=40796&r=trysnapshot52[/url]
Try a CVS snapshot (PHP 6.0): [url]http://bugs.php.net/fix.php?id=40796&r=trysnapshot60[/url]
Fixed in CVS: [url]http://bugs.php.net/fix.php?id=40796&r=fixedcvs[/url]
Fixed in release: [url]http://bugs.php.net/fix.php?id=40796&r=alreadyfixed[/url]
Need backtrace: [url]http://bugs.php.net/fix.php?id=40796&r=needtrace[/url]
Need Reproduce Script: [url]http://bugs.php.net/fix.php?id=40796&r=needscript[/url]
Try newer version: [url]http://bugs.php.net/fix.php?id=40796&r=oldversion[/url]
Not developer issue: [url]http://bugs.php.net/fix.php?id=40796&r=support[/url]
Expected behavior: [url]http://bugs.php.net/fix.php?id=40796&r=notwrong[/url]
Not enough info: [url]http://bugs.php.net/fix.php?id=40796&r=notenoughinfo[/url]
Submitted twice: [url]http://bugs.php.net/fix.php?id=40796&r=submittedtwice[/url]
register_globals: [url]http://bugs.php.net/fix.php?id=40796&r=globals[/url]
PHP 3 support discontinued: [url]http://bugs.php.net/fix.php?id=40796&r=php3[/url]
Daylight Savings: [url]http://bugs.php.net/fix.php?id=40796&r=dst[/url]
IIS Stability: [url]http://bugs.php.net/fix.php?id=40796&r=isapi[/url]
Install GNU Sed: [url]http://bugs.php.net/fix.php?id=40796&r=gnused[/url]
Floating point limitations: [url]http://bugs.php.net/fix.php?id=40796&r=float[/url]
No Zend Extensions: [url]http://bugs.php.net/fix.php?id=40796&r=nozend[/url]
MySQL Configuration Error: [url]http://bugs.php.net/fix.php?id=40796&r=mysqlcfg[/url]

[tony2001@php.net]

ID: 40796
Updated by: [email]tony2001@php.net[/email]
Reported By: callahal at vaniercollege dot qc dot ca
-Status: Open
+Status: Bogus
Bug Type: ODBC related
Operating System: Windows 2003 svr std
PHP Version: 5.2.1
New Comment:

Sorry, but your problem does not imply a bug in PHP itself. For a
list of more appropriate places to ask for help using PHP, please
visit [url]http://www.php.net/support.php[/url] as this bug system is not the
appropriate forum for asking support questions. Due to the volume
of reports we can not explain in detail here why your report is not
a bug. The support channels will be able to provide an explanation
for you.

Thank you for your interest in PHP.

Use odbc_errormsg() to get the error message.


Previous Comments:
------------------------------------------------------------------------

[2007-03-13 18:07:42] callahal at vaniercollege dot qc dot ca

Description:
------------
Setup is
Windows 2003 Server STD, IIS6, PHP 5.2.1
using php-cgi.exe I cannoct connect to my system dsn datasource
which, as shown, is the northwind sample database on Ms_SQL Server
2000.
If I use php5isapi.dll, everything works fine.
However I prefer to use the php-cgi.exe.

All of php.exe, php-cgi.exe and php5isapi.dll work fine with ODBC
connects with PHP version 5.2.0.




Reproduce code:
---------------
if($odbc_db = odbc_connect('Northwind', 'sample', 'sample')){
echo "Connected AOK". eol ;
}else{
die("Could not connect to ODBC data source Northwind");
}

Expected result:
----------------
I should connect



------------------------------------------------------------------------


--
Edit this bug report at [url]http://bugs.php.net/?id=40796&edit=1[/url]

[callahal at vaniercollege dot qc dot ca]

ID: 40796
User updated by: callahal at vaniercollege dot qc dot ca
Reported By: callahal at vaniercollege dot qc dot ca
Status: Bogus
Bug Type: ODBC related
Operating System: Windows 2003 svr std
PHP Version: 5.2.1
New Comment:

Well If you say it's bogus -- fine.
But as I said, on the same machine - swap out the 5.2.1 and put back
5.2.0 and everything works fine. And BTW it's only the ODBC connect
that doesn't work OCi8 works fine and so does MySQL connections.
But what do I know.


Previous Comments:
------------------------------------------------------------------------

[2007-03-13 19:12:33] [email]tony2001@php.net[/email]

Sorry, but your problem does not imply a bug in PHP itself. For a
list of more appropriate places to ask for help using PHP, please
visit [url]http://www.php.net/support.php[/url] as this bug system is not the
appropriate forum for asking support questions. Due to the volume
of reports we can not explain in detail here why your report is not
a bug. The support channels will be able to provide an explanation
for you.

Thank you for your interest in PHP.

Use odbc_errormsg() to get the error message.

------------------------------------------------------------------------

[2007-03-13 18:07:42] callahal at vaniercollege dot qc dot ca

Description:
------------
Setup is
Windows 2003 Server STD, IIS6, PHP 5.2.1
using php-cgi.exe I cannoct connect to my system dsn datasource
which, as shown, is the northwind sample database on Ms_SQL Server
2000.
If I use php5isapi.dll, everything works fine.
However I prefer to use the php-cgi.exe.

All of php.exe, php-cgi.exe and php5isapi.dll work fine with ODBC
connects with PHP version 5.2.0.




Reproduce code:
---------------
if($odbc_db = odbc_connect('Northwind', 'sample', 'sample')){
echo "Connected AOK". eol ;
}else{
die("Could not connect to ODBC data source Northwind");
}

Expected result:
----------------
I should connect



------------------------------------------------------------------------


--
Edit this bug report at [url]http://bugs.php.net/?id=40796&edit=1[/url]