iEntry 10th Anniversary Forum Rules Search
WebProWorld
Register FAQ Calendar Mark Forums Read
Database Discussion Forum This is the place to find help resolving those nagging questions you have about implementing and using all kinds of databases. Need help writing a query? Need an opinion on Oracle? Post here!

Share Thread: & Tags

Share Thread:

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 09-12-2004, 08:25 AM
WebProWorld Member
 
Join Date: Jan 2004
Location: Bangladesh
Posts: 25
Informer45 RepRank 0
Default How to connect php and ms access databse using odbc

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.
__________________
The impossible doesnot Exist!
Reply With Quote
  #2 (permalink)  
Old 09-15-2004, 04:08 PM
WebProWorld Pro
 
Join Date: May 2004
Location: United Kingdom
Posts: 151
php~pro RepRank 0
Default

Eliminate hassles by downloading the latest release of ADODB.
Reply With Quote
  #3 (permalink)  
Old 09-26-2004, 07:57 AM
WebProWorld Member
 
Join Date: Jan 2004
Location: Bangladesh
Posts: 25
Informer45 RepRank 0
Default adodb

where do i get the latest version of ADODB
__________________
The impossible doesnot Exist!
Reply With Quote
Reply

  WebProWorld > Webmaster, IT and Security Discussion > Database Discussion Forum

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 04:16 AM.



Search Engine Optimization by vBSEO 3.3.0