HI,

I'm new to sybase. I had some problem to setup connection from client
to server.

Following is my environment.

Server: ASE version 9.0.2+ AIX 4.3
Client: ASE developer edition 12.5 (free download from sybase site)+
windows2000

I installed client successfully.

I setup connection by
1. Start---Programs---Sybase----DSedit utility
2. choose InterfaceDriver to open
3. choose Server Object--- add
4. type in server name. (it is the name I set in the hosts file, I
could ping the server name).
5. edit Server address, choose TCP as Protocal, input Sybase server IP
and port like following xxxx.xxxx.xxxx.xxxx,1025

6. Server Address---> Ping server
I got "open connection to server xxxx.xxxx.xxxx.xxxx succeeds.
close connection succeeds.
loaded dynamic link library NLWNSCK.dll "
7. Start---Programs---Sybase----OCscfg
choose Net-Library tab.
choose protocal as TCP

8. Start---Programs---Sybase--- Sybase Central Java Edition
choose tools--- connect
fill in the ID and PW and servername plus port.

I got following error message

010MX: Metadata accessor information was not found on this database.
Please install the required tables as mentioned in the jConnect
documentation. Error encountered while attempting to retrieve metadata
information: java.sql.SQLException: JZ0SJ: Metadata accessor
information was not found on this database. Please install the
required tables as mentaioned in the jConnect documentation.

after click ok on the error window, another message coming out

Java ASEPlugin does not support Server prior than version 12.0

9. then I try to use isql to access sybase db.

from the command line, I type:
isql -Uuser -Ppassword servername

I got the error message
CT-LIBRARY error:
ct_connect(): directory service layer: internal directory
control layer
error: Requested server name not found.


I try to use IP address+port NO to instead of servername, still error
out.


I would be very appreicate if sb. could give me some idea how to make
the connection. Thanks.

as you are running sybase 11.9.2 , I guess, you should either use the
11th client and it's Java env or the still valid and operational
scview.exe and the proper env



@echo off

set SYBASE=G:\sybase\syclient\12_5



regedit /s %SYBASE%\SybaseCentral.reg

set SYBASE_OCS=OCS-12_5

set JAVA_HOME=%SYBASE%\jre-1_1-nt386

set CLASSPATH=%JAVA_HOME%\lib\rt.jar;%JAVA_HOME%\lib\s wingall.jar;%SYBA-
SE%\asep\3pclass.zip;%SYBASE%\asep\monclass.zip

set path=%SYBASE%\%SYBASE_OCS%\bin;%SYBASE%\%SYBASE_OC S%\DLL;%JAVA_HOME-
%\bin;%SYBASE%\ASEP;%SYBASE%\..\tools

start %SYBASE%\"Sybase Central 3.2"\win32\scview.exe


--
Posted via http://dbforums.com

osy45 <member18536@dbforums.com> wrote in message news:<3535396.1067423199@dbforums.com>...
> as you are running sybase 11.9.2 , I guess, you should either use the
> 11th client and it's Java env or the still valid and operational
> scview.exe and the proper env
>
>
>
> @echo off
>
> set SYBASE=G:\sybase\syclient\12_5
>
>
>
> regedit /s %SYBASE%\SybaseCentral.reg
>
> set SYBASE_OCS=OCS-12_5
>
> set JAVA_HOME=%SYBASE%\jre-1_1-nt386
>
> set CLASSPATH=%JAVA_HOME%\lib\rt.jar;%JAVA_HOME%\lib\s wingall.jar;%SYBA-
> SE%\asep\3pclass.zip;%SYBASE%\asep\monclass.zip
>
> set path=%SYBASE%\%SYBASE_OCS%\bin;%SYBASE%\%SYBASE_OC S%\DLL;%JAVA_HOME-
> %\bin;%SYBASE%\ASEP;%SYBASE%\..\tools
>
> start %SYBASE%\"Sybase Central 3.2"\win32\scview.exe


HI, thanks for the suggestion.

I tried using scview.exe, it works.

But I still cannot use isql to connect to Sybase Server. how to use
isql , if I need to do some configuration before run the isql command?

By the way, where I could find some entry level manual or books on
Sybase. From the Sybase web site, I found some ASE manuals. But It
seems not very clearly which manual/book introduce some Sybase
Database basic concepts?


Any suggestion is very appreciated.

Originally posted by Jane

> osy45 <member18536@dbforums.com> wrote in message
> news:<3535396.1067423199@dbforums.com>...

> > as you are running sybase 11.9.2 , I guess, you should either
> use the

> > 11th client and it's Java env or the still valid and
> operational

> > scview.exe and the proper env

> >

> >

> >

> > @echo off

> >

> > set SYBASE=G:\sybase\syclient\12_5

> >

> >

> >

> > regedit /s %SYBASE%\SybaseCentral.reg

> >

> > set SYBASE_OCS=OCS-12_5

> >

> > set JAVA_HOME=%SYBASE%\jre-1_1-nt386

> >

> > setASSPATH=%JAVA_HOME%\lib\rt.jar;%JAVA_HOME%\lib\ swingall.jar;%SYBA-
>

> > SE%\asep\3pclass.zip;%SYBASE%\asep\monclass.zip

> >

> > setth=%SYBASE%\%SYBASE_OCS%\bin;%SYBASE%\%SYBASE_O CS%\DLL;%JAVA_HOME-
>

> > %\bin;%SYBASE%\ASEP;%SYBASE%\..\tools

> >

> > start %SYBASE%\"Sybase Central 3.2"\win32\scview.exe

>

>

> HI, thanks for the suggestion.

>

