|
|
|
|
|
|
| Author |
Message |
Sashi
*nix forums addict
Joined: 14 Jun 2005
Posts: 95
|
 Posted: Fri Jul 07, 2006 2:04 pm Post subject:
Get servername and port
|
|
|
Hi, I'm connected to a DB server via a command prompt. I'm not sure how
this comand prompt is set up and I'm trying to figure out a way of
getting the (fully qualified) server name (or address) and the port
thru which I'm connected so that I can use this info to use a more user
friendly GUI to connect to the same DB.
Is this possible?
Thanks,
Sashi |
|
| Back to top |
|
 |
Sashi
*nix forums addict
Joined: 14 Jun 2005
Posts: 95
|
| Posted: Fri Jul 07, 2006 2:46 pm Post subject:
Re: Get servername and port
|
|
|
Sashi wrote:
| Quote: | Hi, I'm connected to a DB server via a command prompt. I'm not sure how
this comand prompt is set up and I'm trying to figure out a way of
getting the (fully qualified) server name (or address) and the port
thru which I'm connected so that I can use this info to use a more user
friendly GUI to connect to the same DB.
Is this possible?
Thanks,
Sashi
|
To answer my own question, I googled around some more and dug here and
there and found the answer in the $SYBASE/interfaces file. (This is on
Solaris 5.8, sorry for not mentioning it earlier).
Sashi |
|
| Back to top |
|
|
Rob Verschoor
*nix forums addict
Joined: 19 May 2005
Posts: 75
|
| Posted: Tue Jul 11, 2006 10:37 am Post subject:
Re: Get servername and port
|
|
|
"Sashi" <smalladi@gmail.com> wrote in message
news:1152281088.411692.142740@m79g2000cwm.googlegroups.com...
| Quote: | Hi, I'm connected to a DB server via a command prompt. I'm not sure how
this comand prompt is set up and I'm trying to figure out a way of
getting the (fully qualified) server name (or address) and the port
thru which I'm connected so that I can use this info to use a more user
friendly GUI to connect to the same DB.
Is this possible?
Thanks,
Sashi
|
select * from master..syslisteners
Rob V.
-------------------------------------------------------------
Rob Verschoor
Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase
Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase Replication Server Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"
mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
------------------------------------------------------------- |
|
| Back to top |
|
|
Sashi
*nix forums addict
Joined: 14 Jun 2005
Posts: 95
|
| Posted: Tue Jul 11, 2006 1:03 pm Post subject:
Re: Get servername and port
|
|
|
Rob Verschoor wrote:
| Quote: | "Sashi" <smalladi@gmail.com> wrote in message
news:1152281088.411692.142740@m79g2000cwm.googlegroups.com...
Hi, I'm connected to a DB server via a command prompt. I'm not sure how
this comand prompt is set up and I'm trying to figure out a way of
getting the (fully qualified) server name (or address) and the port
thru which I'm connected so that I can use this info to use a more user
friendly GUI to connect to the same DB.
Is this possible?
Thanks,
Sashi
select * from master..syslisteners
Rob V.
-------------------------------------------------------------
Rob Verschoor
Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase
Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase Replication Server Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"
mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------
|
$ select * from master..syslisteners
Msg 10330, Level 14, State 1:
Server 'server_name', Line 1:
SELECT permission denied on object syslisteners, database master, owner
dbo.
Oh, well, thanks for the tip anyway.
Sashi |
|
| Back to top |
|
|
Rob Verschoor
*nix forums addict
Joined: 19 May 2005
Posts: 75
|
| Posted: Tue Jul 11, 2006 10:23 pm Post subject:
Re: Get servername and port
|
|
|
It seems you're connected to the ASE server with a non-priviliged account...
Assuming you're connecting from a Windows system, check out the SQL.INI file
in directory %SYBASE%\ini (this is the defualt location). This file contains
the hostname/port number of the ASE server you're conecting to. Otherwise,
try 'netstat -a' to see if you can figure out the host +port number you're
connecting to.
Rob V.
"Sashi" <smalladi@gmail.com> wrote in message
news:1152623032.927682.290530@p79g2000cwp.googlegroups.com...
| Quote: |
Rob Verschoor wrote:
"Sashi" <smalladi@gmail.com> wrote in message
news:1152281088.411692.142740@m79g2000cwm.googlegroups.com...
Hi, I'm connected to a DB server via a command prompt. I'm not sure
how
this comand prompt is set up and I'm trying to figure out a way of
getting the (fully qualified) server name (or address) and the port
thru which I'm connected so that I can use this info to use a more
user
friendly GUI to connect to the same DB.
Is this possible?
Thanks,
Sashi
select * from master..syslisteners
Rob V.
-------------------------------------------------------------
Rob Verschoor
Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase
Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase Replication Server Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"
mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------
$ select * from master..syslisteners
Msg 10330, Level 14, State 1:
Server 'server_name', Line 1:
SELECT permission denied on object syslisteners, database master, owner
dbo.
Oh, well, thanks for the tip anyway.
Sashi
|
|
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Sun Nov 23, 2008 11:11 am | All times are GMT
|
|
Web Advertising | Online Advertising | Credit Cards | Jorge Bucay | Mortgages
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Sybase
