LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (September 2011, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 7 Sep 2011 22:48:26 -0400
Reply-To:     Arthur Tabachneck <art297@ROGERS.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@ROGERS.COM>
Subject:      Re: PC File Server failure
Comments: To: Richard <r.hockey@SPH.UQ.EDU.AU>
Content-Type: text/plain; charset=ISO-8859-1

Keith,

I haven't had the misfortune of having to use it, yet, but I seem to recall reading that the pc files server has to be installed on the same drive where the file resides.

Art ------- On Wed, 7 Sep 2011 21:12:10 -0400, Richard <r.hockey@SPH.UQ.EDU.AU> wrote:

>If the access db is local you can use the autostart facility see: >http://support.sas.com/documentation/cdl/en/acpcref/63181/HTML/default/view er.htm#n136kp4vncsrl8n1xmgwvwhricrw.htm > >You may have to use the \\hostname\....l format to locate the file is its >on a network. >Also some have got mileage out of removing blanks from file and path names. >R > >On Wed, 7 Sep 2011 08:12:59 +0200, Keith Larson <keith.larson@BIOL.LU.SE> wrote: > >>Dear list, >> >>I thought I would rephrase my question. I have a Windows 7 64x machine >>running SAS 9.2 64x and I DID download and install PC File Server. How >>can I test that it is working properly? When I run it I get no error >>messages, but I do get the following error message when I run the >>following code to import data from MS Access 2003. >> >>proc import >> dbms = accesscs >> out = work.WW_Site_Locations replace >> table = 'Site_Locations'; >> database = 'Z:\Projects\Lund\Willow Warblers\Data\Willow >>Warbler Database.mdb'; >>run; >> >>The results: >> >>ERROR: Failed to connect to the Server: . >> >>************************************** >>Keith Larson, PhD Student >>Evolutionary Ecology, Lund University >>S´┐Żlvegatan 37 >>223 62 LUND >>Sweden >>Phone: +46 (0)46 2229014 >>Mobile: +46 (0)73 0465016 >>Fax: +46 (0)46 2224716 >>Skype: sternacaspia >>FB: keith.w.larson@gmail.com >>**************************************


Back to: Top of message | Previous page | Main SAS-L page