sybperl-l Archive

From: "Faux, David" <David dot Faux at uk dot fid-intl dot com>
Subject: DBD::Sybase 1.08 - xblk.t minor bug
Date: Jul 23 2007 4:04PM

 Hi

I think there may be a minor bug in t/xblk.t -- line 385, the select
doesn't cater for the server having both languages and charsets
configured and get's confused when they are:

I think it should read:

    $sth = $dbh->prepare("select name from master..syscharsets where id
= $id and type < 2000");

:)
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: Faux, David 
Sent: 16 July 2007 16:57
To: 'Lenga, Yair '; sybperl-l@peppler.org
Subject: RE: How to Specify hostname and port in the connection string

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