Skip to Content.
Sympa Menu

freetds - [freetds] Named Instances

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Patrick Corbett" <pcorbe81 AT maine.edu>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Named Instances
  • Date: Mon, 17 Dec 2007 16:39:01 -0700

I have a setup of SQL Server 2000 on IIS/2003 Server. I'd like to connect to
the database using the FreeTDS driver, but I am having trouble connecting to
my database using a named instance. Is it possible to connect via a named
instance? I'm not exactly sure what my host needs to be so I just set it to
the IP address of the server "abc." I've tried commenting the host line
along with several other combinations (instance = def, host = abc.xxxxx.com,
etc.), but no luck so far - I keep getting error message similar to those
below.

I don't have the rights to change the server to run on anything other than a
named instance.

My current freetds.conf file looks like:

------
[abc\def]
host = 204.228.89.23:1433
instance = abc\def
port = 1433
client charset = UTF-8
tds version = 8.0
text size = 20971520
dump file append = yes
dump file = C:\Inetpub\wwwroot\freetds.log
------


My Dump File (identifying information changed for security purposes):

-----
dblib.c:3593:dbsetlogintime(5)
dblib.c:3574:dbsettime(60)
dblib.c:413:dblogin(void)
dblib.c:4535:dberrhandle(024D1090)
dblib.c:4553:dbmsghandle(024D10E0)
dblib.c:459:dbsetlname(02047B40, xxxxxx, 2)
dblib.c:459:dbsetlname(02047B40, xxxxxxxx, 3)
dblib.c:459:dbsetlname(02047B40, PHP 5, 5)
dblib.c:812:dbopen(02047B40, bor\gen, [microsoft])
dblib.c:268:dblib_get_tds_ctx(void)
config.c:166:Getting connection information for [abc\def].
config.c:170:Attempting to read conf files.
config.c:304:... $FREETDSCONF not set. Trying $FREETDS/etc.
config.c:317:... $FREETDS not set. Trying $HOME.
config.c:327:... Error getting ~/.freetds.conf. Trying c:\freetds.conf.
config.c:247:Found conf file 'c:\freetds.conf' (default).
config.c:375:Looking for section global.
config.c:432: Found section abc\def.
config.c:446: Reached EOF
config.c:375:Looking for section abc\def.
config.c:432: Found section abc\def.
config.c:435:Got a match.
config.c:456: host = 'xxx.xxx.xx.xxx:1433'
config.c:485:Found host entry xxx.xxx.xx.xx:1433.
config.c:488:IP addr is .
config.c:456: instance = 'abc\def'
config.c:456: port = '1433'
config.c:456: client charset = 'UTF-8'
config.c:502:tds_config_login: client charset is UTF-8.
config.c:456: tds version = '8.0'
config.c:456: text size = '20971520'
config.c:456: dump file append = 'yes'
config.c:456: dump file = 'C:\Inetpub\wwwroot\freetds.log'
config.c:446: Reached EOF
config.c:251:Success: [abc\def] defined in c:\freetds.conf.
iconv.c:361:iconv to convert client-side data to the "UTF-8" character set
iconv.c:514:tds_iconv_info_init: converting "UTF-8"->"UCS-2LE"
iconv.c:514:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
login.c:226:IP address pointer is empty
login.c:228:Server abc not found!
dblib.c:1105:dbclose(02047A30)
dblib.c:253:dblib_del_connection(025048A8, 02048230)
mem.c:565:tds_free_all_results()
dblib.c:294:dblib_release_tds_ctx(1)
dblib.c:5426:dbfreebuf(02047A30)
dblib.c:438:dbloginfree(02047B40)
-----




Archive powered by MHonArc 2.6.24.

Top of Page