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: 
Rerickson123
‎06-13-2023
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: SAS Version Differences 6.1

by Calcite | Level 5 in New SAS User
‎06-13-2023 12:21 PM
‎06-13-2023 12:21 PM
Thanks - I should have mentioned, I manually entered in my User Name and Password, I get the bottom 2.   ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ERROR: Error in the LIBNAME statement.   Is it correct for me to say, that there is no difference between how versions 6.x and 8.x would behave for this script?      ... View more

SAS Version Differences 6.1

by Calcite | Level 5 in New SAS User
‎06-13-2023 11:56 AM
‎06-13-2023 11:56 AM
My coworker is using SAS Enterprise 6.1.  I am using 8.3.   I am unable to use this program code to connect to the database - my coworker is able to us it.    Is there something different between the 2 versions language here?     libname conf odbc dsn=mainframe user=&uname password=&passwd  schema=conformed read_lock_type=nolock;   Heres the error. WARNING: Apparent symbolic reference UNAME not resolved. WARNING: Apparent symbolic reference PASSWD not resolved. ERROR: CLI error trying to establish connection: Unable to retrieve error message. ERROR: Error in the LIBNAME statement. *****     As an alternative I am able to connect in SAS using this.   libname conf odbc complete="driver=SQL Server;                               database=mainframe;                               server=servername"                     schema=conformed; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-13-2023 10:28 PM
Quick links