freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "Mark Larsen" <larsenmtl AT gmail.com>
- To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
- Subject: [freetds] Multiple SQL Instances On One Server
- Date: Wed, 25 Oct 2006 10:56:45 -0400
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] Multiple SQL Instances On One Server,
Mark Larsen, 10/25/2006
- <Possible follow-up(s)>
-
Re: [freetds] Multiple SQL Instances On One Server,
Thompson, Bill D (London), 10/25/2006
- Re: [freetds] Multiple SQL Instances On One Server, Mark Larsen, 10/25/2006
-
Re: [freetds] Multiple SQL Instances On One Server,
Thompson, Bill D (London), 10/25/2006
- Re: [freetds] Multiple SQL Instances On One Server, Konrad J Hambrick, 10/25/2006
-
Re: [freetds] Multiple SQL Instances On One Server,
Lowden, James K, 10/25/2006
- Re: [freetds] Multiple SQL Instances On One Server, Mark Larsen, 10/25/2006
Archive powered by MHonArc 2.6.24.