Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Connecting to another ODBC data source to import new data


Recommended Posts

We already have a very advanced database system that runs our internal workings here.


After finding oscommerce, I have decided that its speed is fantastic compared to the shop we have already.


I am trying to avoid duplicate data entry and need to pull the data from the ODBC source into MySQL on a regular basis to ensure the changes we make in our current system are replicated in the MySQL database and subsequently shown on the commerce site.


If there is anyone out there who is familiar with ACCWARE using Advantage Database Server, please let me know.


I already use the ODBC driver to connect Crystal Reports to our data, now I just need a real-time merge feature to keep adding records.


At the same time, I need to write the orders that come in through oscommerce back to the FoxPro based data running on the Advantage Database Server.



Link to comment
Share on other sites

  • 1 year later...

I'm looking for the same idea, with some minor differences. I have a FoxPro .DBF database of items I want to link to oscommerce. I don't need to link orders and such, I believe davemc is selling software that does this for... yes, $10,000. lol.



I just need a simple link between dbf and sql. Does anyone know how to do that?

Link to comment
Share on other sites


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

  • Create New...