?
Solved

Sage Export Data using ODBC

Posted on 2008-11-05
5
Medium Priority
?
938 Views
Last Modified: 2012-05-05
Hi,

I need to write an export program for a client to export from their SAGE Line 50 2008 package.    I have all of the DTA files and what I believe are the ODBC drivers S11DBC32.dll and S14DBC32.dll.  I do not have SAGE installed on my development machine.  All I need to be able to do is link to the DTA in a VB.net APP, loop round each record and export it to a CSV.  Can I do this with the files I have and if so how?

thanks
0
Comment
Question by:kinton
  • 3
4 Comments
 
LVL 10

Accepted Solution

by:
Bruce Denney earned 2000 total points
ID: 22913646
You don't need the S11DBC32.dll driver as that is for an older version.

There is an installer for the driver in the Sage installation directory, in the ODBC subdirectory, if you need it.  

Warnings: The drivers are very slow, if you are looking to do lots of lookups, then you would do welll to cache the tables first.  The drivers are READ only.

0
 
LVL 2

Author Comment

by:kinton
ID: 22938446
thanks, I am working on this Monday so will let you know the outcome
0
 
LVL 2

Author Comment

by:kinton
ID: 22974363
Hi,

That works fine, but I'm asked for a username and password when connecting through Access/Excel.  our customer typically has no idea what it is and the password they use to login to SAGE does not work?  Any ideas how I may find this?

I'll award the points anyway as you have answered my original question but if you can give any pointers on this it would be helpful!

thanks

Darren
0
 
LVL 2

Author Closing Comment

by:kinton
ID: 31513589
This was the solution, just need the password from sage!
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

850 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