Desktop productivity for business analysts and programmers

OLEDB Connection fails

Reply
New Contributor Bob
New Contributor
Posts: 4

OLEDB Connection fails

I have an open track on this, but its taking a while to get to the bottom of it:
I am running EG 4.1 in C/S mode against a foundation install of SAS 9.1.2
On the server I can create a libname statement to connect to an OLEDB source. I want the same library for my EG clients. Unfortunately the libname statement causes the server connection to fail. It seems to be a permissions problem, despite validating all the entries in the Local Security Policy. Running Base SAS on the server as a resticted user (local admin account)I get the error "The service cannot be started, either because it is disabled or because it has no enabled devices associated with it" and SAS will not run - I believe this is related.

In EG, all I get is a "failed to initialise" message when I run the libname statement in a code node
Ask a Question
Discussion stats
  • 0 replies
  • 118 views
  • 0 likes
  • 1 in conversation