Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x

Tax / Financial Software

The tax and financial software topic covers both personal and organizational software, ranging from checkbook managers and tax calculation systems to sophisticated general ledger, accounts receivable and payable, payroll, inventory and planning packages. Two of the most common titles are Quickbooks and Microsoft Dynamics.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi guys

My program includes a simple query on Sage 50 via ODBC, something I've programmed hundreds of times before. The Sage data tables are on a network drive. On this particular client's PC (Windows 7, 64 bit), the query ran perfectly every time when run manually, but threw the following errors when scheduled:

ERROR [08001] Cannot find all files in data path
ERROR [01000] The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 23.1
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).

I checked all the DSNs, drivers and registry and everything seemed OK. I did a search and the only relevant post was one here by RogerMoquin:

Problem with ODBC connection when run from a scheduled task
      
His solution was to insert a two minute delay, though I think his issue was with login.  In my case the program runs long after login. Using his idea, however, I found one solution was to set the program to try to connect, then each time an error exception is raised, it waits two minutes. After 3 tries it consistently connects. (Please note that I changed to a DSN-less connection string, but it still uses the 3 tries).

' Original 
'Dim 

Open in new window

0
Tech or Treat!
LVL 10
Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Submit all the tax forms that affect your small business.
0
Know a carpenter and need an Ap or can I email him an excel he can save and edit on his phone ?

Thanks
0
Recently when I tried to reconcile, I get the message that there are no transactions to reconcile but there are many that are marked with a c which indicates that they have not been reconciled. I crossed a month boundary so there wouldn't seem to be a statement date issue. How can this be corrected?
0
I have Peachtree 2012 and need help. I am looking for either answers or a link that will show me how to do the following:

Why some of my files will not let me enter invoices for them?

Thanks for any help!
0
I have Peachtree 2012 and need help. I am looking for either an answers or a link that will show me answers on the following:

How to keep inserted text boxes on forms from moving when I want to print them?

Thanks for any help.
0
I have Peachtree 2012 and need help. I am looking for either an answers or a link that will show me how to set up forms.

Thanks for any help!
0
I am running Sage 50 v.21 on windows 10. Every time I print an invoice the application stops and closes with the message "sbd desktop has stopped working". Any help in resolving this would be welcome.
0
We are running an old version of MAS200, just added a new user to system, when going into ANY MENU, get a dialog box saying "You are not authorized for this menu option"
0
I am unable to make corrections in Sage Instant v.15 via File/Maintenance/Corrections.

The list of transactions are shown and I can search a trans number via the Find key but then the software freezes and I have to either Control Alt Delete or Esc to exit the screen.

There seems to be no data corruption and everything else is running fine.  When the software is loaded onto my desktop the correction wizard works.  

Your help would be appreciated.
0
Enroll in October's Free Course of the Month
LVL 10
Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

I wish to delete the entries under "Sage" from the C:windows\assembly but keep getting the "access denied" message.

How do I get round it?
0
Hello,

I am using Sage Line 50 on a 64 bit machine runnings Winfows 7. I want to export data from SAGE to Excel. I need data from what I be three reports / tables in SAGE:-

1) A list of all sales items by product - showing:-
                          i) the date of the sale
                          2) the items sold
                          3) the number sold
                          4) the price of the items
                          5) the total revenue

2) A list of all the operational costs by date

3) the trial balance

I have already set up the ODBC connection between SAGE and Excel. However I can't seem to create the data extract within excel. At this point, I only need to use the practice data in SAGE but will later on need to switch to the true data.

Also I would like to implement a button as a Macro to pull in all the data. Thanks

Regards
Kaps
0

Tax / Financial Software

The tax and financial software topic covers both personal and organizational software, ranging from checkbook managers and tax calculation systems to sophisticated general ledger, accounts receivable and payable, payroll, inventory and planning packages. Two of the most common titles are Quickbooks and Microsoft Dynamics.

Top Experts In
Tax / Financial Software