BookmarkSubscribeRSS Feed
rtynd4
Calcite | Level 5

I will try it again and let you know what issues we have.

SASKiwi
PROC Star

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.

rtynd4
Calcite | Level 5

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.

 

 

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 17 replies
  • 319 views
  • 0 likes
  • 4 in conversation