Solved

Visual Basic - Sage Software’s provideX

Posted on 2006-07-15
3
452 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
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 …

911 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now