dbTalk Databases Forums  

Sybase server connection as SOLARIS server and Port address

comp.databases.sybase comp.databases.sybase


Discuss Sybase server connection as SOLARIS server and Port address in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
durga
 
Posts: n/a

Default Sybase server connection as SOLARIS server and Port address - 04-23-2004 , 11:00 AM






Hi,

In general we connect to Sybase server by using it's alias name like
shown below.
dblogin('dbuser','dbpassword', 'SYBASE_SERVER');

But is there any to connect using underlying host (place where SYBASE
server resides) and port number as shown below?

dblogin('dbuser','dbpassword', '100.100.100.100:1400');


Thanks
-Durga

Reply With Quote
  #2  
Old   
Michael Peppler
 
Posts: n/a

Default Re: Sybase server connection as SOLARIS server and Port address - 04-23-2004 , 01:07 PM






On Fri, 23 Apr 2004 09:00:32 -0700, durga wrote:

Quote:
Hi,

In general we connect to Sybase server by using it's alias name like shown
below.
dblogin('dbuser','dbpassword', 'SYBASE_SERVER');

But is there any to connect using underlying host (place where SYBASE
server resides) and port number as shown below?

dblogin('dbuser','dbpassword', '100.100.100.100:1400');
No, not with DB_library.

Recent CT-Library apps (12.5.1, I think) can use this format (I forget the
exact name of the property you need to set.)

The work-around would be to create a temporary interfaces file, and then
use dbsetifile() to use that interfaces file to connect.

BTW - this looks like you're using perl, because in C you'd use dbopen()
(dblogin() only returns a new LOGINREC).

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html



Reply With Quote
  #3  
Old   
durga
 
Posts: n/a

Default Re: Sybase server connection as SOLARIS server and Port address - 04-23-2004 , 10:28 PM



Michael Peppler <mpeppler (AT) peppler (DOT) org> wrote

Quote:
On Fri, 23 Apr 2004 09:00:32 -0700, durga wrote:

Hi,

In general we connect to Sybase server by using it's alias name like shown
below.
dblogin('dbuser','dbpassword', 'SYBASE_SERVER');

But is there any to connect using underlying host (place where SYBASE
server resides) and port number as shown below?

dblogin('dbuser','dbpassword', '100.100.100.100:1400');

No, not with DB_library.

Recent CT-Library apps (12.5.1, I think) can use this format (I forget the
exact name of the property you need to set.)

The work-around would be to create a temporary interfaces file, and then
use dbsetifile() to use that interfaces file to connect.

BTW - this looks like you're using perl, because in C you'd use dbopen()
(dblogin() only returns a new LOGINREC).

Michael
Thanks Mike. You are right. I am using perl.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.