Re: Difficulty Connecting to MS-SQL server in Linux

I believe you are trying to connect to what is known as a named instance. This was recently added to FreeTDS (supported by FreeTDS in the current release, I think). If you don't have the latest version of FreeTDS you should probably upgrade (or ask on the FreeTDS mailing list.)

Michael

Comment on Re: Difficulty Connecting to MS-SQL server in Linux

Replies are listed 'Best First'.
Re^2: Difficulty Connecting to MS-SQL server in Linux by MegaVoice (Novice) on Jul 16, 2007 at 14:43 UTC
Michael, I am running the latest stable version of FreeTDS (0.64) and submitted a question to their mailing list. I might be able to connect via ODBC, but I remain hopeful that the FreeTDS mailing list might have some insight. Thank you, Sean	[reply]
Re^3: Difficulty Connecting to MS-SQL server in Linux by MegaVoice (Novice) on Jul 16, 2007 at 17:58 UTC
Got it! I had the host that the server resided on. I was able to update the connection string to the following: my $dbh=DBI->connect("DBI:Sybase:host=<hostname>;port=2832",$user,$password); Since the hostname didn't have a slash in it, I was able to use the port that the server was using. I was able to connect so that I can continue testing. I appreciated the comments!	[reply]