PDA

View Full Version : How to connect php and ms access databse using odbc



Informer45
09-12-2004, 07:25 AM
Guys ,
i got this problem.This my code
for connection:
class BankAcc
{

//var $Relative="/Personal/PHP_PROJ/Pics/JPG";
function Connect( )
{

$connection = odbc_connect("dsnPortal", " ", "");
if (!$connection)
{
exit("Connection Failed: " . $connection);
}
// turn off autocommit
odbc_autocommit($connection, FALSE);



// put everything on sale


//odbc_commit($connection);
$query2=" INSERT into Transaction_OB(mAmount,Transaction,date,cAccountNo )VALUES ('2','2','2/8/90','2') ";
if (!$query2)
{ exit("Error in SQL");
}
$resultq = odbc_commit($connection,$query2);
odbc_commit($connection);
odbc_close($connection);



}


the error message:
An online Banking System
Warning: odbc_connect(): SQL error: , SQL state 00000 in SQLConnect in c:\Inetpub\wwwroot\RMSP\BankMain.php on line 20
Connection Failed:
help me.

php~pro
09-15-2004, 03:08 PM
Eliminate hassles by downloading the latest release of ADODB.

Informer45
09-26-2004, 06:57 AM
where do i get the latest version of ADODB