Solved

Visual Basic - Sage Software’s provideX

Posted on 2006-07-15
3
454 Views
Last Modified: 2013-12-04
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
Comment
Question by:eenderle
3 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 17114654
can you post the code, please?
do the tables have primary key fields?
0
 
LVL 31

Accepted Solution

by:
moorhouselondon earned 500 total points
ID: 17115297
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
 
LVL 3

Expert Comment

by:Robin888
ID: 17117968
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A short article about problems I had with the new location API and permissions in Marshmallow
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question