Re: new computer and now I can't connect to access database

hhmm... have they copied the DSN, but not the driver itself?

just a wild hunch...

sparks wrote:
> 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.
>

--

"Games? Solitaire? I have a 2-node VAXcluster, 3 Windows 2000 servers, 2
Windows 2003 servers, 1 MySQL Database Server, 1 Postgres Database
Server, 1 Linux server, several Ubuntus and a direct satellite feed to
my windows desktop background, who needs toys???" - Jim