October 14, 2005 at 8:18 am
Dear Friends,
I have small requirement to connect to a Sybase DB.
I have a SOLARIS-Server which runs a SYBASE DB and stores collected dats in its DB.I am using shell script in that same system in which I am using SQL Queries to get the deired data from the DB.
I have a IN system connected in the same LAN Network of the SOLARIS Sever.So I want to peform this task from the WIN System by making an interface with the the SYBASE DB.And already a BO/BI Application is running in the same system and interfacing with the same solaris-SERVER.But I would like to have a FREE HAND SQL Interface.
Any application pls suggest me.And I want to know how to setup he interface.I know the IP + Log in details for SOLARIS and SQL.
Regards
Sunil
October 17, 2005 at 8:00 am
This was removed by the editor as SPAM
October 19, 2005 at 6:41 pm
Are you going from MS SQL Server to Sybase or vis versa.
What version of Sybase are you using?
October 20, 2005 at 8:49 am
Hi Kory,
I am not well versed to know the version of SYBASE.
SYBASE-DB is in a SOLARIS Server and I am accessing the system via telnet.
I am not using MS-SQL.
Regards
SUNIL
October 20, 2005 at 8:49 am
Hi Kory,
I am not well versed to know the version of SYBASE.
SYBASE-DB is in a SOLARIS Server and I am accessing the system via telnet.
I am not using MS-SQL.
Regards
SUNIL
October 20, 2005 at 11:41 am
Are you asking if you can access a Sybase data server on Solaris from a windows platform?
October 20, 2005 at 11:59 am
Yes I want to access SYBASE-DB from WIN System.
Regards
Sunil
October 20, 2005 at 7:32 pm
First of all, from the UNIX command line isql into the Sybase data server and issue Select @@version, which will let you know the version of Sybase you are running. Then you will need to install the Sybase open client for windows on your windows pc. The version will be either 11 or 12 depending on your data server version. The Sybase 11 open client will work with the version 12 servers, but is not recommended. Once installed you can use dsedit.exe to enter an alias to the Sybase data server or you can edit the sql.ini directly. The format will be ip, port just like an alias in the MS SQL Server client network config. This will also look like the entry you would find in the Sybase interfaces file on UNIX, located in the $SYBASE dir. When that is configured you can then connect to the Sybase data server from windows using isql just like at the UNIX command line. You can also install Sybase Cenrtal, which is a graphical interface like EM.
c:\isql -Usa -Ppassword -Sserveralias
SYBASE> isql -Usa -Ppassword -Sserveralias
Hopefully this will be helpfull.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply