Hi, I am having a problem with connecting to data in sql database. I am not sure if I don't have certain driver or if the code I am using is incorrect. Could someone please help guiding me to the right direction? 1. Below is the product license that I have after running Proc Setinit 2. Below is product installed after I ran Proc Product_Status It seems like sas access to sql server is not installed right? I am also trying these codes to connect and all got error. Which direction of code should I be using? ODBC or sqlsvr? I tried sqlsvr and got this error message Code: LIBNAME database1 sqlsvr user=datareader password=myspassword DATAsrc=clientA; Error: LIBNAME database1 sqlsvr user=datareader password=XXXXXXX DATAsrc=clientA; 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. When I tried ODBC route, I got this message Code: LIBNAME database1 ODBC DSN=clientA User=datareader Password=myspassword ; Error: LIBNAME database1 ODBC DSN=clientA User=datareader Password=XXXXXXX; ERROR: The ODBC engine cannot be found. ERROR: Error in the LIBNAME statement. Could someone please point me to the right direction? Should DSN be the name of the database of each client as "ClientA" etc or should it be the name of the server? Thank you so much!
... View more