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.