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 (April 2008, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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:
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 > > > >-----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.

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