I needed to get the Sage information out before my customer's company closed and they wanted the data. You can see that I am using v16 driver. Select a driver for the type of database you want to access > choose the required driver for your version, for example Sage Line 50 v20 > Connect. Hope this helps, I was pulling my hair out for hours haha!!! weblink
To reinstall the ODBC driver Note: To reinstall the ODBC driver you must log on to your computer as an administrator. Sage Accounts 2011 (v17) and below - Help > About > System Information > Directories > note the Program Directory > OK. You may get a better answer to your question by starting a new discussion. This is usually located in: C:\Windows\SysWOW64\odbcad32.exe Re-create the SystemDSN ODBC for Template Portal. https://my.sage.co.uk/public/help/askarticle.aspx?articleid=19136
Feel free to leave me a question and I will help you out if you have any problem. Now let the journey begins…. All rights reserved penguino more than just a flightless bird About Contact Me About Contact Me HomeComputing Windows TutorialsSage Line 50 ODBC driver – Manual installation Sage Line 50 ODBC driver Alan Wednesday, 30 March, 2011 Thanks for the note at the top of your article.
To be able to use your software with the ODBC driver, it must be ODBC compliant. User ID > enter your Sage 50 Accounts user name > Password > enter your Sage 50 Accounts password. I eventually found that because this was Windows Server 64bit the 32bit ODBC Control Panel items are held separately. Sage Install Stuck Configuring Odbc If you are simply using Sage for accounting, then you do not need to deal with ODBC at all.
We do not encourage or condone the use of this program if it is in violation of these laws. Sage Odbc Connection String Double-click the setup.exe file. Followed your instructions after copying the CD to my hard disk for extra safety, right click the setup, run as administrator, and bingo. First Name Last Name Email Join Now or Log In Oops, something's wrong below.
We use own and third party cookies to improve our services and your experience. check over here Iain Shaw Friday, 8 April, 2011 Beautiful. Sage 50 Odbc Driver 64 Bit Still got an error about an incompatible printer driver, but not worried - I only do data entry on this PC, no need to print. Sage 100 Odbc Driver 64 Bit Yes > Finish > restart your computer.
Graham Tuesday, 22 November, 2011 If it helps I had the problem with the 64-bit version of things and getting Business Objects to connect to the SAGE data and here's have a peek at these guys Doesn't make sense because if the internal SAGE reports can access it in I suppose a reasonable amount of time then what's going wrong with externally accessing it? Yes > Finish > restart your computer. through a standard ODBC Driver interfa Author's review Read, write, and update Sage Customers, Transactions, Invoices, Sales Receipts, etc. Sage 50 Odbc Tables
Close all software > restart your computer > press and hold the Windows key and press E > browse to the program directory > ODBC32. I hope it works out and let us know how you get on. Chris Friday, 13 July, 2012 Am i correct in assuming this method is for 64bit Windows with 32bit Excel? check over here This includes to personalise ads, to provide social media features and to analyse our traffic.
HappyMan Wednesday, 21 August, 2013 Thank you soooooo much…..this worked a treat with V12. Sage 2015 Odbc Driver External Data tab >ODBCDatabase >select Link to the data source by creating a linked table >OK. Close all software > restart your computer.
Select Blank database >Create. You might also like to check the Datapath setting which is pointing to the location of the accounts data files. Re-create the SystemDSN ODBC for Template Portal -- where do I do this? Pervasive Odbc Engine Interface We also share information about your use of our site with our social media, advertising and analytics partners.
Transfer your data from Sage Accounts to Microsoft Access for analysis. I simply went to the System DSN tab and then double clicked the SageLine50v18 entry and changed the data path to: \\Server\sage\ACCOUNTS\2008\COMPANY.002\ACCDATA which is where the SAGE data is stored. GPU RAM CPU ROM Submit » 88% of IT pros got this right. this content Run the 32-bit ODBC Data Source Administrator Tool.
HM. If you have the drivers on the CD I recommend you install it that way rather than using my method (which is a last resort if the CD is unavailable). Complete the Query Wizard to choose the required data for your query. Normally, you install Sage, or the Sage ODBC drivers setup program and the drivers are listed as driver options in the Add Data Source Name dialogue in ODBC Data Source Administrator.
To use the ODBC driver to link your Sage 50 Accounts data to Excel® 2010 Sage 50 Accounts >Help > About >Program Details area > note the data directory. Thanks and good luck! You may change your cookie preferences and obtain more information here. You should also find under the “Drivers” tab of the same driver, with the version number and driver file name listed.
There is a setup program there that you should be able to run it and install it, and it should work fine with Win7x64. We will need to put this into the new PC’s system32 directory later. 2) Understanding the ODBC in relation to the registry OK – don’t get scared about the registry. Select the table containing the data you want, for example, SALES_LEDGER >Next. i've followed exactly what you've put but i get an error from the dll.
Click the View tab then within the Advanced settings area, clear the Hide extensions for known file types check box, then click OK. You must be a geek to manage it! To check your program directory Help > About > Program Details section > note the Program Directory. Note: Vista and Win 7 users may get a warning and may require administrative access in order to change the registry. If you get "Error accessing the registry" when you double