ID: 5332
Updated by: sniper
Reported By: [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] [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] [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] [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
[EMAIL PROTECTED] [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 [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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
