Sage 2011 vb.net

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
Matb396Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Mike LazarusConnect With a Mentor Act! Evangelist - CRM ConsultantCommented:
I don't think so.... for that, you might try the free Sdata interface - http://sdata.sage.com/
0
 
TommySzalapskiCommented:
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
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
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
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
Matb396Author Commented:
No Sage Accounts 2011, will this still work?
0
 
Bruce DenneySage 50 Consultant and IntegratorCommented:
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
 
Matb396Author Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.