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?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.