Date:         Tue, 15 Aug 2000 15:07:34 +0100
Reply-To:     David Johnson <David.Johnson@UK.ROYALSUN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         David Johnson <David.Johnson@UK.ROYALSUN.COM>
Subject:      Sybase IQ, V8e, Unix
Comments: To: SAS-L@LISTSERV.VT.EDU
Content-Type: text/plain; charset=iso-8859-1

I have Version 8.1 running on Unix OS11.0, installed with Sybase ASE connection
to the local Sybase server.

I can specify our Production Sybase server through either the Proc or the
Libname statement and hit the ASE servers with no problems.

I have an IQ server elsewhere, and have tried to hit that with the appropriate
server and schema name.  I am getting the following message:

ERROR: Connection failed.  Error Code: -4002  Login failed.

ERROR: Error in the LIBNAME statement.

As far as I can tell, the user name and password I am using are correct.  In
the absence of DBAs (they are all meeting to discuss IQ!!!) I can't check this
for now, but I have repeatedly retyped the value to be sure.

Has anyone else had this sort of error?  My feeling is that since I linked the
Sybase access module to the local Sybase ASE server, then I can't get to IQ
without some other process.

Any guidance appreciated.

Thanks

David