From: Toia A. <to...@ke...> - 2003-04-04 13:23:36
|
Hello Sirs =20 ENVIRONMENT: Linux Red Hat 8.0 =20 TARGHET:=20 Retrieve data from a .mdb file mounted on linux file system from PHP-HTML=20 =20 =20 I=92ve successfully installed mdb tools: ./configure =96-with-unixodbc make make install =20 I tried to set up a DSN using ODBCConfig but it seems that the setup driver file is missing. So I=92ve manually insert DSN: =20 *** ODBC.INI: [MSAccess] Description =3D Microsoft Access Driver =3D MDBToolsODBC Database =3D /var/www/mdb/test.mdb Servername =3D localhost UserName =3D Password =3D=20 Port =3D 5432 =20 *** ODBCINST.INI: [MDBToolsODBC] Description =3D MDB Tools ODBC drivers Driver =3D /usr/local/lib/libmdbodbc.so.0 Setup =3D FileUsage =3D 1 CPTimeout =3D=20 CPReuse =3D=20 =20 *** myappl.PHP: <?php /* connect to microsoft access on dots machine */ $myDB =3D odbc_connect("MSAccess","",""); $query =3D "select mfg from tblModems"; $result =3D odbc_exec($myDB, $query); $report =3D odbc_fetch_row($result); echo odbc_result($result, 1); odbc_close($myDB); =20 but when I try to use my DSN inside the php-html file MS Explorer tell me: Warning: SQL error: [unixODBC]Could not find Database parameter, SQL state 08001 in SQLConnect in /usr/keb/apache/htdocs-portal/keb-php/customer.php on line 72 =20 Thanks in advance. =20 KEB ITALIA S.R.L. Toia Andrea Centro Elaborazione Dati Sistema Qualit=E0 =20 |