search

ACCORDSD2VDEV / CHORDS-QA

0 stars 0 forks source link

Error with DB connection at MHCD #61

Closed CartWill closed 3 years ago

CartWill commented 3 years ago

From CHORDS-QA created by CJMcKinney: UCCC/CHORDS-QA#14

I am getting the following error running the package for P2 files:

Quitting from lines 19-35 (P2.Rmd) Error: nanodbc/nanodbc.cpp:950: 42000: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "CHORDSlive.dbo" requested by the login. The login failed.

I am realizing two possible issues, 1) the CHORDSlive.dbo is both the DB and the schema, maybe only the schema is needed. 2) Is there anything else I would need to provide to login to the account.

Thanks, --CJ

CartWill commented 3 years ago

Is this a DB Server Name or a DB Name. Also, is the spelling and capitalization exactly correct? I can add it as an option once you've verified this info.

CartWill commented 3 years ago

Can CHORDSlive then be added to the selections as a DB choice?

CartWill commented 3 years ago

This DB name has been added to the package. Redownload and install the package and you will be able to select this name from the dropdown list.

CartWill commented 3 years ago

The Server is BI01 and the DB is CHORDSlive

Thanks

From: vtmacox notifications@github.com Sent: Wednesday, April 11, 2018 8:14:09 AM To: UCCC/CHORDS-QA Cc: McKinney, Christopher; State change Subject: Re: [UCCC/CHORDS-QA] Error with DB connection at MHCD (#14)

Is this a DB Server Name or a DB Name. Also, is the spelling and capitalization exactly correct? I can add it as an option once you've verified this info.

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHubhttps://github.com/UCCC/CHORDS-QA/issues/14#issuecomment-380467263, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AkdlojlG7q-bPKfe_p7pNFR_wDA_z9E3ks5tng-xgaJpZM4TNeNg.

Webhttps://mhcd.org | Facebookhttps://www.facebook.com/RecoveringDenver/ | Twitterhttps://twitter.com/MHCD_News | LinkedInhttps://www.linkedin.com/company-beta/42816/?pathWildcard=42816

[https://mhcd.org/wp-content/uploads/2018/01/Email-Signature-web-V1.jpg]

CONFIDENTIALITY NOTICE: If you are not the intended recipient of this electronic message, you are hereby notified that any disclosure, copying, distribution, or action taken in reliance on the contents of this document is strictly prohibited. If you received this information in error, please notify the sender immediately and arrange for the return or destruction of this document.

CartWill commented 3 years ago

I have owner level permission for the CHORDSlive DB, reviewing the logs, your program is picking up the user name correctly, but it is not liking the DB name 'CHORDSlive.dbo' . Does the schema need to be part of the name? I never login with the name in that format, only the 'CHORDSlive' DB name.

CartWill commented 3 years ago

This indicates that you do not have the credentials to access the VDW. The package uses the credentials of of the logged in user (so whomever is logged in to the current computer and running the program) to run the report. This is done passively, so no user name or passwords are prompted.

CartWill commented 3 years ago

The DB Server Name and DB Name have to match what you would use for a typical SQL query. Make sure the case is correct as this matters in R.