How can I offer clients ODBC access to an online database - maybe webservices?
Posted on 2011-10-07
I currently have an inventory control system with about 70 companies using it. Several have requested ODBC access to the data. Since the products table, for example, has the products for all 70 companies, then I can't exactly just give them a connection string!
To handle things like QuickBooks Integration, I have written web services and a VB application to run the interface, but that's really just a set of functions.
Is there a way I can write a web service which they can connect to using something like MS Word for a mail merge?