OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
75
76 libname seacoastlib odbc dsn="seacoast" user="myuser" pass="mypassword";
ERROR: seacoastlib is not a valid SAS name.
ERROR: Error in the LIBNAME statement.
77
78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
91
Running the statement below to connect to a SQL Server database through DSN and I get error "ERROR: seacoastlib is not a valid SAS name:
libname seacoastlib odbc dsn="seacoast" user="myuser" pass="mypassword";
I have another statement, almost the same, to a different DSN, all in the same ODBC.INI file; the only difference is that the other statement includes a schema.
libname etllib odbc dsn="etl" user="myuser" pass="mypassword" schema="myschema";
PS: this statement that executes resides in a file created a long time ago. Maybe some variable created that reside in the system somewhere. The one that fails was created today.
I have even tried
caslib seacoastlib datasource="seacoast" user="myuser" pass="mypassword"
What am I missing?