Date:         Thu, 2 Jan 1997 17:44:55 -0400
Reply-To:     Tim.VICTOR@SB.COM
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Tim Victor <Tim.VICTOR@SB.COM>
Subject:      (Still Not) Connecting to Sybase - Sigh

     To all,
 
     Thanks for taking the time to give me hand.  I really appreciate it.
     I've been able to do just about anything I want if I run access
     interactively.  But, and there's always a but, when I try to run a
     batch session I get either one of two errors returned from the server.
     Error 1:
        Msg 4002, Level 14, State 1: Login failed. DB-Library: Login
     incorrect.
 
     Error 2:
        DB-Library: Net-Library operation terminated due to disconnect
      Operating-system error: There is no OS level error
 
     Error 1 baffles me becase I've even created an ID that requires no
     password.
 
     Error 2 occurs, I'm assuming, when the connection times-out.
 
     Am I wasting my time creating views because I will just end up
     creating SAS datasets from the data anyway, or should I continue to go
     at this one?  The tables are fairly significant _2 million rows and
     growing.
 
 
     Thanks again.
 
     Tim
 
 
     Happy New Year!!
 
     To start my new year off, I received ver. 6.12 to play with.  Up until
     this point I've never used the Access module.  I'm trying to connect
     to a Sybase server running on WinNT 4.0 server.  I am running WinNT
     4.0 workstation.
 
     When I use the syntax:
 
     PROC ACCESS DBMS=SYBASE;
        CREATE TEST.TEST_TBL.ACCESS;
        SERVER=IDS;
        DATABASE=IDS1;
        USER=timv;
        PASSWORD=xxxxxxx;
        TABLE=physician;
     RUN;
 
     No luck...
 
     However when I use PROC SQL:
 
     PROC SQL;
        CONNECT TO SYBASE AS syb (server=ids database=ids1 user=timv
     password=xxxxxxx);
        CREATE TABLE test.test_tbl AS
        SELECT *
        FROM CONNECTION TO syb
                (SELECT * FROM physician);
 
     QUIT;
 
     I have loads of success.  Any suggestions, comments?
 
     TIA,
 
     Tim Victor
 
     Lead Analyst/Programmer
     SmithKline Beecham
     Voice:     215-751-4797
     FAX:       215-751-4313
     email:     Tim.VICTOR@sb.com