0

I am having this problem. I want to use the IDEAR tool on my SQL Server Database. I run the IDEAR code Github provided on RStudio and select the YAML file I created in order to connect to my database. After selecting the file I get the following error:

Error: first argument is not an open RODBC channel

When I try to run a YAML file the tool provided as example, I get no error. Does anyone know what I'm doing wrong? I will post my YAML code here:

DataSource:
    SQLServer
Server:
    ORD02984\SQL2016
Database:
    Computed
Username:
    Steve
Password:
    *********
Query:
    select * from dbo.AirOnTime

Note: I put stars as password just to show it here

IDEAR tool: https://github.com/Azure/Azure-TDSP-Utilities/blob/master/DataScienceUtilities/DataReport-Utils/R/team-data-science-process-idear-instructions.md

alexander.polomodov
  • 5,396
  • 14
  • 39
  • 46
Steve Claes
  • 1
  • 2
  • I think we need to see your code in order to be helpful here. – Tim Biegeleisen Dec 01 '17 at 11:25
  • Sure, this is the code provided on Github: https://github.com/Azure/Azure-TDSP-Utilities/blob/master/DataScienceUtilities/DataReport-Utils/R/Run-IDEAR.R – Steve Claes Dec 01 '17 at 11:53
  • This looks more like a DB connection error than a YAML error. I don't know any of the involved technologies apart from YAML, but you may want to ensure that `ORD02984\SQL2016` is a correct value for the server. – flyx Dec 01 '17 at 13:33
  • I checked all my parameters and they are all correct. ORD02984\SQL2016 is the value for the server. I don't know what's going wrong here.. – Steve Claes Dec 01 '17 at 14:04

0 Answers0