Solved

How do I connect with Simply Accounting Pro 2010 database from C#?

Posted on 2010-08-24
2
806 Views
Last Modified: 2013-12-17
Hi ,
We need to connect with Simply Accounting Pro 2010 database (even if it is sample database) from .Net (C#).
We want to get table list and other stuff that is less important now, without ability to connect with db (first).

We are in a very critical time and fast solution will be very welcomed.

Best regards
0
Comment
Question by:appdec
  • 2
2 Comments
 
LVL 53

Expert Comment

by:Dhaest
ID: 33508730
What database is simply accouting pro 2010 using ? Is it mysql, sqlserver, ...
0
 
LVL 53

Accepted Solution

by:
Dhaest earned 500 total points
ID: 33508738
Probably you can find an sdk in the following folder: The SDK contains a sample with many examples. Look under c:\program files\Simply accounting 2010 SDK\sample

If it's a sage database, try this:
For those of you who are trying to create a link from a .NET application to Sage. Here's how I did it:

Dim con As New Odbc.OdbcConnection("Driver={Sage Line 50 v14};DIR=D:\SAGEDatabase\COMPANY.003\ACCDATA;UseDataPath=No;UID=manager;PWD=mypassword")

Dim cmd As Odbc.OdbcCommand = con.CreateCommand

cmd.CommandText = "SELECT ACCOUNT_REF FROM SALES_LEDGER WHERE ACCOUNT_REF LIKE 'SA%'"
       
Try
  con.Open()
  lbl.Text = cmd.ExecuteScalar
Catch ex As Exception
  lbl.Text = ex.Message
  Exit Sub
Finally
  con.Close()
End Try
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

758 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

18 Experts available now in Live!

Get 1:1 Help Now