LIBNAME pubtest ODBC DATAsrc=TEST_DB
SCHEMA=dbo ;
LIBNAME pubprod ODBC DATAsrc=PROD_DB
SCHEMA=dbo ;
I have two connections: test A and prod A. When I use test A I get a good connection, and I'm able to run a PROC SQL query with results. However, when I run prod A, I get a good connection, but I get a "Error: File PUBPROD.<data table>.Data does not exist." I've looked at the configuration for each in Management Console, and I cannot find a difference. I've also compared these against another test (B) and prod (B) connection (both of these work).
The only difference between the prod A and the other 3 connections (test A, test B, & prod B) is it is brand new (just created last week). The other 3 were created some time ago before I started, and the creator is no longer with the org.
Is this an issue in the SAS Management Console Administration, the Windows Server Administration (where the SAS server lives), or elsewhere? I'm quite new to SAS administration, and I've not found a good answer anywhere else.
Thanks.