Solved

Sage 2011 vb.net

Posted on 2011-03-20
6
706 Views
Last Modified: 2012-05-11
Hi All,

We have in house crm/billing program made in vb.net which feeds in to sage 2011 via a csv file.

What I'm trying to do is connect in to sage database to get the account balances.

Is there anyway to do this without buy the sage developer pack?

Cheer

Matt
0
Comment
Question by:Matb396
[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
6 Comments
 
LVL 37

Expert Comment

by:TommySzalapski
ID: 35177751
You shouldn't need to. I assume you are referring to Sage ACT!, yes? This article (from the Sage knowledgebase) explains how to connect directly to the database as an ODBC connection. (This you can use from Excel or Crystal Reports or SQL Server Management Studio).
http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=22989
You should be able to connect to it from Visual Studio that way too. VS supports ODBC connections.
0
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 35179023
If you mean sage ACT! 2011, the developers kit is free.
Also, the ODBC connection is only if you have the Premium edition, but the OLEDB connection is usually easier.

See: http://blog.glcomputing.com.au/2009/07/connecting-to-act-by-sage-data.html
0
 

Author Comment

by:Matb396
ID: 35179134
No Sage Accounts 2011, will this still work?
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 30

Accepted Solution

by:
Mike Lazarus earned 500 total points
ID: 35179279
I don't think so.... for that, you might try the free Sdata interface - http://sdata.sage.com/
0
 
LVL 10

Expert Comment

by:Bruce Denney
ID: 35182123
Yes there is

I sell a 3rd party integration product that can retrieve balances, (it can also post your invoices into sage in background/real time into the invoicing module)
0
 

Author Comment

by:Matb396
ID: 35182860
O right we are looking for something like this because our invoice go in via csv, but the more automated the better. Have you got an website? or if you could email me some info over, my email is matt@spatelecoms.co.uk

cheers
0

Featured Post

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

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

Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses

615 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