Date:         Fri, 11 Apr 2008 18:01:46 GMT
Reply-To:     sparks <sparks@COMCAST.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         sparks <sparks@COMCAST.NET>
Organization: EasyNews, UseNet made Easy!
Subject:      Re: new computer and now I can't connect to access database
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=us-ascii

they came over and uninstall all of sas. Did a complete reinstall of
everything.
Same problem.


On Fri, 11 Apr 2008 10:31:49 -0600, savian001@GMAIL.COM (Alan
Churchill) wrote:

>Wild stab here but did you have a customized config file that needs to be
>copied over?
>
>Alan
>
>Alan Churchill
>Savian
>www.savian.net
>
>
>-----Original Message-----
>From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of sparks
>Sent: Friday, April 11, 2008 10:02 AM
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: Re: new computer and now I can't connect to access database
>
>Not really sure what I need to create.
>
>this is what I am getting when I try to run this program that has
>worked fine for the last 4 years
>
>ERROR: Connect:
>
>ERROR: Error in the LIBNAME statement.
>Connection Failed.  See log for details.
>ERROR: File WORK.TBLCGMDATASUMMARY.DATA does not exist.
>
>
>I take it to one of the other systems and it works fine.
>
>the my odbc looks the same as the one on the machine that works.
>I looked on SAS site about odbc and when they show the odbc like you
>are describing it shows SAS as one of the items.
>
>None of our machines shows this
>
>
>
>
>
>On Fri, 11 Apr 2008 09:57:17 -0500, Carol.Bristow@DPRA.COM (Carol
>Bristow) wrote:
>
>>But did they port over your ODBC settings? Sounds like they didn't, and
>>I must confess that I never remember to do that when moving to a new
>>computer either.
>>
>>I don't recall if it's something you can do yourself if you don't have
>>admin rights on your computer.  If you do have rights, you need to go to
>>the control panel and look for Administrative Tools.  Under Admin Tools
>>is Data Sources (ODBC).  Using that, create new DSNs for any data
>>sources that you need to connect to.  The type of DSN (user, system or
>>file) depends on who needs to be able to use them - descriptions are
>>shown at the bottom of the tabs.
>>
>>Carol Bristow
>>DPRA Inc.
>>1655 N. Ft Myer Dr  Ste 925
>>Arlington, VA 22209
>>phone: 703-682-2612
>>fax: 703-528-3100
>>
>>
>>-----Original Message-----
>>From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
>>sparks
>>Sent: Friday, April 11, 2008 10:14 AM
>>To: SAS-L@LISTSERV.UGA.EDU
>>Subject: new computer and now I can't connect to access database
>>
>>They finally gave me a new computer. Installed everything including
>>sas 9.1 with the 9.1.3 patch
>>
>>now programs that were running fine give a connection error when I try
>>to connect to anything...I am ASSUMING its odbc. Our tech support
>>(hahaha) hasn't got a clue.
>>
>>We have 10 older installs and have never seen this before.
>>All system have XP pro, office 2003 and sas installed.
>>
>>any ideas on what is wrong and how to fix it are greatly appreciated.