Date:         Thu, 23 Sep 2010 15:38:24 -0700
Reply-To:     Dale McLerran <stringplayer_2@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Dale McLerran <stringplayer_2@YAHOO.COM>
Subject:      Re: Problems reading Excel files
In-Reply-To:  <9529D0E21F68E547B2D948785925A67E02D3EF7F4D@MDTSSWECCR18.rf01.itservices.ca.gov>
Content-Type: text/plain; charset=iso-8859-1

I don't know why, but for my installation, specification of a
libname with server= and port= specifications like the one
below does not work for me.

libname libref1 pcfiles server="server name" port=8621
        path="drive:\path1\path2\file.xls";


For the server, I specified my computer's fully qualified name.
When I use the above syntax, I get the error message:

ERROR: CLI error trying to establish connection: [Microsoft][ODBC Excel
       Driver] '(unknown)' is not a valid path.  Make sure that the path
       name is spelled correctly and that you are connected to the server
       on which the file resides.
ERROR: Error in the LIBNAME statement.


What appears to be an explanation for this is found at:
http://support.sas.com/kb/35/064.html
But in my case, the SAS PC File Server service was started
after the network drives had been mapped.

Note, I have no trouble if I remove the server= and port=
specifications and simply enter

libname libref1 pcfiles path="drive:\path1\path2\file.xls";


Dale

---------------------------------------
Dale McLerran
Fred Hutchinson Cancer Research Center
mailto: dmclerra@NO_SPAMfhcrc.org
Ph:  (206) 667-2926
Fax: (206) 667-5977
---------------------------------------


--- On Thu, 9/23/10, Choate, Paul@DDS <Paul.Choate@DDS.CA.GOV> wrote:

> From: Choate, Paul@DDS <Paul.Choate@DDS.CA.GOV>
> Subject: Re: Problems reading Excel files
> To: SAS-L@LISTSERV.UGA.EDU
> Date: Thursday, September 23, 2010, 2:49 PM
> From what I have read, the ACCESSCS
> and EXCELCS engines are Access and Excel specific versions
> of the 64 bit PCFiles engine.
>
> So Dan's code below could also be written:
>
> libname libref1 pcfiles server="server name" port=8621
>         path=
> "drive:\path1\path2\file.xls";
>
> or for Access
>
> libname libref2 pcfiles server="server name" port=8621
>         path=
> "drive:\path1\path2\file.mdb";
>
> hth
>
> Paul Choate
>
> ==================================
> Dale,
>
> Try something like the following
>
> libname BL_WH excelcs
> path="Q:\SBERESFO\PACE\Data\Baseline\Intensive Assessment
> H_W_C 013008.xls"
>         server='your computer name'
>         port=8621;
>
> This syntax works on my system (similar to what you
> described).  I just used the computer name that
> displays when I display the properties of my computer.
>
> Hope this is helpful,
>
> Dan
>
> Daniel J. Nordlund
> Washington State Department of Social and Health Services
> Planning, Performance, and Accountability
> Research and Data Analysis Division
> Olympia, WA 98504-5204
>