Date:         Wed, 16 Aug 2000 09:09:03 +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 - SOLVED 4002 error, now another issue
Comments: To: SAS-L@LISTSERV.VT.EDU
Content-Type: text/plain; charset=iso-8859-1

I solved the issue for the problem below(repeated for those who need it at the
bottom).  The issue was simply that the server parameter is the logical Sybase
server name, not the physical server name.  Our two other environments happen
to have the same name for their ASE databases as the server name.  Correcting
this and the Libname options unsupported in IQ fixed the problem.

So, we can now connect to the IQ server, but the bulk copy utility doesn't work
in IQ.  So, each row takes almost 2 seconds to be added to the table.  For our
40 million row table this might be a slight problem <g>.

We could export the data to a flat file and import that into IQ with an IQ
process, but that has been raising problems with the representation of missing
values.  (It also has other issues, but I'll not air those publicly on the
list.  Email me privately if you are interested.)

On the other hand, we can load an ASE server with the bulk copy it supports and
then use the IQ process to 'get' the ASE table.  The problem is that doesn't
work and after a number of weeks Sybase still haven't given us a solution.

Does anyone have any other suggestions for getting from V8e into IQ?  Note that
all other processes are fine.  We can ceate and truncate tables, read
descriptors, dump rows and make the LIBNAME interface perform as we expected.
It is just the load.

Thanks

David

---------------------- Forwarded by David Johnson/UK/RoyalSun on 16/08/2000
08:42 ---------------------------
To: sas-l@akh-wien.ac.at
cc:

Subject: Sybase IQ, V8e, Unix

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