Connecting to Access with PHP

[adam007]

Hello
I have set up an Access Database of usernames and passwords. Then created a user authentication form which tries to validate the username/password from the database. Im using apache on my local computer and ultradev with php extensions. When i try to preview my login page, i get these errors:

Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in c:\apache\htdocs\e-life\adodb\drivers\adodb-odbc.inc.php on line 116

Warning: Cannot send session cookie - headers already sent by (output started at c:\apache\htdocs\e-life\adodb\drivers\adodb-odbc.inc.php:116) in c:\apache\htdocs\e-life\tmpg4wkteu09b.php on line 11

Warning: Cannot send session cache limiter - headers already sent (output started at c:\apache\htdocs\e-life\adodb\drivers\adodb-odbc.inc.php:116) in c:\apache\htdocs\e-life\tmpg4wkteu09b.php on line 11

Can anyone please help me fix this problem?

I will greatly appreciate your help

[adam007]

This is line 116 that is mentioned in the error logs:
$this->_connectionID = odbc_pconnect($argDSN,$argUsername,$argPassword,$this->curmode);

Please help

[jatar_k]

Welcome to WebmasterWorld adam007,

Well, the second and third errors don't matter, they are generated because of the first error outputting.

As far as the first one goes, I don't use access but this bit

Data source name not found and no default driver specified

would make me think that something is misconfigured or your call is wrong.

Have you read through these?
odbc_pconnect [php.net]
odbc_connect [php.net]

sometimes there are gems hiding in the user contributed notes.