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
1 Reply

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 Keeveshin Naidoo Jun 15.

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
2 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 Shwu Hua Gan Aug 28, 2014.

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

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
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
Michael Davis joined SIRWA North America's group
Thumbnail

SIRWA North America

The organization known as S.I.R.W.A., (Sage Intelligence Report Writers Association) has two separate missions. First, SIRWA provides an organized group where like-minded, multi-talented, and qualified report writers can collaborate with and learn from each other.  All SIRWA members are “qualified” based upon criteria specifically designed to admit only the highest quality report writers, developed by the association itself. The main mission of SIRWA is to provide a professional resource of…See More
Nov 12, 2015
Blake replied to Michael Davis's discussion Multiple AR Consolidations
"Stephen- This is very helpful. I'm a little weak on SQL join syntax, though. I'm trying to add the AR_OpenInvoice table as well, but cannot figure out how to do it. Any suggestions?"
May 20, 2015
Shwu Hua Gan replied to Michael Davis's discussion Unable to get Add Property of the Workbooks Class
Aug 28, 2014
Tim Hambsch replied to Michael Davis's discussion Unable to get Add Property of the Workbooks Class
"Hi Michael -- did you ever find a resolution to this?  I have a report I created and tested on a backup of my customer's data and it ran fine and then after installing on their system they are getting this error."
Aug 27, 2014
Michael Davis joined Ruth Gray's group
Jun 4, 2014
Chris Millar replied to Michael Davis's discussion SIR SAGE Connectors
"Hi Doug From my understanding the filter you entered is only applied when the report is run (because it is entered into the Report Manager) which is why when you check/test the container you would still get the error. Regards Chris Millar Alchemex…"
Feb 3, 2014
Michael Davis replied to Michael Davis's discussion SIR SAGE Connectors
"Doug,  I found the issue on my data set. One of the date fields only had 3 digits and not 4. I was able to use the single tables connectors to look at each date field in the two tables. Once I found and corrected the date, the join statement…"
Jan 31, 2014
Doug Walker replied to Michael Davis's discussion SIR SAGE Connectors
"Hi Michael - I ran across the same problem when I link the PO Open Order files together. The error looks like it is caused by the "Required Date" field in the PO_PurchaseOrderDetail. I tested the Container on 4 different Sage-100…"
Jan 31, 2014
Michael Davis posted a discussion

SIR SAGE Connectors

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 data is readable and can be pull in.I would like to create a new container to pull the two tables together using the Join or Graphical Join Types, but I am getting the following error message. - "An overflow occurred while converting to datetime".The following is my join("PO_PurchaseOrderHeader"…See More
Jan 31, 2014
Michael Davis joined Sage Alchemex's group
Jul 10, 2013
Michael Davis posted a discussion

Unable to get Add Property of the Workbooks Class

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 created and link the sheet but now I can not run the report. It was running prior to these formatting changes. The cursor was not on a tab nor do I have any other versions of Excel were open. (Excel 2010). I can unlink the template but I feel that I have to start over. Does anyone haver any…See More
Jan 30, 2013
Michael Davis and Helen Massey are now friends
Sep 10, 2012
Stephen Coull replied to Michael Davis's discussion Multiple AR Consolidations
"Hi Michael,   The standard reports that ship with Sage MAS Intelligence cater for bringing the company code through in the query, so you can determine what record belongs to which company. I have attached a report that includes the relevant…"
Oct 22, 2011
Michael Davis posted a discussion

Multiple AR Consolidations

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 had added the table  AR_Customer and added the following fields: AR_DivisionNo, CreditHold, CreditLimit, Current Balance, CustomerName, CustomerNo, OpenOrderAmt, TelephoneNumber, and even a calculated field “Credit Available”(Credit Limit-Current Balance)In the Excel Template, I was able to create a…See More
Oct 19, 2011

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

© 2017   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service