Michael Davis
  • Male
  • Columbia City, IN
  • United States
Share

Michael Davis's Friends

  • Gina Castignani
  • Helen Massey

Michael Davis's Groups

Michael Davis's Discussions

Data Source name not found and no default driver specified. SQLState=IM002
2 Replies

I am getting the following error message ever since our re-install of the Sage 100 SQL 2016 software when I run any SIR Reports or Connectors on several machines.Data Source name not found and no…Continue

Tags: not, found, source, data, -IM002

Started this discussion. Last reply by Michael Davis Jul 8, 2017.

SIR SAGE Connectors
3 Replies

I am able to create two connectors to pull all data directly from PO_PurchaseOrderDetail and PO_PurchaseOrderHeader. I was able to use the Table as the Source Container Type. So I know that all the…Continue

Started this discussion. Last reply by Chris Millar Feb 3, 2014.

Unable to get Add Property of the Workbooks Class
15 Replies

I am getting an error message "Unable to get the Add Property of the Workbooks class" when running reports now. The last thing I had changed in Excel was page setting on the some tabs. I successfully…Continue

Tags: 100, SAGE

Started this discussion. Last reply by Prabha VIRAH SAMMY 7 hours ago.

Multiple AR Consolidations
2 Replies

Goal: To create one spreadsheet with all my customers’ balance and credit limits from multiple MAS company codes.I created a new data container under the provided SAGE MAS Consolidated Connection.I…Continue

Started this discussion. Last reply by Blake May 20, 2015.

 

Michael Davis's Page

Latest Activity

Prabha VIRAH SAMMY replied to Michael Davis's discussion Unable to get Add Property of the Workbooks Class
"That's awesome Shane! My client does not have that update on his machine. Tried to uninstall a couple of other updates related to VB Basic since that is the first error that comes up before the "property" error but still no-go. Even…"
7 hours ago
Shane replied to Michael Davis's discussion Unable to get Add Property of the Workbooks Class
"I finally came right. We uninstalled windows update KB4090913. Since then the problematic reports started working. Hope this helps someone. "
yesterday
Tim Hambsch replied to Michael Davis's discussion Unable to get Add Property of the Workbooks Class
Friday
Myrna Burga replied to Michael Davis's discussion Unable to get Add Property of the Workbooks Class
"Mine is Sage 50 2018.  I've had this problem since November 2017."
Apr 17
David Bryant replied to Michael Davis's discussion Unable to get Add Property of the Workbooks Class
"What version of sage is this?"
Apr 16
Myrna Burga replied to Michael Davis's discussion Unable to get Add Property of the Workbooks Class
"I haven't had any luck either.  "
Apr 12
Prabha VIRAH SAMMY replied to Michael Davis's discussion Unable to get Add Property of the Workbooks Class
"It does not look like anybody from Alchemex is looking into this issue. :( I still have not provided a fix to my client and I posted into the forum last year."
Apr 12
Shane replied to Michael Davis's discussion Unable to get Add Property of the Workbooks Class
"Has anyone found a solution to this? I am having the same issue. It seems to be located only to the templates that have macros in them. Other reports work fine.  I have tried the "Fix templates tool" and reinstalled Excel+Sage…"
Apr 12
Tim Hambsch replied to Michael Davis's discussion Unable to get Add Property of the Workbooks Class
"Having a similar problem when running a report on a client workstation (that runs fine on my office workstation): Hangs at the “Creating Excel Workbook” stage: Each time is gives the Visual Basic Application error - “Errors…"
Jan 4
Prabha VIRAH SAMMY replied to Michael Davis's discussion Unable to get Add Property of the Workbooks Class
"Still no resolution found."
Jan 4
Myrna Burga replied to Michael Davis's discussion Unable to get Add Property of the Workbooks Class
"I am having this same error. the fix file did not work.  How did you solve your issue?"
Jan 4
Prabha VIRAH SAMMY replied to Michael Davis's discussion Unable to get Add Property of the Workbooks Class
"So I spoke too soon yesterday. It seems that the fix fixes the issue and the report runs the first time. If you run it the second time, it gives you same error."
Dec 9, 2017
Prabha VIRAH SAMMY replied to Michael Davis's discussion Unable to get Add Property of the Workbooks Class
"Helped me!"
Dec 7, 2017
Michael Davis replied to Michael Davis's discussion Data Source name not found and no default driver specified. SQLState=IM002
"After several calls with Sage and Alchemex, we tracked the issue down to corrupted SQL ODBC drivers. Once I fixed the SQL ODBC drivers, everything started working again. Michael"
Jul 8, 2017
Keeveshin Naidoo replied to Michael Davis's discussion Data Source name not found and no default driver specified. SQLState=IM002
"Hi Michael,  You mention that a SysWOW64 folder exists however the 32bit ODBC Driver is being used. Do you perhaps have a 64bit version of this driver? It seems like you've gone to quiet a degree of troubleshooting and I'd suggest…"
Jun 15, 2017
Michael Davis posted a discussion

Data Source name not found and no default driver specified. SQLState=IM002

I am getting the following error message ever since our re-install of the Sage 100 SQL 2016 software when I run any SIR Reports or Connectors on several machines.Data Source name not found and no default driver specified. SQLState=IM002We verified that SQL Server was running by going into SQL Configuration Manager.We also went to C drive - Windows - SysWOW64 - odbcad32Open - System DSN - I see two Native Clients (version 11) and Version 10.The massql.settings does contain the following…See More
Jun 15, 2017

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage MAS Intelligence, MyMonthlyReports.com

Comment Wall (1 comment)

You need to be a member of The Sage Intelligence Community to add comments!

Join The Sage Intelligence Community

At 7:31pm on August 9, 2011, Ruth Gray said…

Hello Michael and welcome to the BI Community. For access to videos, user guides, data dictionaries and much more. Join the Sage ERP MAS Intelligence Group. Select Join Group now on the group page http://community.alchemex.com/group/sagemasintelligence

 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service