We will never share this with anyone. Well we had no end of issues with the DSN connection, as in we couldnt get it to work at all. We have no issues when our app is running on the same server as SAGE, issues arrise once we are on a different machine trying to do the same things…. As I followed my event log I could see that my code was executing and behaving as expected almost all of the way through, then out of the blue an unhandled error. Do not use spaces or blanks in the data source name. Hi Andrew, that is a great post and has given me some things to think about as I have just been talking to someone about uploading price list info from Sage Line to a website.

Uploader: Kazilmaran
Date Added: 25 April 2008
File Size: 17.65 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 34335
Price: Free* [*Free Regsitration Required]

When the application executes a SQL command then fetches a row, the physical data dage will remain locked until at least 20 rows have been fetched or EOF. I sage line 100 odbc trying to do something similar now yet I am getting a variety of errors!

A new Data Source must be created. Due to the advent of Win 8, connection to just query the database is a nightmare. I do not work as a consultant and I am a key decision maker for sage line 100 odbc companies I work for.

Sage Line database connection

If you have any advice on the connection string used to go direct to Sage I would be odgc appreciative! NET application we have…Hence using connection strings.

Thanks for the advice. Covered by US Patent. Sage Software Customer Support is not responsible for sage line 100 odbc with this procedure. I unfortunately had been given some slightly misleading information on the location safe these files though this may be more of a break down in communication than anything else.

It seems they offer a very basic subset of the SQL language to developers. This then caused a further error which meant my lovely windows service stopped working….

ODBC to export SAGE Line Legacy Data

Anyway, I have spent many hours adding event log debug code after event log debug code and added error messages only to find none of them were getting sage line 100 odbc This meant I would start to post information messages to the event log stating where I was in the code not great as this service will run forever and a day dealing with s of items a number of times during sage line 100 odbc day. Sorry, your blog cannot share posts by email. I found a little documentation here: You are right, integration with SAGE is a well kept secret.

This can be used with Report style 10 but should not be used for interactive access. Are you are experiencing a similar issue?

Tutorial: Import data from Sage Line 100 into Excel. By David Carter

One of our applications has moved machines, thats all, and no longer on the same machine as the SAGE instance…Basically, nothing works yet again. Anything added to 3, however, will obviously fail.

It might be easier to figure out some third party sage line 100 odbc that could be used here in the middle. I have been doing some more work for a client that uses Sage Line Link is dead ssage any updates?

Creating Sage Line 100 ODBC Read/Write Application

Glad you found the post helpfull…. Do not use spaces or blanks in the password name.

Sage Line clarifications There are some aspects of this article that will, I suspect, confuse the typical Sage Line user:. I think you can set up an ODBC connection though and connect through that…. This sage line 100 odbc the probably the easiest way to get data out of Line This caused no end of issues with just trying to connect to the database. This worked for us: Sage line 100 odbc documentation explaining exactly what they do and do not offer seems to be nonexistent.

If so, do i have to install a driver for sage?

This is not necessarily the case – but solved my similar problem I also dont use I: By clicking you agree to the Terms of Use and Privacy Sage line 100 odbc. First of all, thanks a lot for this quite interesting article, especially with this lack of information regarding sage integration.

Lind worked for us:.