Hi,
Im setting up PHP for use with a ODBC-to-access 'database' on an NT-'system'.
Running linux debian 2.2, php4.0.1.p2 and apache 1.3.12.
Openlink's odbctest program runs with DSN=ademo;
even as user nobody. (l3kozzzz.tar- what version can it be?)
Compiled with iodbc. This is visible in the ODBC Support section in
phpinfo() output.
However, this section holds some empty values:
ODBC Support enabled
Active Persistent Links 0
Active Links 0
ODBC library iodbc
ODBC_INCLUDE
ODBC_LFLAGS
ODBC_LIBS
(3x a missing value)
Tried many ways to have these values set.
1. followed the php-iodbc guide at <!-- m --><a class="postlink" href="http://www.iodbc.org/odbc-phpHOWTO.html">http://www.iodbc.org/odbc-phpHOWTO.html</a><!-- m -->
It was written for php3, did things change?
"
<?putenv("LD_LIBRARY_PATH=/usr/local/openlink/odbcsdk/lib");
putenv("ODBCINSTINI=/usr/local/openlink/odbcinst.ini");
putenv("ODBCINI=/usr/local/openlink/odbc.ini");
$dsn="DSN=OracleLocal"; // this is a valid DSN set up in the above
odbc.ini file, tested in odbctest
$user="scott"; //default user for the demo Oracle database
$password="tiger"; //default password for demo Oracle database
$sql="SELECT * FROM EMP"; *
if ($conn_id=odbc_connect("$dsn","","")){ etc wtc
"
This guide used varible names different from those in phpinfo(), hmmmmm
2.
Set the values in php.ini, both in upper and lowercase. No result.
3. Tried to set the values in my script:
<?
putenv("LD_LIBRARY_PATH=/usr/local/lib:/usr/local/odbcsdk/include");
putenv("ODBCINSTINI=/usr/local/php/odbcinst.ini");
putenv("ODBCINI=/usr/local/php/odbc.ini");
putenv("ODBC_INCLUDE=/usr/local/php/");
putenv("ODBC_LIBS=/usr/local/lib/");
$MYDSN="DSN=ademo;HOST=194.229.153.199;ServerType=Odbc";
$MYDSN2="DSN=ademo";
$c=odbc_connect("$MYDSN2","","");
and all other ways I could imagine.
they only result in:
Warning: SQL error: [iODBC][Driver Manager]Data source name not found
and no default driver specified. Driver could not be
loaded, SQL state IM002 in SQLConnect in /www/htdocs/index.php on line 9
configured PHPO with:
'./configure' '--with-iodbc=/usr/local/' '--with-mysql'
'-enable-sysvsem' '--enable-sysvshm' '--enable-safe-mode'
'--enable-track-vars' '--enable-magic-quotes' '--enable-debugger'
'--enable-url-includes' '--enable-ftp' '--with-xpfdlib' '--enable-yp'
'--with-shared' '--with-apache=../apache_1.3.12'
'--with-config-path=/usr/local/etc/' '--with-exec-dir=/usr/local/php/'
'--with-pgsql=/usr/local/pgsql/include/' '--with-dom=/usr/lib/'
Has anyone gone this road before and taken this last obstacle?
Also, if anyone knows more about what *is* unified odbc, Im interested.
The name sounds OK but I found no
further resources or links. ...
Thanks to all who read this far!
Barry
Im setting up PHP for use with a ODBC-to-access 'database' on an NT-'system'.
Running linux debian 2.2, php4.0.1.p2 and apache 1.3.12.
Openlink's odbctest program runs with DSN=ademo;
even as user nobody. (l3kozzzz.tar- what version can it be?)
Compiled with iodbc. This is visible in the ODBC Support section in
phpinfo() output.
However, this section holds some empty values:
ODBC Support enabled
Active Persistent Links 0
Active Links 0
ODBC library iodbc
ODBC_INCLUDE
ODBC_LFLAGS
ODBC_LIBS
(3x a missing value)
Tried many ways to have these values set.
1. followed the php-iodbc guide at <!-- m --><a class="postlink" href="http://www.iodbc.org/odbc-phpHOWTO.html">http://www.iodbc.org/odbc-phpHOWTO.html</a><!-- m -->
It was written for php3, did things change?
"
<?putenv("LD_LIBRARY_PATH=/usr/local/openlink/odbcsdk/lib");
putenv("ODBCINSTINI=/usr/local/openlink/odbcinst.ini");
putenv("ODBCINI=/usr/local/openlink/odbc.ini");
$dsn="DSN=OracleLocal"; // this is a valid DSN set up in the above
odbc.ini file, tested in odbctest
$user="scott"; //default user for the demo Oracle database
$password="tiger"; //default password for demo Oracle database
$sql="SELECT * FROM EMP"; *
if ($conn_id=odbc_connect("$dsn","","")){ etc wtc
"
This guide used varible names different from those in phpinfo(), hmmmmm
2.
Set the values in php.ini, both in upper and lowercase. No result.
3. Tried to set the values in my script:
<?
putenv("LD_LIBRARY_PATH=/usr/local/lib:/usr/local/odbcsdk/include");
putenv("ODBCINSTINI=/usr/local/php/odbcinst.ini");
putenv("ODBCINI=/usr/local/php/odbc.ini");
putenv("ODBC_INCLUDE=/usr/local/php/");
putenv("ODBC_LIBS=/usr/local/lib/");
$MYDSN="DSN=ademo;HOST=194.229.153.199;ServerType=Odbc";
$MYDSN2="DSN=ademo";
$c=odbc_connect("$MYDSN2","","");
and all other ways I could imagine.
they only result in:
Warning: SQL error: [iODBC][Driver Manager]Data source name not found
and no default driver specified. Driver could not be
loaded, SQL state IM002 in SQLConnect in /www/htdocs/index.php on line 9
configured PHPO with:
'./configure' '--with-iodbc=/usr/local/' '--with-mysql'
'-enable-sysvsem' '--enable-sysvshm' '--enable-safe-mode'
'--enable-track-vars' '--enable-magic-quotes' '--enable-debugger'
'--enable-url-includes' '--enable-ftp' '--with-xpfdlib' '--enable-yp'
'--with-shared' '--with-apache=../apache_1.3.12'
'--with-config-path=/usr/local/etc/' '--with-exec-dir=/usr/local/php/'
'--with-pgsql=/usr/local/pgsql/include/' '--with-dom=/usr/lib/'
Has anyone gone this road before and taken this last obstacle?
Also, if anyone knows more about what *is* unified odbc, Im interested.
The name sounds OK but I found no
further resources or links. ...
Thanks to all who read this far!
Barry