[PHP-DEV] Bug #5332 Updated: ODBC Connect Fails for Sybase SQLanywhere DB From: sniper <email protected>
Date: 06/27/01

ID: 5332
Updated by: sniper
Reported By: wade <email protected>
Old-Status: Open
Status: Assigned
Bug Type: ODBC related
Operating system:
PHP Version: 4.0 Release Candidate 2
Assigned To: joey
Comments:

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

[2001-05-17 04:48:08] wade <email protected>
The first parameter of the odbc_connect function call is datasource name. If I don't supply a valid datasource name as maintained in the odbc datasource administrator, I receive the following error message:

Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:Inetpubwwwrootwjsqlanywhere.php on line 16

If I provide a valid datasource name, I receive the following error message:

Warning: SQL error: [Sybase][ODBC Driver]Unable to connect to database server: database engine not running, SQL state 08001 in SQLConnect in C:Inetpubwwwrootwjsqlanywhere.php on line 16

Please note once again. THE VERY SAME datasource definition can be used to connect to the database via Excel or Borland C++, etc.

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

[2001-05-16 19:01:32] kalowsky <email protected>
The SQL error you are receiving is "Server rejected access"
I'm wondering if your odbc_connect only needs "wald" instead
of "waldserver - wald"

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

[2001-03-26 16:22:39] wade <email protected>
Yes, this is still happening. I have loaded PHP version 4.04 PL1. I am trying to run the following simple script:

---------------------------------------------------------
<html>

<head>
<title>Neue Seite 2</title>
</head>

<body>

<?php

$connect = odbc_connect("wadlserv - wadl","johnsonw","password");
echo "Odbc connection variable: $connect";
$returncode = odbc_exec($connect, "select * from testtable;");
echo $returncode;
odbc_close($connect);
$date = date("m.d.Y G:i:s T");
echo $date;

?>
</body>

</html>

--------------------------------------------------------
The output I receive is:

Warning: SQL error: [Sybase][ODBC Driver]Unable to connect to database server: unable to start database engine, SQL state 08001 in SQLConnect in c:inetpubwwwrootodbctestdefault.php on line 11
Odbc connection variable:
Warning: Supplied argument is not a valid ODBC-Link resource in c:inetpubwwwrootodbctestdefault.php on line 13

Warning: Supplied argument is not a valid ODBC-Link resource in c:inetpubwwwrootodbctestdefault.php on line 15

Warning: Supplied argument is not a valid ODBC-Link resource in c:inetpubwwwrootodbctestdefault.php on line 15
03.26.2001 22:50:23 Westeuropäische Normalzeit

---------------------------------------------------------
I have enabled the ODBC log. However, the log shows absolutely nothing for this ODBC connection attempt via PHP. I can connect via Excel and Borland DB explorer for example. Here are excerpts from the odbc logs:

ODBC via Excel:

MSQRY32 5ac-850 ENTER SQLDriverConnectW
                HDBC 00811910
                HWND 00020564
                WCHAR * 0x1F7D8B70 [ -3] "****** 0"
                SWORD -3
                WCHAR * 0x1F7D8B70
                SWORD 8
                SWORD * 0x00000000
                UWORD 1 <SQL_DRIVER_COMPLETE>

MSQRY32 5ac-850 EXIT SQLDriverConnectW with return code 0 (SQL_SUCCESS)
                HDBC 00811910
                HWND 00020564
                WCHAR * 0x1F7D8B70 [ -3] "****** 0"
                SWORD -3
                WCHAR * 0x1F7D8B70
                SWORD 8
                SWORD * 0x00000000
                UWORD 1 <SQL_DRIVER_COMPLETE>

MSQRY32 5ac-850 ENTER SQLGetInfoW
                HDBC 00811910
                UWORD 2 <SQL_DATA_SOURCE_NAME>
                PTR 0x00811A40
                SWORD 2048
                SWORD * 0x0006EF96

MSQRY32 5ac-850 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
                HDBC 00811910
                UWORD 2 <SQL_DATA_SOURCE_NAME>
                PTR 0x00811A40 [ 30] "wadlserv - wadl"
                SWORD 2048
                SWORD * 0x0006EF96 (30)

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

