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