Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 478
  • Last Modified:

Visual Basic - Sage Software’s provideX

I wrote a program in visual basic 6 to update 2 fields of 1 record in a table that is used by MAS 200.  This database is Sage Software’s provideX database.  I can select from that table, but I can not update any data to it.  I am using the odbc driver that was provided to me by MAS 200 and it makes the table all read-only.  Does anyone know how to get around this or have an odbc driver for provideX that will give me write privileges?


Thanks
Tammy
0
eenderle
Asked:
eenderle
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
can you post the code, please?
do the tables have primary key fields?
0
 
moorhouselondonCommented:
It is my understanding that only Sage Developers have the means to Post data directly into the Accounts system.  So the answer is: not without becoming a Sage Developer, (which costs).  
0
 
Robin888Commented:
Hi eenderle,

Get the lastest odbc driver providerx v7.10. However, make sure ur current providerx driver is version 7.0. Any other version will not work.
http://www.pvx.com/downloads/providex/windows/home.html

Good luck.
Regards.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now