Connecting to MS Access 2000.
Posted: Fri Aug 08, 2003 2:08 pm
I seem to be lost in world I don't fully understand..
I have SUSE 8.2, PHP 4.x, Apache 3.X, MDBTools, UnixODBC.
It looks like I have everthing setup corectly but cannot seem to be able to get a simple connect.
and the ini:
The error is:
Hopefully someone has some experience with this. I cannot see to make it work at all. I don't know if I have to recomp PHP for ODBC support or where to turn.
Any suggestions will definatly help thx.
-Scott
I have SUSE 8.2, PHP 4.x, Apache 3.X, MDBTools, UnixODBC.
It looks like I have everthing setup corectly but cannot seem to be able to get a simple connect.
Code: Select all
putenv("ODBCINI=/etc/unixODBC/odbc.ini");
putenv("ODBCINSTINI=/etc/unixODBC/odbcinst.ini");
$cn=odbc_connect("time","root","",SQL_CUR_USE_ODBC);Code: Select all
їtime]
Descripton = Timetrack database
Driver = MDB
Database = /hdd1/sys/TimeEntry/TIME2000.mdb
Servername = localhost
Username = root
Password =Code: Select all
Warning: SQL error: їiODBC]їDriver Manager]Specified driver could not be loaded, SQL state IM003 in SQLConnect in /hdd1/sys/TimeEntry/oldTime.php on line 263
Warning: odbc_do(): supplied argument is not a valid ODBC-Link resource in /hdd1/sys/TimeEntry/oldTime.php on line 266Any suggestions will definatly help thx.
-Scott