Date:         Tue, 23 Nov 2004 07:12:20 -0500
Reply-To:     JumboShrimps <Jumbo_shrimps@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         JumboShrimps <Jumbo_shrimps@HOTMAIL.COM>
Organization: Posted via Supernews, http://www.supernews.com
Subject:      Linking Access 2000 to SAS 8.1

ODBC -call failed
[SAS][SAS ODBC Driver][SAS Server][178-TCP method failed
rc= -1019 (Timeout waiting for the SAS server.....
[Microsoft][ODBC Driver Manager]Driver's SQLSetConnectAttr
failed IM006 0....etc.

Set up the latest SAS ODBC drivers using article TS626 ,
and the latest MDAC from Microsoft on a Win2k platform
for PC SAS 8.1 running on the local C:\ drive.
Did make a server entry in the Microsoft services file
per the article, but how would SAS know about that?
It's an arbitrary tcp number anyway.

Also, TS626 references a specific file name in the library
set up  (has to be USER for Access 2000).  While
I do have a USER library, there is no file named USER
in the SAS files directory I'm pointing to (or anywhere
else for that matter).  Again, that could be the problem....
.