I am developing an application in VB6 that uses its own DB. I need to link my application’s DB with clients’ DBS or even ERP systems. Therefore, I need to exchange data between my application’s DB and clients’ DBS or ERP systems?which will probably be different from client to client. How do I do this? Are there any components that would allow a ‘general’ integration of my application’s DB with clients’ DBS or ERP systems?
The best way to access databases from VB is through either an OLE DB provider (ADO) or through ODBC. If the database in your client’s system doesn’t have an ODBC driver available, you’ll have to do imports and exports to get data into a format that VB can actually read.