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
Content-Type: text/plain; charset=us-ascii
they came over and uninstall all of sas. Did a complete reinstall of
On Fri, 11 Apr 2008 10:31:49 -0600, savian001@GMAIL.COM (Alan
>Wild stab here but did you have a customized config file that needs to be
>From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of sparks
>Sent: Friday, April 11, 2008 10:02 AM
>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: 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
>>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
>>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.
>>1655 N. Ft Myer Dr Ste 925
>>Arlington, VA 22209
>>From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
>>Sent: Friday, April 11, 2008 10:14 AM
>>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.