Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

surfacing a stored process (SAS EG 7.1/base 9.4) in SAS VA 7.1

Reply
Super Contributor
Posts: 268

surfacing a stored process (SAS EG 7.1/base 9.4) in SAS VA 7.1

Anyone out there using stored processes to create tables/reports and surfacing them in SAS VA? I am having trouble surfacing it. I tried using both stored process server and sasapp server. I have a windows desktop and MS SQL server for database. I am not exactly sure how the SAS is setup (if it is on a different unix server or on a windows nt server).

ERROR: CLI error trying to establish connection: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'MYCLIENT-INC\svc_sassrv'. : [Microsoft][ODBC SQL Server Driver]Invalid  connection string attribute

ERROR: Error in the LIBNAME statement.

Ask a Question
Discussion stats
  • 0 replies
  • 213 views
  • 1 like
  • 1 in conversation