I will try it again and let you know what issues we have.
The first thing to check are firewall rules for the port(s) the ODBC driver is using. Does your SAS server run on Linux or Windows? It's a lot easier to test this on Windows as you can do this all in the Windows ODBC Administrator tool.
The install is on Solaris.
I have tried to connect using
SAS/ACCESS Interface to Microsoft SQL Server
Is there a product SAS/ACCESS Interface to ODBC?
I created a server and library using SQL Server and get errors when trying to register tables.
In the SMC I created a server and library choosing ODBC but when I try to register tables it says there is not ODBC drivers.
Yes, there is a product called SAS/ACCESS Interface to ODBC. You can check if you have it installed and licensed by running this:
proc product_status;
run;
proc setinit;
run;
However SAS/ACCESS Interface to SQL Server should also work. Did the SQL Server LIBNAME assign without errors or not? Please post your SAS log.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.