Since I hadn't heard back from anyone, I did some more research and playing
around and got the right combination and here are results:
For DSN-Less connection string that can be used with Informix Client-SDK 2.5
ODBC driver to connect using Perl (5.005_3) on Win32, DBI, DBD::ODBC (0.28)
1. Once the Informix Client-SDK has been installed, there is a Informix
Client-SDK utility called SetNet32 that has be run to set up the proper
Informix vars, such as host, server, service, etc. for a given
server/database and then that server has to be designated as the default
server.
2. Also make sure in your winXX/system32/drivers/etc/Services file, the
proper Informix service and port no./service are set up.
If the above is done then the following should work in order to connect to
Informix using DBI and ODBC without a DSN (
my $dsn ='driver={INFORMIX 3.32 32
BIT};host=host_name;srvr=server_name;serv=service_name;pro=olsoctsp;database
=database_name;uid=id;pwd=password;';
#
# protocol name above is olsoctcp, other protocols will work as long as
supported by network
#
$dbh = DBI->connect("dbi:ODBC:$dsn", { RaiseError => 1, AutoCommit => 1});
DSN...Leave home without it!
Alex Mitsuda @ NEUBERGER BERMAN
* [EMAIL PROTECTED] * 646-497-4181
@ SECOND FOUNDATION TECH., INC.
* [EMAIL PROTECTED] * 718-686-2870
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and delete
this e-mail from your system.
E-mail transmission cannot be guaranteed to be secure or error-free. The
sender therefore does not accept liability for any errors or omissions in
the contents of this message that arise as a result of e-mail transmission.
This message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities or
related financial instruments.
All e-mails at Neuberger Berman are, in accordance with Firm policy, to be
used for Neuberger Berman business purposes only. E-mails sent from or to
the Firm are subject to being reviewed by the Firm in accordance with the
Firm's procedure for the review of correspondence.
