Date: Wed, 7 Sep 2011 15:38:55 +0000
Reply-To: "DUELL, BOB" <bd9439@ATT.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "DUELL, BOB" <bd9439@ATT.COM>
Subject: Re: Access Database woes with proc import
In-Reply-To: <CAM1PXy3xfey1r0S9NHkNhD=jGL2z1X46J25zLrpX1qR5dBzM3Q@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Hi Keith,
Although it is confusing, "server" in this sense refers to the "client-server" model, not to a different computer or operating system. It might be more clear to think of it as a "service" running on your PC. If the service has been started, it should be working. One way to check is to see if an image named "pcfserver.exe" is listed in your Task Manager; that is the PC Files Server.
If it's not listed in Task Manager, you should be able to start it manually (during the install you should have been asked if you wanted it started automatically). I don't have Windows 7 myself, but on my PC there is a link in "Start->Programs->SAS<PC Files Server" to start the server.
Here is a link to a very lengthy description on the subject from the SAS-L archives:
http://www.listserv.uga.edu/cgi-bin/wa?A2=ind1105b&L=sas-l&P=16949
The message suggests that if you are using SAS 9.2 TS2M3 and Windows 7 on the SAME machine that you do not need to use the "server" option. Since you say you have TS2M2, you may need to upgrade SAS on your PC. TS2M3 had tons of updates and may be required for this to work for you.
A Google-search for "sas pc files server install" returns lots of other useful hits.
I sympathize with you; I also hate it when IT "upgrades" my PC without prior notice. Of course, it's not really "my" PC, but I still think it's rude.
Good luck,
Bob
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Keith Larson
Sent: Tuesday, September 06, 2011 11:10 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Access Database woes with proc import
Richard et al.,
Sorry, but I did download and install the appropriate version of PC
File Server for Windows 7 64x. In addition, it is a bit abstract
reading the documentation as my computer despite being on a network is
not a server in any traditional sense. My SAS program is installed to
be used locally only and the data served only to the computer it is
on. Interestingly this is happening on both of my Windows 7 64x
computers so there must be some settings I am getting wrong.
Any suggestions on how to test if the PC File Server is working?
Cheers,
Keith
**************************************
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
**************************************
On Wed, Sep 7, 2011 at 2:04 AM, Richard <r.hockey@sph.uq.edu.au> wrote:
> You need to download and install the appropriate SAS pc files server . see
> http://support.sas.com/kb/33/228.html
>
> R
> On Tue, 6 Sep 2011 19:53:47 +0200, Keith Larson <keith.larson@BIOL.LU.SE> wrote:
>
>>Dear SAS list,
>>
>>I have returned from the field to find my new computer is running
>>Windows 7 64 with SAS 9.2 (TS2M2) and all my old SAS scripts to do
>>analysis with data from my Access databases no longer work. I have
>>installed SAS PC Files Server following online instructions and
>>changed the DBMS option from Access97 to AccessCS. When I run the
>>following example code I have problems:
>>
>>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: .
>>
>>What am I doing wrong?
>>
>>Keith
>>
>>*************************************
>>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
>>**************************************
>
