Hi: I am new to PHP so please bear with me.
I copied and pasted an example of working with a MS Access database called:
Interfacing With MS Access 97+
by Siddharth Venkatesan
I have MS Access 2003.
In the original example, part of the code looked like this:
$cnx = odbc_connect( 'WebTute' , 'root', '' );
if (!$cnx) {
Error_handler( "Error in odbc_connect" , $cnx );
}
I changed it to:
$cnx = odbc_connect( 'GB' , 'root', '' );
if (!$cnx) {
Error_handler( "Error in odbc_connect" , $cnx );
}
I went into Data Source Administrator and "added" a new entry that now reads
"GB Drive do Microsoft Access(*.mdb)
When I run the php script, I am getting the following error:
Previous Entries in database
Fatal error: Call to undefined function: odbc_connect() in /homepages/8/d271334063/htdocs/McDevitt/DataAccess.php on line 28
I have no idea what is wrong. Could it be the USER name? This is part of the routine:
/*
Make the connection to the database. The syntax is
odbc_connect( 'SYSTEM_DSN' , 'USER', 'PASSWORD' );
$cnx will hold the
pconnect is used to establish a persistent database
connection to the Database until the procedure is completed.
If it is, how do I find the USER name to use?
Thanks,
Sam