> I tried using scview.exe, it works.

>

> But I still cannot use isql to connect to Sybase Server. how to use

> isql , if I need to do some configuration before run the isql command?

>

> Are the env varables correctly set .

> path = %PATH%;%SYBASE%\Ocs-12_5\bin;%SYBASE%\Ocs-12_5\dll

>

> & it is a command line tool

>

> you can check it by submitting it directly from the bin directory

> is the sql.ini file pointing to all the servers you want to
> connect to ?

>

> By the way, where I could find some entry level manual or books on

> Sybase. From the Sybase web site, I found some ASE manuals. But It

> seems not very clearly which manual/book introduce some Sybase

> Database basic concepts?

>

> There are some useable books out there. Garbus Sybase ASE 12.5 Admin
> and the Sybase Docs itself available from sybase.com

>

>

Any suggestion is very appreciated.


--
Posted via http://dbforums.com

osy45 <member18536@dbforums.com> wrote in message news:<3540030.1067506042@dbforums.com>...
> Originally posted by Jane
>
> > osy45 <member18536@dbforums.com> wrote in message
> > news:<3535396.1067423199@dbforums.com>...
>
> > > as you are running sybase 11.9.2 , I guess, you should either
> > use the
>
> > > 11th client and it's Java env or the still valid and
> > operational
>
> > > scview.exe and the proper env
>
> > >
>
> > >
>
> > >
>
> > > @echo off
>
> > >
>
> > > set SYBASE=G:\sybase\syclient\12_5
>
> > >
>
> > >
>
> > >
>
> > > regedit /s %SYBASE%\SybaseCentral.reg
>
> > >
>
> > > set SYBASE_OCS=OCS-12_5
>
> > >
>
> > > set JAVA_HOME=%SYBASE%\jre-1_1-nt386
>
> > >
>
> > > setASSPATH=%JAVA_HOME%\lib\rt.jar;%JAVA_HOME%\lib\ swingall.jar;%SYBA-
> >
>
> > > SE%\asep\3pclass.zip;%SYBASE%\asep\monclass.zip
>
> > >
>
> > > setth=%SYBASE%\%SYBASE_OCS%\bin;%SYBASE%\%SYBASE_O CS%\DLL;%JAVA_HOME-
> >
>
> > > %\bin;%SYBASE%\ASEP;%SYBASE%\..\tools
>
> > >
>
> > > start %SYBASE%\"Sybase Central 3.2"\win32\scview.exe
>
> >
>
> >
>
> > HI, thanks for the suggestion.
>
> >
>
> > I tried using scview.exe, it works.
>
> >
>
> > But I still cannot use isql to connect to Sybase Server. how to use
>
> > isql , if I need to do some configuration before run the isql command?
>
> >
>
> > Are the env varables correctly set .
>
> > path = %PATH%;%SYBASE%\Ocs-12_5\bin;%SYBASE%\Ocs-12_5\dll
>
> >
>
> > & it is a command line tool
>
> >
>
> > you can check it by submitting it directly from the bin directory
>
> > is the sql.ini file pointing to all the servers you want to
> > connect to ?
>
> >
>
> > By the way, where I could find some entry level manual or books on
>
> > Sybase. From the Sybase web site, I found some ASE manuals. But It
>
> > seems not very clearly which manual/book introduce some Sybase
>
> > Database basic concepts?
>
> >
>
> > There are some useable books out there. Garbus Sybase ASE 12.5 Admin
> > and the Sybase Docs itself available from sybase.com
>
> >
>
> >
>
> Any suggestion is very appreciated.



HI, really appreiciated your help.

I checked the PATH, it seems OK.

FOllowing is the PATH
Path=c:\sybase\OLEDB;c:\sybase\ODBC;c:\sybase\ASEP _Win32;c:\sybase\OCS-12_5\dll;
c:\sybase\OCS-12_5\lib3p;c:\sybase\OCS-12_5\bin;c:\sybase\shared-1_0\jre1.2.2\bi
n\classic;C:\Program Files\SQLLIB\BIN;C:\Program Files\SQLLIB\FUNCTION;C:\Progra
m Files\SQLLIB\HELP;C:\Program Files\jConnect-5_5;c:\winnt\system32;c:\jdk1.1.8\
bin

following is my sql.ini
[sybase_srv]
master=TCP,172.18.1.5,1025
query=TCP,172.18.1.5,1025


[SYBOLTP]
master=TCP,172.18.1.5,1025
query=TCP,172.18.1.5,1025

I got following error message,

C:\sybase\OCS-12_5\bin>isql -Usa SYBOLTP
Password:
CT-LIBRARY error:
ct_connect(): directory service layer: internal directory control layer
error: Requested server name not found.

Any idea on it?

THanks.

jane <esthershensh@yahoo.com> wrote:
>
> C:\sybase\OCS-12_5\bin>isql -Usa SYBOLTP
> Password:
> CT-LIBRARY error:
> ct_connect(): directory service layer: internal directory control
layer
> error: Requested server name not found.

The option should be -SSYBOLTP

Luc.

Luc Van der Veurst <lucv@nospam.be> wrote in message news:<3fa13016$0$58701$e4fe514c@news.xs4all.nl>...
> jane <esthershensh@yahoo.com> wrote:
> >
> > C:\sybase\OCS-12_5\bin>isql -Usa SYBOLTP
> > Password:
> > CT-LIBRARY error:
> > ct_connect(): directory service layer: internal directory control
> layer
> > error: Requested server name not found.
>
> The option should be -SSYBOLTP
>
> Luc.

HI, Luc

Thanks very much! I use -S logging successfully!