cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
barrytrask
Calcite | Level 5 barrytrask
Calcite | Level 5
Go to Solution.

Library Connected to SQL Database via ODBC: SQL Database being upgraded: Necessary Steps to Refresh?

Posted 09-07-2016 11:24 AM (991 views)

A data library is connected to a MS SQL database via ODBC. The Database is undergoing a version upgrade. What steps need to be taken, if any, after the update? Does table data require metadata update? How is this best accomplished? New to this! Thank you.

0 Likes
1 ACCEPTED SOLUTION

Accepted Solutions
LinusH
Tourmaline | Level 20 LinusH
Tourmaline | Level 20

Re: Library Connected to SQL Database via ODBC: SQL Database being upgraded: Necessary Steps to Refr

Posted 09-07-2016 11:48 AM (1426 views)  |   In reply to barrytrask
If you are on Windows, usually nothing. Just make sure that your ODBC driver is up to date.
Of course, any changes in host/database/schema names must be managed manually.
Data never sleeps

View solution in original post

0 Likes
2 REPLIES 2
LinusH
Tourmaline | Level 20 LinusH
Tourmaline | Level 20

Re: Library Connected to SQL Database via ODBC: SQL Database being upgraded: Necessary Steps to Refr

Posted 09-07-2016 11:48 AM (1427 views)  |   In reply to barrytrask
If you are on Windows, usually nothing. Just make sure that your ODBC driver is up to date.
Of course, any changes in host/database/schema names must be managed manually.
Data never sleeps
0 Likes
barrytrask
Calcite | Level 5 barrytrask
Calcite | Level 5

Re: Library Connected to SQL Database via ODBC: SQL Database being upgraded: Necessary Steps to Refr

Posted 09-07-2016 12:55 PM (979 views)  |   In reply to LinusH
Thank you very much for the confirmation.
0 Likes

SAS INNOVATE 2024

Innovate_SAS_Blue.png

 

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Watch Tips for filtering data sources in SAS Visual Analytics on YouTube

Find more tutorials on the SAS Users YouTube channel.

SAS Visual Analytics on G2!
Users love SAS Visual Analytics on G2
Discussion stats
  • 2 replies
  • ‎09-07-2016 11:24 AM
  • 992 views
  • 0 likes
  • 2 in conversation