connecting to MSSQL 2005

Jeremy Kister <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
I'm having a difficult time connecting to a mssql 2005 server.

solaris 10u5 sparc
freetds-0.82, hacked*
DBD::Sybase 1.09
perl 5.8.8
DBI 1.607
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
  Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)


*hacked = I had to modify cspublic.h for DBD::Sybase to compile.  I'm only 
assuming it was the right thing to do:
--- freetds-0.82.orig/include/cspublic.h        2007-06-25 
05:48:20.000000000 -0400
+++ freetds-0.82/include/cspublic.h     2008-09-06 02:21:13.683192000 -0400
@@ -446,7 +446,10 @@
  #define CS_VERSION_150 15000

  #define BLK_VERSION_100 CS_VERSION_100
-#define BLK_VERSION_110 CS_VERSION_100
+#define BLK_VERSION_110 CS_VERSION_110
+#define BLK_VERSION_120 CS_VERSION_120
+#define BLK_VERSION_125 CS_VERSION_125
+#define BLK_VERSION_150 CS_VERSION_150

  #define CS_FORCE_EXIT  300
  #define CS_FORCE_CLOSE  301

---

With this setup, I can connect to a mssql 2000 server.  But when I try to 
connect to a mssql 2005 server, i get an error:
DBI connect('server=server;database=db1','user',...) failed: OpenClient 
message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (41)
Server server, database
Message String: Unable to connect: Adaptive Server is unavailable or does 
not exist
  at tc.pl line 13


i tried using a different tdsver, but that didnt seem to work, and doesnt 
make sense anyway, since i can connect to mssql 2000.

any clues what I should look at?

--

Jeremy Kister
http://jeremy.kister.net./
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.