[freetds] Multiple SQL Instances On One Server

Mark Larsen larsenmtl at gmail.com
Wed Oct 25 10:56:45 EDT 2006


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


More information about the FreeTDS mailing list