Hi - I have a script trying to connect to a MS-SQL Server. It only connects to the first DATABASE out of the 3 available (below #1: SYSTEM DATABASES).
I need to connect to #3 Database(AMS) below. Manually I can get on to the server so I have access to all 3. Any ideas why I can't get to AMS Database? Thank you.
libname db odbc
noprompt = "server=happp02vw\reporting;DRIVER=SQL Server Native Client 11.0;Trusted_Connection=yes"
DATABASE = AMS schema = dbo;
Why is the icon different for AMS? Is it really a database?
Why is the icon different for AMS? Is it really a database?
Please check if you have access to the database.
What is your environment?
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.