Solved

Sage 2011 vb.net

Posted on 2011-03-20
6
696 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
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
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Put window Form inside tab page 10 33
Receiving a string from a WebService Push 21 47
Call windows 10 virtual keyboard from windows forms app 2 34
Expression Evaluater 3 24
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
Article by: Nadia
Linear search (searching each index in an array one by one) works almost everywhere but it is not optimal in many cases. Let's assume, we have a book which has 42949672960 pages. We also have a table of contents. Now we want to read the content on p…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

776 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