DATA Step, Macro, Functions and more

pc file server-SAS Microsoft Office addin conflict

Reply
Super Contributor
Super Contributor
Posts: 467

pc file server-SAS Microsoft Office addin conflict

Hi,

I am using BASE SAS 64bit on windows 7  64bit and  Microsoft Office 32 bit and  have PC File Server 32bit installed. Everything worked fine  till I installed SAS Microsoft Office addin.

Now when I am  trying to access an "access"  table

 

LIBNAME mylib pcfiles PATH="&location\xyz..accdb";

 

I am receiving errors:

 

ERROR: CLI error trying to establish connection: [Microsoft][ODBC Microsoft Access Driver]General

error Unable to open registry key Temporary (volatile) Ace DSN for process 0x182c Thread

0x1828 DBC 0x2e47fd4 Jet'.

ERROR: Error in the LIBNAME statement.

 

I am wondering if the add-in caused this? Anyone with similar problem  or any ideas/suggestions please?

 

thanks,

Super User
Posts: 13,941

Re: pc file server-SAS Microsoft Office addin conflict

Why do you have two periods in there?

 

LIBNAME mylib pcfiles PATH="&location.\xyz.accdb";

might work better. The dot with a macro variable should be after the macro variable not at the extension (unless that is where you are using a macro variable).

Super Contributor
Super Contributor
Posts: 467

Re: pc file server-SAS Microsoft Office addin conflict

Sorry.i just made up the path and thats not the issue
Super User
Posts: 13,941

Re: pc file server-SAS Microsoft Office addin conflict


@Tal wrote:
Sorry.i just made up the path and thats not the issue

 

 

When posting errors it is best to post the CODE with the error from the log. If macro values are involved the turn on the option MPRINT before running the code. The copy and past the code and error from the log into a code box opened using the forums {I} icon to preserve any formatting of error messages. The message windows will reformat text to remove leading spaces and such an may make certain diagnostics that SAS places with some error messages less meaningful.

 

If you show the actual code run then artificially induced errors such as posting a file name with ..accdb would not have to be questioned. Note that the content of your macro variable is still a possible issue. If you generate the same error without the macro variable then show the code and messages from log without the macro variable.

 

Super Contributor
Super Contributor
Posts: 467

Re: pc file server-SAS Microsoft Office addin conflict

i am just trying  to access  the "Access" Database

 

 LIBNAME mylib pcfiles PATH="&loctbls\&date1\Canada_Life\new_&date1..accdb";

Nothing is  wrong with the  libname statement as  I' ve  run it many times before  I installed the  SAS Microsoft Office Add-in

Now  after I installed  the add in after running the  libname above  I receive the error  posted in my  previous post

I goggled the error and the info I  get is  pc file server not installed and I do have it installed  so I was  wondering if there is some  conflict between the add in and  the  pc file server which some  of  you might  have experienced

 

Regular Contributor
Posts: 226

Re: pc file server-SAS Microsoft Office addin conflict

The message "Unable to open registry key Temporary..." reminds me of an error we always have on fresh sas installation on windows server with access to pcfiles. One problem note brought the solution: in the registry access rights had to be extended for and odbc-entry. Sorry, can't remember details right now.
Ask a Question
Discussion stats
  • 5 replies
  • 67 views
  • 0 likes
  • 3 in conversation