Date: Thu, 2 Jan 1997 17:44:55 -0400
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Tim Victor <Tim.VICTOR@SB.COM>
Subject: (Still Not) Connecting to Sybase - Sigh
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.
Msg 4002, Level 14, State 1: Login failed. DB-Library: Login
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
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
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
When I use the syntax:
PROC ACCESS DBMS=SYBASE;
However when I use PROC SQL:
CONNECT TO SYBASE AS syb (server=ids database=ids1 user=timv
CREATE TABLE test.test_tbl AS
FROM CONNECTION TO syb
(SELECT * FROM physician);
I have loads of success. Any suggestions, comments?