Date:         Fri, 11 Jan 2002 11:11:18 -0500
Reply-To:     "Michael L. Davis" <michael@BASSETTCONSULTING.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Michael L. Davis" <michael@BASSETTCONSULTING.COM>
Subject:      Re: ODBC trouble
In-Reply-To:  <1DE3900A83C2D211872C00A0C9EA39E402460A9E@drsmthchl040.dcaa
              intra.mil>
Content-Type: multipart/alternative;

Hello Friends,

The name of the document to which Curtis refers is TS-626, "Configuring the
SAS V8 ODBC Driver".

BTW, one thing that often confuses folks about SAS and ODBC the
licensing.  The ability of SAS to serve data to ODBC clients is part of
Base SAS.  The ability of SAS to serve as an ODBC client requires the
SAS/ACCESS Interface to ODBC or some other technique.

- Michael "Mad Doggy" Davis

At 09:43 AM 1/11/2002 -0600, "Smith, Curtis, Mr, DCAA"
<Curtis.Smith@DCAA.MIL> wrote:

>There are some very specific steps involved in setting up the ODBC driver.
>In particular, you have to edit the Windows file named 'services'.
>Somewhere on the SAS site is a lengthy document that leads you through the
>installation steps.
>
>
>
>-----Original Message-----
>From: Eric Hoogenboom [mailto:ehoogenboom@AMITIMES.COM]
>Sent: Friday, January 11, 2002 3:09 AM
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: ODBC trouble
>
>
>
>Hello SAS-L,
>
>
>
>Running SAS 8 under Win98, I want to get data in Excel from a SAS-dataset
>through MS Query. I have installed the ODBC-driver (from sas.com) but when
>I choose the driver I receive the error:
>
>
>
>178 - TCP method failed rc = -1005 (Unable to locate service.).
>
>Driver's SQLSetConnectAttr failed
>
>
>
>I wonder if it looks familiar to any of you!
>
>
>
>Thanks in advance,
>
>Eric Hoogenboom
>
>

Michael L. Davis
Vice President
Bassett Consulting Services, Inc.
10 Pleasant Drive
North Haven  CT  06473-3712
E-Mail:  michael@bassettconsulting.com
Web:  http://www.bassettconsulting.com
Telephone:    203-562-0640
Facsimile:    203-498-1414
Messages:     888-477-1412

[text/html]