Skip to Content.
Sympa Menu

freetds - Re: [freetds] Multiple SQL Instances On One Server

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Multiple SQL Instances On One Server
  • Date: Wed, 25 Oct 2006 15:58:21 +0100

and what entries do you have in freetds.conf ?

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Mark Larsen
Sent: 25 October 2006 15:57
To: FreeTDS Development Group
Subject: [freetds] Multiple SQL Instances On One Server


List Members,

We use FreeTDS and unixODBC to talk to a SQL Server 2000 running on a
Windows Server 2003. This paticular server has three sql server
instances running; SERVERNAME, SERVERNAME\TEST, SERVERNAME\ARCHIVE. I
can get a connection using just SERVERNAME, but if I try to connect to
either the TEST or ARCHIVE instances, isql returns

[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[ISQL]ERROR: Could not SQLConnect

The sql.log isn't much more helpful. The TDSDump indicates that if I
use in my odbc.ini

[DSN_Test]
...
Server = SERVERNAME\TEST
...

It can't find the server, no IP address (makes sense). If I switch it
to
[DSN_Test]
...
Database = TEST\DATABASENAME
...
It can't find the database.

We are using versions:
FreeTDS 0.62.3
unixODBC-2.2.6

Anyone have any ideas?

Thanks,
Mark
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the
sender, delete it and do not read, act upon, print, disclose, copy, retain or
redistribute it. Click here for important additional terms relating to this
e-mail. http://www.ml.com/email_terms/
--------------------------------------------------------




Archive powered by MHonArc 2.6.24.

Top of Page