Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Problem while registering tables in SAS Management Console

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 6
Accepted Solution

Problem while registering tables in SAS Management Console

Hi guys, I'm having a weir problem when i'm trying to register tables by using OLEDB.

 

It shows this error.

 

"Error OLEDB Engine cannot be found”

“Error in the libname statement”.

 

Please help :/!Error.png

 

 

Error2.png


Accepted Solutions
Solution
‎03-09-2017 03:24 PM
Trusted Advisor
Posts: 1,197

Re: Problem while registering tables in SAS Management Console

[ Edited ]

I am wondering.... maybe you are missing the OLEDB drivers (or the right ones to your databases) to be installed on your SAS server.

 

Something else to consider: OLEDB is a deprecated functionality on the SQL Servers. It does not come with the database by default.

 

Therefore, If you have a new database, you need to ask your System admin to have the drivers installed on the SQL Server side, and the right ones on your SAS Server.

View solution in original post


All Replies
Super User
Posts: 7,433

Re: Problem while registering tables in SAS Management Console

[ Edited ]

Does the libname statement as taken from the log work in a standard workspace server (ie from EG or SAS Studio)?

 

Do you have SAS/ACCESS to OLE DB licensed?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 6

Re: Problem while registering tables in SAS Management Console

Yes, i have the license for SAS/ACCESS to OLEDB.

 

The error appears inside the SAS Management Console

 

Thanks for replying Smiley Happy

Super User
Posts: 7,433

Re: Problem while registering tables in SAS Management Console

As SAS/ACCESS to RDBMS (of which Access to OLE DB is a part) often requires additional setup (usually in the form of setting certain environment variables), could it be that the workspace server used from SMC lacks those, while the workspace server used from EG has them?

(compare SASMeta - Workspace Server vs. SASApp - Workspace Server)

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
SAS Super FREQ
Posts: 468

Re: Problem while registering tables in SAS Management Console

Here is a link to the documentation on setting up the connection:

 

http://support.sas.com/documentation/cdl/en/bidsag/69848/HTML/default/viewer.htm#n0gu0ue4ptm3ocn1iw6...

 

Occasional Contributor
Posts: 6

Re: Problem while registering tables in SAS Management Console

I just realized that the SAS/ACCESS Interface to OLE DB is not instaled, and i cant find the setup :/

and i have the license for it... what can i do? 

 

Microsoft Windows Server for x64
Base SAS 29JUN2017
SAS Metadata Server 29JUN2017
SAS Studio 29JUN2017
SAS Visual Analytics 29JUN2017
SAS Visual Analytics LASR Server Non-Distributed 29JUN2017
SAS Visual Statistics 29JUN2017
SAS/ACCESS Interface to OLE DB 29JUN2017
SAS/CONNECT 29JUN2017

Trusted Advisor
Posts: 1,197

Re: Problem while registering tables in SAS Management Console

If you have the license, you should not require to install anything extra, since it is done automatically for you during the installation of SAS Foundation.


Could you follow the guide provided above?

Occasional Contributor
Posts: 6

Re: Problem while registering tables in SAS Management Console

I was following them, but when i'm creating the registering the OLEDB server, it doesn't show the default information that is displayed on the image.

 

I'm not getting those paremeters by default.

 

Like

 
Server Properties
Field
Sample Value
Major Version Number
4
Minor Version Number
0
Data Source Type
OLE DB — Other Database
Software Version
4.0
Vendor
Microsoft Corp.
Associated Machine
Defaults to your machine
----
 
 
In my case i'm getting
 
Server Properties
Field
Sample Value
Major Version Number
0
Minor Version Number
0
Data Source Type
OLE DB — Other Database
Software Version
 
Vendor
Microsoft Corp.
Associated Machine
"The name of my machine"
Solution
‎03-09-2017 03:24 PM
Trusted Advisor
Posts: 1,197

Re: Problem while registering tables in SAS Management Console

[ Edited ]

I am wondering.... maybe you are missing the OLEDB drivers (or the right ones to your databases) to be installed on your SAS server.

 

Something else to consider: OLEDB is a deprecated functionality on the SQL Servers. It does not come with the database by default.

 

Therefore, If you have a new database, you need to ask your System admin to have the drivers installed on the SQL Server side, and the right ones on your SAS Server.

Occasional Contributor
Posts: 6

Re: Problem while registering tables in SAS Management Console

Thanks for the help, the problem was that the SAS/ACCESS Interface to OLEDB wasn't  installed.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 9 replies
  • 255 views
  • 0 likes
  • 4 in conversation