Page 1 of 1

Connecting to MS Access 2000.

Posted: Fri Aug 08, 2003 2:08 pm
by Yosco
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.

Code: Select all

putenv("ODBCINI=/etc/unixODBC/odbc.ini");
putenv("ODBCINSTINI=/etc/unixODBC/odbcinst.ini");
$cn=odbc_connect("time","root","",SQL_CUR_USE_ODBC);
and the ini:

Code: Select all

їtime]
Descripton	= Timetrack database
Driver	= MDB
Database	= /hdd1/sys/TimeEntry/TIME2000.mdb
Servername = localhost
Username	= root
Password	=
The error is:

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 266
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

Posted: Fri Aug 08, 2003 3:00 pm
by fractalvibes
Take a look here:
http://www.able-consulting.com/ADO_Conn.htm

For some connectionstrings you should be able to use with MS Access

Posted: Fri Aug 08, 2003 3:54 pm
by Yosco
Thanks for the reply but I don't think the error is in the connection stings exactly I think it's in the Linux settings or PHP setting I have. Also note this is in SUSE Linux not a Windows machine.