ODBC from Borland DB Explorer:
dbexplor 88c-850 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS)
                HENV 02B314F0
                UWORD 1 <SQL_FETCH_NEXT>
                WCHAR * 0x02B31658 [ 15] "wadlser"
                SWORD 33
                SWORD * 0x0012EFAA (15)
                WCHAR * 0x02B322E8 [ 23] "Sybase SQL "
                SWORD 257
                SWORD * 0x0012EFA8 (23)

dbexplor 88c-850 ENTER SQLAllocConnect
                HENV 02B314F0
                HDBC * 013386EC

dbexplor 88c-850 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
                HENV 02B314F0
                HDBC * 0x013386EC ( 0x02b316b0)

dbexplor 88c-850 ENTER SQLConnectW
                HDBC 02B316B0
                WCHAR * 0x02B317B8 [ -3] "wadlserv - wadl 0"
                SWORD -3
                WCHAR * 0x1F7D8B70 [ -3] "****** 0"
                SWORD -3
                WCHAR * 0x1F7D8B70 [ -3] "****** 0"
                SWORD -3

dbexplor 88c-850 EXIT SQLConnectW with return code 0 (SQL_SUCCESS)
                HDBC 02B316B0
                WCHAR * 0x02B317B8 [ -3] "wadlserv - wadl 0"
                SWORD -3
                WCHAR * 0x1F7D8B70 [ -3] "****** 0"
                SWORD -3
                WCHAR * 0x1F7D8B70 [ -3] "****** 0"
                SWORD -3

----------------------------------------------------------
Here is the phpinfo() function output for my setup:

PHP Version 4.0.4pl1

System Windows NT 5.0 build 2195
Build Date Jan 12 2001
Server API CGI
Virtual Directory Support enabled
Configuration File (php.ini) Path php.ini
ZEND_DEBUG disabled
Thread Safety enabled

 This program makes use of the Zend scripting language engine:
Zend Engine v1.0.4, Copyright (c) 1998-2000 Zend Technologies

 

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

PHP 4.0 Credits

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

Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference
 On On
allow_url_fopen
 1 1
arg_separator
 & &
asp_tags
 Off Off
auto_append_file
 no value no value
auto_prepend_file
 no value no value
browscap
 no value no value
default_charset
 no value no value
default_mimetype
 text/html text/html
define_syslog_variables
 Off Off
disable_functions
 no value no value
display_errors
 On On
display_startup_errors
 Off Off
doc_root
 no value no value
enable_dl
 On On
error_append_string
 Off Off
error_log
 no value no value
error_prepend_string
 Off Off
error_reporting
 2047 2047
expose_php
 On On
extension_dir
 c:phpextensions c:phpextensions
file_uploads
 1 1
gpc_order
 GPC GPC
highlight.bg
 #FFFFFF #FFFFFF
highlight.comment
 #FF8000 #FF8000
highlight.default
 #0000BB #0000BB
highlight.html
 #000000 #000000
highlight.keyword
 #007700 #007700
highlight.string
 #DD0000 #DD0000
html_errors
 On On
ignore_user_abort
 Off Off
implicit_flush
 Off Off
include_path
 no value no value
log_errors
 Off Off
magic_quotes_gpc
 On On
magic_quotes_runtime
 Off Off
magic_quotes_sybase
 Off Off
max_execution_time
 30 30
open_basedir
 no value no value
output_buffering
 Off Off
output_handler
 no value no value
post_max_size
 8M 8M
precision
 14 14
register_argc_argv
 On On
register_globals
 On On
safe_mode
 Off Off
safe_mode_exec_dir
 no value no value
sendmail_from
 me <email protected> me <email protected>
sendmail_path
 no value no value
short_open_tag
 On On
SMTP
 localhost localhost
sql.safe_mode
 Off Off
track_errors
 Off Off
upload_max_filesize
 2M 2M
upload_tmp_dir
 C:PHPuploadtemp C:PHPuploadtemp
user_dir
 no value no value
variables_order
 EGPCS EGPCS
y2k_compliance
 Off Off

interbase
Interbase Support enabled
Revision $Revision: 1.48 $
Dynamic Module yes
Allow Persistent Links Yes
Persistent Links 0/unlimited
Total Links 0/unlimited
Timestamp Format %m/%d/%Y %H:%M:%S
Date Format %m/%d/%Y
Time Format %H:%M:%S

pdf
PDF Support enabled
PDFLib Version 3.03
CJK Font Support yes
In-memory PDF Creation Support yes

standard
Regex Library Bundled library enabled
Dynamic Library Support enabled
Internal Sendmail Support for Windows 4 enabled

