search

USGS-R / WQ-Review

Toolbox for discrete water-quality data review and exploration.
11 stars 4 forks source link

Multiple User Data Sources #178

Closed ehermosillo closed 5 years ago

ehermosillo commented 5 years ago

Hello. I am from the AZWSC and I am reviewing data for the COWSC. Can I retrieve CO data by adding the "nwisco" TNS Service name and Data Source Name under the Oracle ODBC Driver Configuration? Can I have multiple NWIS servers under the ODBC Data Sources? I've added the nwisco TNS Service name to the odbc data source, but I still can't retrieve any data on WQReview 2.0.

Thank you for your help on this!

cpenn-usgs commented 5 years ago

You can add multiple NWIS servers under the User DSNs in the ODBC administrator (ex. one for nwisaz and one for nwisco) but you may not be able to access them unless your username is added to the read/write access list for each individual NWIS database. I just talked to one of the LDMs for nwisco and they're working on adding you. After you're given access add nwisco and test the connection in the OBDC administrator before starting WQReview.

ehermosillo commented 5 years ago

Thank you, Colin!

Edyth Hermosillo U.S. Geological Survey 520 N. Park Ave, Suite 221 Tucson, AZ 85719 Office: (520) 670-3334 Cell: (928) 246-1509

<(((º> ~ ><(((º> ~ ><(((º>

On Wed, Apr 10, 2019 at 7:48 AM Colin Penn notifications@github.com wrote:

You can add multiple NWIS servers under the User DSNs in the ODBC administrator (ex. one for nwisaz and one for nwisco) but you may not be able to access them unless your username is added to the read/write access list for each individual NWIS database. I just talked to one of the LDMs for nwisco and they're working on adding you. After you're given access add nwisco and test the connection in the OBDC administrator before starting WQReview.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/USGS-R/WQ-Review/issues/178#issuecomment-481722252, or mute the thread https://github.com/notifications/unsubscribe-auth/AMoWwhBkpq33QPZXirpgekZnFs5j2p1Bks5vffmVgaJpZM4clsLP .