Date:         Fri, 11 Jan 2002 07:17:06 -0500
Reply-To:     Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Subject:      Re: ODBC trouble

On Fri, 11 Jan 2002 12:08:33 +0100, Eric Hoogenboom
<ehoogenboom@AMITIMES.COM> wrote:

>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
>
>
>

at installation of the ODBC driver: take care of activating "local" at the
selection window for "Server Name".

At runtime: check your COMAMID option. Is it TCP ? You should try it with
COMAMID=DDE;

I hope, that works. I can't test that, because I don't have a SQL Server
here. I once tried that with MS-Access 97.