Solved

Visual Basic - Sage Software’s provideX

Posted on 2006-07-15
3
460 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 143

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article will show, step by step, how to integrate R code into a R Sweave document
A short article about problems I had with the new location API and permissions in Marshmallow

734 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