PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: "Faux, David" <David dot Faux at uk dot fid-intl dot com>
Subject: RE: How to Specify hostname and port in the connection string
Date: Jul 16 2007 3:56PM

Try

dbi:DriverName:database=database_name;host=hostname;port=port

:)
David Faux
Retail Administration Systems (RAS) Development
Int. 8-723-7913
Ext: +44 1732 777913
XH26

Important: Fidelity Investments International (Reg. No.1448245),
Fidelity Investment Services Limited (Reg. No. 2016555), Fidelity
Pensions Management (Reg. No. 2015142) and Financial Administration
Services Limited (Reg. No. 1629709, a Fidelity Group company) are all
registered in England and Wales, are authorised and regulated in the UK
by the Financial Services Authority and have their registered offices at
Oakhill House, 130 Tonbridge Road, Hildenborough, Tonbridge, Kent TN11
9DZ. Tel 01732 361144. Fidelity only gives information on products and
does not give investment advice to private clients based on individual
circumstances. Any comments or statements made are not necessarily those
of Fidelity. The information transmitted is intended only for the person
or entity to which it is addressed and may contain confidential and/or
privileged material. If you received this in error, please contact the
sender and delete the material from any computer. All e-mails sent from
or to Fidelity may be subject to our monitoring procedures. Direct link
to Fidelity's website -
http://www.fidelity-international.com/world/index.html 

 

-----Original Message-----
From: owner-sybperl-l@peppler.org [mailto:owner-sybperl-l@peppler.org]
On Behalf Of Lenga, Yair 
Sent: 16 July 2007 16:49
To: sybperl-l@peppler.org
Subject: How to Specify hostname and port in the connection string

 
Hi,

Does anyone know if there is a way to specify the hostname and port
number in the connection string. E.g.
"dbi:sybase:hostaddr=1.2.3.4:port=1234", instead of using a static
interface file.

I'm writing a program which need to access arbitrary database server.
The other alternative that I can think about is to create a temporary
interface file with the correct parameters, and then use it for the
connection string
"dbi:sybase:interfaces=/tmp/interfaces:server=myserver".

Thanks
Yair Lenga