Hello,
I am testing a web page on my server (code and result of phpinfo attached).
In the browser window I get several errors like this:
Warning: SQL error: [unixODBC][Driver Manager]Data source name not found, and no
default driver specified, SQL state IM002 in SQLConnect in
/home/marco/public_html/cgi-bin/default.php on line 11
What should I check/change/fix? Which config files/commands...
Should I recompile PHP (see phpinfo outout) , or may it just be a config issue?
Any help is appreciated,
mweb
#######################################################################################################
excerpt of phpinfo output:
Configure Command './configure' 'i386-redhat-linux' '--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' '--prefix=/usr'
'--with-config-file-path=/etc' '--disable-debug'
'--enable-pic' '--disable-rpath'
'--enable-inline-optimization'
'--with-apxs=/usr/sbin/apxs' '--with-bz2'
'--with-curl' '--with-db3' '--with-dom'
'--with-exec-dir=/usr/bin' '--with-gd'
'--with-gdbm' '--with-gettext'
'--with-jpeg-dir=/usr' '--with-mm' '--with-openssl'
'--with-png' '--with-regex=system' '--with-ttf'
'--with-zlib' '--with-layout=GNU'
'--enable-debugger' '--enable-ftp'
'--enable-magic-quotes' '--enable-safe-mode'
'--enable-sockets' '--enable-sysvsem'
'--enable-sysvshm' '--enable-track-vars'
'--enable-yp' '--enable-wddx' '--without-mysql'
'--without-unixODBC' '--without-oracle'
'--without-oci8' '--with-pspell' '--with-xml'
#################################################################################################
Code excerpt (first odbc statement in php code)
$ERX=0;
// $conn is of type "ADODB.Connection"
// $rs is of type "ADODB.Recordset"
$conn=odbc_connect("","","");
(".")."\salv\ddeb97.mdb; Persist Security Info = False";
$conn=odbc_connect("","","");
// asp2php says 'huh'?: $ERX=$Err.$Number;
if ($ERX!=0)
{
header("Location: "."aggiornamento.htm");
exit;
}
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
