Hiya all;
I have been trying so hard to get that done.. and i posted many here. but
with no hope.. here is a summury of what i did:
- I tried FreeTDS as a driver with unixODBC ...
- Tried to remove mysql- apache - php and recomplied them with : iodbc
- Tried to try openlink driver.
- tried to upgrade from redhat 7.3 to 9 as i faced do much problem with gcc
compiler when i compiled php and apache..
All the above with no hope ....
so finaly , i formated the system then i installed a clean RedHat 9 with
apache and php 4.2.2 and when i echo phpinfo() i got the following
BUT WHAT IS dbx and there is Micrososft SQL server
and when i call odbc_connect ... i got Warning: SQL error:
[unixODBC][Driver Manager]Data source name not found, and no default driver
specified, SQL state IM002 in SQLConnect in /var/www/html/louai.php on line
11
if my work was right .. how can i link the driver (FreeTDS and then the
DSN..)
/////
PHP Version 4.2.2
System Linux sylvester.devel.redhat.com 2.4.20-2.41smp #1 SMP Sun Feb
9 09:29:47 EST 2003 i686 athlon i386 GNU/Linux
Build Date Feb 25 2003 09:44:31
Configure Command './configure' '--host=i386-redhat-linux'
'--build=i386-redhat-linux' '--target=i386-redhat-linux-gnu'
'--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin'
'--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share'
'--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec'
'--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man'
'--infodir=/usr/share/info' '--cache-file=../config.cache'
'--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d'
'--enable-force-cgi-redirect' '--disable-debug' '--enable-pic'
'--disable-rpath' '--enable-inline-optimization' '--with-bz2' '--with-db3'
'--with-curl' '--with-dom=/usr' '--with-exec-dir=/usr/bin'
'--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-gd'
'--enable-gd-native-ttf' '--with-ttf' '--with-gdbm' '--with-gettext'
'--with-ncurses' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr'
'--with-openssl' '--with-png' '--with-pspell' '--with-regex=system'
'--with-xml' '--with-expat-dir=/usr' '--with-zlib' '--with-layout=GNU'
'--enable-bcmath' '--enable-exif' '--enable-ftp' '--enable-magic-quotes'
'--enable-safe-mode' '--enable-sockets' '--enable-sysvsem'
'--enable-sysvshm' '--enable-discard-path' '--enable-track-vars'
'--enable-trans-sid' '--enable-yp' '--enable-wddx' '--without-oci8'
'--with-pear=/usr/share/pear' '--with-imap=shared' '--with-imap-ssl'
'--with-kerberos=/usr/kerberos' '--with-ldap=shared'
'--with-mysql=shared,/usr' '--with-pgsql=shared' '--with-snmp=shared,/usr'
'--with-snmp=shared' '--enable-ucd-snmp-hack' '--with-unixODBC=shared'
'--enable-memory-limit' '--enable-bcmath' '--enable-shmop'
'--enable-versioning' '--enable-calendar' '--enable-dbx' '--enable-dio'
'--enable-mcal' '--with-apxs2=/usr/sbin/apxs'
Server API Apache 2.0 Filter
Virtual Directory Support disabled
Configuration File (php.ini) Path /etc/php.ini
Scan this dir for additional .ini files /etc/php.d
additional .ini files parsed /etc/php.d/imap.ini,
/etc/php.d/ldap.ini,
/etc/php.d/mysql.ini,
/etc/php.d/odbc.ini
Debug Build no
Thread Safety disabled
This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.2.0, Copyright (c) 1998-2002 Zend Technologies
----------------------------------------------------------------------------
----
PHP 4 Credits
----------------------------------------------------------------------------
----
Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference
On On
allow_url_fopen
1 1
always_populate_raw_post_data
0 0
arg_separator.input
& &
arg_separator.output
& &
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
no value no value
error_log
no value no value
error_prepend_string
no value no value
error_reporting
2039 2039
expose_php
On On
extension_dir
/usr/lib/php4 /usr/lib/php4
file_uploads
1 1
gpc_order
GPC GPC
highlight.bg
#FFFFFF #FFFFFF
highlight.comment
#FF9900 #FF9900
highlight.default
#0000CC #0000CC
highlight.html
#000000 #000000
highlight.keyword
#006600 #006600
highlight.string
#CC0000 #CC0000
html_errors
On On
ignore_user_abort
Off Off
implicit_flush
Off Off
include_path
.:/usr/share/pear .:/usr/share/pear
log_errors
Off Off
magic_quotes_gpc
On On
magic_quotes_runtime
Off Off
magic_quotes_sybase
Off Off
max_execution_time
30 30
memory_limit
8M 8M
open_basedir
no value no value
output_buffering
no value no value
output_handler
no value no value
post_max_size
8M 8M
precision
14 14
register_argc_argv
On On
register_globals
Off Off
safe_mode
Off Off
safe_mode_exec_dir
no value no value
safe_mode_gid
Off Off
safe_mode_include_dir
no value no value
sendmail_from
[EMAIL PROTECTED] [EMAIL PROTECTED]
sendmail_path
/usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i
short_open_tag
On On
SMTP
localhost localhost
sql.safe_mode
Off Off
track_errors
Off Off
unserialize_callback_func
no value no value
upload_max_filesize
2M 2M
upload_tmp_dir
no value no value
user_dir
no value no value
variables_order
EGPCS EGPCS
xmlrpc_error_number
0 0
xmlrpc_errors
Off Off
y2k_compliance
Off Off
yp
YP Support enabled
xml
XML Support active
XML Namespace Support active
EXPAT Version expat_1.95.5
wddx
WDDX Support enabled
WDDX Session Serializer enabled
standard
Regex Library Bundled library enabled
Dynamic Library Support enabled
Path to sendmail /usr/sbin/sendmail -t -i
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
url_rewriter.tags
a=href,area=href,frame=src,input=src,form=fakeentry
a=href,area=href,frame=src,input=src,form=fakeentry
sockets
Sockets Support enabled
shmop
shmop support enabled
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
/tmp /tmp
session.serialize_handler
php php
session.use_cookies
On On
session.use_trans_sid
1 1
pspell
PSpell Support enabled
posix
Revision $Revision: 1.42.2.2 $
pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 3.4 22-Aug-2000
openssl
OpenSSL support enabled
OpenSSL Version OpenSSL 0.9.7a Feb 19 2003
iconv
iconv support enabled
Directive Local Value Master Value
iconv.input_encoding
ISO-8859-1 ISO-8859-1
iconv.internal_encoding
ISO-8859-1 ISO-8859-1
iconv.output_encoding
ISO-8859-1 ISO-8859-1
gmp
gmp support enabled
gettext
GetText Support enabled
gd
GD Support enabled
GD Version 1.6.2 or higher
FreeType Support enabled
FreeType Linkage with freetype
JPG Support enabled
PNG Support enabled
WBMP Support enabled
ftp
FTP support enabled
exif
EXIF Support enabled
EXIF Version 1.2
Supported EXIF Version 02100
Supported filetypes JPEG,TIFF
domxml
DOM/XML enabled
libxml Version 2.5.4
HTML Support enabled
XPath Support enabled
XPointer Support enabled
dio
dio support enabled
dbx
dbx support enabled
dbx version 1.0.0
supported databases MySQL
ODBC
PostgreSQL
Microsoft SQL Server
FrontBase
Oracle 8 (not really)
Sybase-CT
dba
DBA support enabled
Supported handlers gdbm db3
curl
CURL support enabled
CURL Information libcurl 7.9.8 (OpenSSL 0.9.7a) (ipv6 enabled)
ctype
ctype functions enabled (experimental)
calendar
Calendar support enabled
bz2
BZip2 Support Enabled
BZip2 Version 1.0.2, 30-Dec-2001
bcmath
BCMath support enabled
zlib
ZLib Support enabled
'zlib:' fopen wrapper enabled
Compiled Version 1.1.4
Linked Version 1.1.4
Directive Local Value Master Value
zlib.output_compression
Off Off
imap
IMAP Support enabled
IMAP c-Client Version 2001
SSL Support enabled
Kerberos Support enabled
ldap
LDAP Support enabled
RCS Version $Id: ldap.c,v 1.116.2.1 2002/04/23 18:59:57 derick Exp $
Total Links 0/unlimited
API Version 2004
Vendor Name OpenLDAP
Vendor Version 20026
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 3.23.54
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient
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 unixODBC
ODBC_INCLUDE -I/usr/local/include
ODBC_LFLAGS -L/usr/local/lib
ODBC_LIBS -lodbc
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
no value no value
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
Apache 2.0
Additional Modules
sysvshm
sysvsem
Environment
Variable Value
CONSOLE /dev/console
TERM linux
INIT_VERSION sysvinit-2.84
PATH /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
RUNLEVEL 5
runlevel 5
PWD /
LANG en_US.UTF-8
PREVLEVEL N
previous N
HOME /
SHLVL 2
_ /sbin/initlog
ODBCSEARCH ODBC_BOTH_DSN
PHP Variables
Variable Value
_SERVER["UNIQUE_ID"] [EMAIL PROTECTED]
_SERVER["HTTP_ACCEPT"] */*
_SERVER["HTTP_ACCEPT_LANGUAGE"] en,ar-sy;q=0.5
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 6.0; Windows
NT 5.1)
_SERVER["HTTP_HOST"] 192.168.0.101
_SERVER["HTTP_CONNECTION"] Keep-Alive
_SERVER["PATH"] /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
_SERVER["SERVER_SIGNATURE"] <address>Apache/2.0.40 Server at
192.168.0.101 Port 80</address>
_SERVER["SERVER_SOFTWARE"] Apache/2.0.40 (Red Hat Linux)
_SERVER["SERVER_NAME"] 192.168.0.101
_SERVER["SERVER_ADDR"] 192.168.0.101
_SERVER["SERVER_PORT"] 80
_SERVER["REMOTE_ADDR"] 192.168.0.152
_SERVER["DOCUMENT_ROOT"] /var/www/html
_SERVER["SERVER_ADMIN"] [EMAIL PROTECTED]
_SERVER["SCRIPT_FILENAME"] /var/www/html/test.php
_SERVER["REMOTE_PORT"] 1237
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["QUERY_STRING"]
_SERVER["REQUEST_URI"] /test.php
_SERVER["SCRIPT_NAME"] /test.php
_SERVER["PHP_SELF"] /test.php
_SERVER["argv"] Array
(
)
_SERVER["argc"] 0
_ENV["CONSOLE"] /dev/console
_ENV["TERM"] linux
_ENV["INIT_VERSION"] sysvinit-2.84
_ENV["PATH"] /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
_ENV["RUNLEVEL"] 5
_ENV["runlevel"] 5
_ENV["PWD"] /
_ENV["LANG"] en_US.UTF-8
_ENV["PREVLEVEL"] N
_ENV["previous"] N
_ENV["HOME"] /
_ENV["SHLVL"] 2
_ENV["_"] /sbin/initlog
_ENV["ODBCSEARCH"] ODBC_BOTH_DSN
PHP License
/////
Warning: SQL error: [unixODBC][Driver Manager]Data source name not found,
and no default driver specified, SQL state IM002 in SQLConnect in
/var/www/html/louai.php on line 11
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
