DATA Step, Macro, Functions and more

SAS Microsoft SQL connection issue

Reply
Frequent Learner
Posts: 1

SAS Microsoft SQL connection issue

Hello everybody,

 

I would like to access a Microsoft SQL database thorugh SAS, but do receive the following error after running the commands.

A connection to the database through Windows ODBC driver is no problem at all. A connection via Excel is also working.

So the user and database is working.

 

Just through SAS I get the following messages:

 

When I try it with a 'proc sql' statement:

 

"The ODBC engine cannot be found etc"

"A connection to the ODBC DBMS is currently not supported, or it is not installed at your site"

"ERROR: Java repository file(s) are missing or inaccessible."

"ERROR: Unable to initialize the ODS classpath during SAS startup."

"ERROR: Exception text: For one or more plug-in requests, no matching Plug-ins were found in

       Repository"

 

Trying to connect via 'libname' statement is also not possible.

Similar error codes.

 

I searched a lot for it, but haven't found a solution yet.

I think it might be a problem with the license or installation.

 

Is the module "SAS/ACCESS Interface to Microsoft SQL database" or "to ODBC" mandatory to perform these operations?

 

OS: Microsoft Windows 7 x64

 

Output PROC SETINIT:

Current version: 9.04.01M5P091317

Product expiration dates:

---Base SAS Software

---SAS/STAT 

---SAS/GRAPH 

---SAS/Secure 168-bit

---SAS/Secure Windows

---SAS Enterprise Guide                       

---SAS/ACCESS Interface to DB2                                                                    

---SAS Workspace Server for Local Access                                                         

---High Performance Suite      

 

  

Output PROC PRODUCT_STATUS

 For Base SAS Software ...

   Custom version information: 9.4_M5

   Image version information: 9.04.01M5P090617

For SAS/STAT ...

   Custom version information: 14.3

For SAS/GRAPH ...

   Custom version information: 9.4_M5

For High Performance Suite ...

   Custom version information: 2.2_M6

For SAS/ACCESS Interface to DB2 ...

   Custom version information: 9.4_M2

                                           

 

Thanks and best Regards                                                                                      

PROC Star
Posts: 548

Re: SAS Microsoft SQL connection issue

yes it is. Below is short and sweet article which explains role of SAS/Access and help you think through the issue.

 

https://www.sas.com/content/dam/SAS/en_us/doc/factsheet/sas-access-103392.pdf

 

Ask a Question
Discussion stats
  • 1 reply
  • 123 views
  • 0 likes
  • 2 in conversation