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