Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

hi anyone could plz help me regarding softwares of architecture of database for e-commerce in ms access


sohaib72

Recommended Posts

Posted

osC is not designed to work with any database other than MySQL. If it is critical that you be able to run from MS Access, you would have to 1) convert the tep_* database functions to use Access calls rather than mysql_* or mysqli_* calls, 2) round up any loose calls to mysql_* and convert them to tep_* calls, and 3) modify SQL queries to remove MySQL-specific features and reimplement them in Access. Item 2 should be done (has been done?) anyway, so MySQLi can be used (item 1), but there are probably lots of add-ons out there still hard coded with mysql_* calls.

 

Basically, it's not worth it. If you want to use Access simply because you're familiar with it, learn to use a real database like MySQL. Access is probably too lightweight to run a real website. If you already have lots of work being done on Access, and want to tie your shop to it, that's a problem. Can you synchronize a separate MySQL database for the shop with your Access? Or, convert from Access to MySQL? Either way is going to be quite a bit of custom work.

 

Eventually, osC might be modified to allow databases other than MySQL, which means building or modifying queries on-the-fly to make them not MySQL-specific. I doubt that Access will ever be supported, but Oracle, DB2, PostgreSQL, SQLite, and others might be.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...