Directive Local Value Master Value
assert.active
 1 1
assert.bail
 0 0
assert.callback
 no value no value
assert.quiet_eval
 0 0
assert.warning
 1 1
safe_mode_allowed_env_vars
 PHP_ PHP_
safe_mode_protected_env_vars
 LD_LIBRARY_PATH LD_LIBRARY_PATH
session.use_trans_sid
 1 1
url_rewriter.tags
 a=href,area=href,frame=src,form=fakeentry a=href,area=href,frame=src,form=fakeentry

bcmath
BCMath support enabled

Calendar
Calendar support enabled

com
Directive Local Value Master Value
allow_dcom
 Off Off
typelib_file
 no value no value

ftp
FTP support enabled

mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 3.23.22-beta

Directive Local Value Master Value
mysql.allow_persistent
 On On
mysql.default_host
 no value no value
mysql.default_password
 no value no value
mysql.default_port
 no value no value
mysql.default_socket
 no value no value
mysql.default_user
 no value no value
mysql.max_links
 Unlimited Unlimited
mysql.max_persistent
 Unlimited Unlimited

odbc
ODBC Support enabled
Active Persistent Links 0
Active Links 0
ODBC library Win32

Directive Local Value Master Value
odbc.allow_persistent
 On On
odbc.check_persistent
 On On
odbc.default_db
 no value no value
odbc.default_pw
   
odbc.default_user
 no value no value
odbc.defaultbinmode
 return as is return as is
odbc.defaultlrl
 return up to 4096 bytes return up to 4096 bytes
odbc.max_links
 Unlimited Unlimited
odbc.max_persistent
 Unlimited Unlimited

pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 3.1 09-Feb-2000

session
Session Support enabled

Directive Local Value Master Value
session.auto_start
 Off Off
session.cache_expire
 180 180
session.cache_limiter
 nocache nocache
session.cookie_domain
 no value no value
session.cookie_lifetime
 0 0
session.cookie_path
 / /
session.cookie_secure
 Off Off
session.entropy_file
 no value no value
session.entropy_length
 0 0
session.gc_maxlifetime
 1440 1440
session.gc_probability
 1 1
session.name
 PHPSESSID PHPSESSID
session.referer_check
 no value no value
session.save_handler
 files files
session.save_path
 C:PHPsessiondata C:PHPsessiondata
session.serialize_handler
 php php
session.use_cookies
 On On

xml
XML Support active

wddx
WDDX Support enabled

Additional Modules

