We help IT Professionals succeed at work.
Get Started

Connecting (reading and writing) to the simply accounting 2010 database from visual studio 2010

1,726 Views
Last Modified: 2013-11-12
Hi,

I'm currently developing a program for my company and I need to be able to write directly to the clients table in my simply accounting database, I'm not sure who could help me in achieving this but I need to speak to someone who can guide me through the process.

I'm using visual studio 2010 to connect to the database. The database is a ".SAI" file.
I've tried adding a new datasource using Microsoft ODBC Data Source (ODBC) wizard and selected my database name from the drop-down list. The problem I'm having is I cannot add or update records in the database using this method, I can only read records but not write to them. An error is always given anytime I try to update the records stating that there's an error in the query.

I've also tried using the MySQL connection wizard to add the database but it simply cannot find it no matter what I enter. I know that simply accounting uses MySQL for their database but I can't find any instruction on how to connect to it.

I need to be able to : ADD - DELETE - UPDATE the information in the "tcustomr" table of the simply accounting database. The only fields I specifically need in the table are:

lId
sName
sCntcName
sStreet1
sStreet2
sCity
sProvState
sPostalZip
sEmail

I've tried downloading the SDK but I can't find any tutorials on how exactly I can query and save records to the database. It is extremely difficult to understand the process through the SDK.

I would really appreciate it if someone can help me  figure out how to connect to my database, read data from the "tcustomr" table and update or delete records from the table using visual studio 2010 (vb.net)

Essentially I need the exact code to use in visual studio in order to be able to do this


Thank you for any help you can offer me,

FCapo
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 9 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE