Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Sage 2011 vb.net

Posted on 2011-03-20
6
Medium Priority
?
717 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
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 
LVL 30

Accepted Solution

by:
Mike Lazarus earned 2000 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
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…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

722 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