Environment
Variable Value
ALLUSERSPROFILE C:Dokumente und EinstellungenAll Users
CommonProgramFiles C:ProgrammeGemeinsame Dateien
COMPUTERNAME WADL
ComSpec C:WINNTsystem32cmd.exe
CONTENT_LENGTH 0
GATEWAY_INTERFACE CGI/1.1
HTTP_ACCEPT */*
HTTP_ACCEPT_LANGUAGE de
HTTP_CONNECTION Keep-Alive
HTTP_HOST wadl
HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
HTTP_COOKIE ASPSESSIONIDGGGQGNBY=MBIFJLJAKEKDEEJALLCFEAGD
HTTP_ACCEPT_ENCODING gzip, deflate
HTTPS off
INSTANCE_ID 1
LOCAL_ADDR 127.0.0.1
NUMBER_OF_PROCESSORS 1
Os2LibPath C:WINNTsystem32os2dll;
OS Windows_NT
Path C:Perlbin;C:PROGRA~1BorlandCBUILD~1ProjectsBpl;C:PROGRA~1BorlandCBUILD~1Bin;C:WINNTsystem32;C:WINNT;C:WINNTSystem32Wbem;c:sybtoolswin32;c:programmephp4;
PATH_INFO /odbctest/default.php
PATH_TRANSLATED c:inetpubwwwrootodbctestdefault.php
PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE x86
PROCESSOR_IDENTIFIER x86 Family 6 Model 3 Stepping 4, GenuineIntel
PROCESSOR_LEVEL 6
PROCESSOR_REVISION 0304
ProgramFiles C:Programme
REMOTE_ADDR 127.0.0.1
REMOTE_HOST 127.0.0.1
REQUEST_METHOD GET
SCRIPT_NAME /odbctest/default.php
SERVER_NAME wadl
SERVER_PORT 80
SERVER_PORT_SECURE 0
SERVER_PROTOCOL HTTP/1.1
SERVER_SOFTWARE Microsoft-IIS/5.0
SystemDrive C:
SystemRoot C:WINNT
TEMP C:WINNTTEMP
TMP C:WINNTTEMP
USERPROFILE C:Dokumente und EinstellungenDefault User
windir C:WINNT

PHP Variables
Variable Value
PHP_SELF /odbctest/default.php
HTTP_COOKIE_VARS["ASPSESSIONIDGGGQGNBY"] MBIFJLJAKEKDEEJALLCFEAGD
HTTP_SERVER_VARS["ALLUSERSPROFILE"] C:\Dokumente und Einstellungen\All Users
HTTP_SERVER_VARS["CommonProgramFiles"] C:\Programme\Gemeinsame Dateien
HTTP_SERVER_VARS["COMPUTERNAME"] WADL
HTTP_SERVER_VARS["ComSpec"] C:\WINNT\system32\cmd.exe
HTTP_SERVER_VARS["CONTENT_LENGTH"] 0
HTTP_SERVER_VARS["GATEWAY_INTERFACE"] CGI/1.1
HTTP_SERVER_VARS["HTTP_ACCEPT"] */*
HTTP_SERVER_VARS["HTTP_ACCEPT_LANGUAGE"] de
HTTP_SERVER_VARS["HTTP_CONNECTION"] Keep-Alive
HTTP_SERVER_VARS["HTTP_HOST"] wadl
HTTP_SERVER_VARS["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
HTTP_SERVER_VARS["HTTP_COOKIE"] ASPSESSIONIDGGGQGNBY=MBIFJLJAKEKDEEJALLCFEAGD
HTTP_SERVER_VARS["HTTP_ACCEPT_ENCODING"] gzip, deflate
HTTP_SERVER_VARS["HTTPS"] off
HTTP_SERVER_VARS["INSTANCE_ID"] 1
HTTP_SERVER_VARS["LOCAL_ADDR"] 127.0.0.1
HTTP_SERVER_VARS["NUMBER_OF_PROCESSORS"] 1
HTTP_SERVER_VARS["Os2LibPath"] C:\WINNT\system32\os2\dll;
HTTP_SERVER_VARS["OS"] Windows_NT
HTTP_SERVER_VARS["Path"] C:\Perl\bin\;C:\PROGRA~1\Borland\CBUILD~1\Projects\Bpl;C:\PROGRA~1\Borland\CBUILD~1\Bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;c:\sybtools\win32;c:\programme\php4;
HTTP_SERVER_VARS["PATH_INFO"] /odbctest/default.php
HTTP_SERVER_VARS["PATH_TRANSLATED"] c:\inetpub\wwwroot\odbctest\default.php
HTTP_SERVER_VARS["PATHEXT"] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
HTTP_SERVER_VARS["PROCESSOR_ARCHITECTURE"] x86
HTTP_SERVER_VARS["PROCESSOR_IDENTIFIER"] x86 Family 6 Model 3 Stepping 4, GenuineIntel
HTTP_SERVER_VARS["PROCESSOR_LEVEL"] 6
HTTP_SERVER_VARS["PROCESSOR_REVISION"] 0304
HTTP_SERVER_VARS["ProgramFiles"] C:\Programme
HTTP_SERVER_VARS["REMOTE_ADDR"] 127.0.0.1
HTTP_SERVER_VARS["REMOTE_HOST"] 127.0.0.1
HTTP_SERVER_VARS["REQUEST_METHOD"] GET
HTTP_SERVER_VARS["SCRIPT_NAME"] /odbctest/default.php
HTTP_SERVER_VARS["SERVER_NAME"] wadl
HTTP_SERVER_VARS["SERVER_PORT"] 80
HTTP_SERVER_VARS["SERVER_PORT_SECURE"] 0
HTTP_SERVER_VARS["SERVER_PROTOCOL"] HTTP/1.1
HTTP_SERVER_VARS["SERVER_SOFTWARE"] Microsoft-IIS/5.0
HTTP_SERVER_VARS["SystemDrive"] C:
HTTP_SERVER_VARS["SystemRoot"] C:\WINNT
HTTP_SERVER_VARS["TEMP"] C:\WINNT\TEMP
HTTP_SERVER_VARS["TMP"] C:\WINNT\TEMP
HTTP_SERVER_VARS["USERPROFILE"] C:\Dokumente und Einstellungen\Default User
HTTP_SERVER_VARS["windir"] C:\WINNT
HTTP_SERVER_VARS["PHP_SELF"] /odbctest/default.php
HTTP_SERVER_VARS["argv"] Array
(
)

 
HTTP_SERVER_VARS["argc"] 0
HTTP_ENV_VARS["ALLUSERSPROFILE"] C:\Dokumente und Einstellungen\All Users
HTTP_ENV_VARS["CommonProgramFiles"] C:\Programme\Gemeinsame Dateien
HTTP_ENV_VARS["COMPUTERNAME"] WADL
HTTP_ENV_VARS["ComSpec"] C:\WINNT\system32\cmd.exe
HTTP_ENV_VARS["CONTENT_LENGTH"] 0
HTTP_ENV_VARS["GATEWAY_INTERFACE"] CGI/1.1
HTTP_ENV_VARS["HTTP_ACCEPT"] */*
HTTP_ENV_VARS["HTTP_ACCEPT_LANGUAGE"] de
HTTP_ENV_VARS["HTTP_CONNECTION"] Keep-Alive
HTTP_ENV_VARS["HTTP_HOST"] wadl
HTTP_ENV_VARS["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
HTTP_ENV_VARS["HTTP_COOKIE"] ASPSESSIONIDGGGQGNBY=MBIFJLJAKEKDEEJALLCFEAGD
HTTP_ENV_VARS["HTTP_ACCEPT_ENCODING"] gzip, deflate
HTTP_ENV_VARS["HTTPS"] off
HTTP_ENV_VARS["INSTANCE_ID"] 1
HTTP_ENV_VARS["LOCAL_ADDR"] 127.0.0.1
HTTP_ENV_VARS["NUMBER_OF_PROCESSORS"] 1
HTTP_ENV_VARS["Os2LibPath"] C:\WINNT\system32\os2\dll;
HTTP_ENV_VARS["OS"] Windows_NT
HTTP_ENV_VARS["Path"] C:\Perl\bin\;C:\PROGRA~1\Borland\CBUILD~1\Projects\Bpl;C:\PROGRA~1\Borland\CBUILD~1\Bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;c:\sybtools\win32;c:\programme\php4;
HTTP_ENV_VARS["PATH_INFO"] /odbctest/default.php
HTTP_ENV_VARS["PATH_TRANSLATED"] c:\inetpub\wwwroot\odbctest\default.php
HTTP_ENV_VARS["PATHEXT"] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
HTTP_ENV_VARS["PROCESSOR_ARCHITECTURE"] x86
HTTP_ENV_VARS["PROCESSOR_IDENTIFIER"] x86 Family 6 Model 3 Stepping 4, GenuineIntel
HTTP_ENV_VARS["PROCESSOR_LEVEL"] 6
HTTP_ENV_VARS["PROCESSOR_REVISION"] 0304
HTTP_ENV_VARS["ProgramFiles"] C:\Programme
HTTP_ENV_VARS["REMOTE_ADDR"] 127.0.0.1
HTTP_ENV_VARS["REMOTE_HOST"] 127.0.0.1
HTTP_ENV_VARS["REQUEST_METHOD"] GET
HTTP_ENV_VARS["SCRIPT_NAME"] /odbctest/default.php
HTTP_ENV_VARS["SERVER_NAME"] wadl
HTTP_ENV_VARS["SERVER_PORT"] 80
HTTP_ENV_VARS["SERVER_PORT_SECURE"] 0
HTTP_ENV_VARS["SERVER_PROTOCOL"] HTTP/1.1
HTTP_ENV_VARS["SERVER_SOFTWARE"] Microsoft-IIS/5.0
HTTP_ENV_VARS["SystemDrive"] C:
HTTP_ENV_VARS["SystemRoot"] C:\WINNT
HTTP_ENV_VARS["TEMP"] C:\WINNT\TEMP
HTTP_ENV_VARS["TMP"] C:\WINNT\TEMP
HTTP_ENV_VARS["USERPROFILE"] C:\Dokumente und Einstellungen\Default User
HTTP_ENV_VARS["windir"] C:\WINNT

PHP License
This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

If you did not receive a copy of the PHP license, or have any questions about PHP licensing, please contact license <email protected>
 

----------------------------------------------------------
Please let me know if I can provide you with any additional information.

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

The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online.

ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=5332&edit=2 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>