Re: sql2005 & freetds connection probs

"Dan Wierenga" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <24CF2B9B9D2BCC4B8F6EA9528B63C8360A20A59B@LA-EXCLUST01.corp.valueclick.com>

> -----Original Message-----
> From: [email protected] [mailto:freetds-
> [email protected]] On Behalf Of S Willms
> 
> My goal is to access a MS sql2005 DB from linux through perl using
> dbd::sybase module.  I've installed freetds v 0.64...is it compatible
> w/2005?  I wasn't able to find much documentation that refers to
> sql2005 specifically, but i was able to find one source that says it
> should work.  Is this right? 

I can confirm that 0.64 and DBD::Sybase (1.105) can indeed connect to a
Sql2005 server.


> 10:23:19.731219 26609 (net.c:168):Connecting to 192.168.2.57 port
1433.
> 10:23:19.731749 26609 (net.c:256):connect error: Connection refused

That seems like it's not the right IP or it's not really listening on
port 1433.  I'd try using the full host name and the instance name
instead of the port name.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.