Monday, April 20, 2009

Impromptu connecting to SAS via ODBC

If you're going to use Impromptu to connect to SAS datasets via ODBC, then you will need to do a couple of things.
  1. Install sasodbc.exe.
  2. Edit the TCP/IP Services file which in most cases is located in C:\WINDOWS\system32\drivers\etc.

Insert towards the end of Services file the following:

LOCALSAS 4500/tcp # Connection port for SAS and save the file.

If you don't do this part you will probably get the error message --->SAS Server 178 - TCP method failed rc = -1005 unable to locate service.

No comments:

Post a Comment