FreeTDS Development Group

["Middleton, Eric" <eric.middleton AT oncologysupply.com>]

Ok I think I may be past this problem but I could be wrong.  I have my
linux server connecting to one sybase9 server.  However I cannot get
more than one connection to Sybase at one time.  I need 9 of them.  The
problem lies with the server name in the odbc.ini file. It is using this
as the database name and not the server name and since all 9 databases
are named the same you can only connect to one of them at the time.

Thanks,
Eric Middleton
Oncology Supply Automation
Cell: 334-790-7587
-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Dan Wierenga
Sent: Wednesday, January 16, 2008 4:45 PM
To: FreeTDS Development Group
Subject: Re: [freetds] Sybase ASA 9, unixODBC multiple connection
problem

You should be able to set the TDSHOST environment variable to override
the actual host in the freetds.conf entry.  So, you'd set that 9 times,
once before each connection is made.  See
http://freetds.org/userguide/envvar.htm

It's ugly but it should work.  Maybe Frediano or JKL has a more elegant
solution though..

> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org [mailto:freetds-
> bounces AT lists.ibiblio.org] On Behalf Of Middleton, Eric
> Sent: Wednesday, January 16, 2008 2:13 PM
> To: FreeTDS Development Group
> Subject: Re: [freetds] Sybase ASA 9, unixODBC multiple connection
> problem
> 
> Ok you lost me.  My problem is I need to know how to set up my linux
> box
> to have 9 different odbc connections to 9 different Sybase 9 servers.
> 
> Thanks,
> Eric Middleton
> Oncology Supply Automation
> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Dann Corbit
> Sent: Wednesday, January 16, 2008 4:07 PM
> To: FreeTDS Development Group
> Subject: Re: [freetds] Sybase ASA 9, unixODBC multiple connection
> problem
> 
> > -----Original Message-----
> > From: freetds-bounces AT lists.ibiblio.org [mailto:freetds-
> > bounces AT lists.ibiblio.org] On Behalf Of Middleton, Eric
> > Sent: Wednesday, January 16, 2008 1:27 PM
> > To: freetds AT lists.ibiblio.org
> > Subject: [freetds] Sybase ASA 9, unixODBC multiple connection
problem
> >
> > I am using centos5 and with unixODBC and FreeTDS installed.
> >
> > I have to problem connecting to a single Sybase server however I
need
> to
> > be able to connect to 9 of them.
> >
> > They are Sybase version 9 and it seems in the odbc.ini that if the
> > server name in the config is not the name of the actual database
file
> > then the connection does not work.  Well this is a problem because
> all
> 9
> > servers have a database that is the same.  So the only difference is
> the
> > IP.  However since the ip is in the freeTDS.conf file then I can
only
> > connect to the first server in the .conf file.  Does anyone know a
> work
> > around for this?  Here is my config files.
> > Odbc.ini
> > [mydsn2]
> > Description = blah
> > Driver = TDS
> > Servername = central
> > UID = user
> > PWD = pass
> > Port = 2638
> >
> > Freetds.conf
> > [central]
> >         host = serverip
> >         port = 2638
> >         tds version = 4.2
> >
> > this works because central is the name of the database. But like I
> said
> > I need to connect to 9 of these not just one.  Any help would be
> greatly
> > appreciated.
> 
> I am not sure if I understand your problem, but have you tried
creating
> nine different Sybase data sources and nine different connections?
> (E.g.
> name them after the servers)
> 
> I have no difficulty creating multiple connections to the same or to
> different databases (caveat: we did find that multiple simultaneous
> queries to the same database require different connections -- you
can't
> multiplex queries on the same connection).
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 
> CONFIDENTIALITY NOTICE.  This electronic mail transmission may contain
> privileged and/or confidential
> information and is intended only for the review of the party to whom
it
> is addressed.   If you have
> received this transmission in error, please immediately return it to
> the sender, delete it  and destroy
> it without reading it.  Unintended transmission shall not constitute
> the waiver of the attorney-client
> or any other privilege.
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

CONFIDENTIALITY NOTICE.  This electronic mail transmission may contain 
privileged and/or confidential
information and is intended only for the review of the party to whom it is 
addressed.   If you have 
received this transmission in error, please immediately return it to the 
sender, delete it  and destroy 
it without reading it.  Unintended transmission shall not constitute the 
waiver of the attorney-client 
or any other privilege.