Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: pass (herse.apache.org: domain of wstomlin@gmail.com designates
 209.85.132.245 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
        b=NGVbiaMCaWj1uLzfqnoIod297F16xgWeET49rJarEe+yg0kA3ZiiWyHTBRZNEqwEu4ZX5trynGzGOTJcsEBJyvrrwuDZiadxhnUKM/LsJQuuffO4XGJ7kseol/X0mry5NcLdACR/2bs3CgSCGWWn0h2fIq+7dnsaueVkpT34AYA=
Message-ID: <6e685a0c0701191154mae5d579ra4f90448889a219d@mail.gmail.com>
Date: Fri, 19 Jan 2007 14:54:10 -0500
From: "Bill Tomlinson" <wstomlin@gmail.com>
To: torque-user@db.apache.org
Subject: Is SQL Server 2005 supported in Torque?
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I've read the faqs and docs, but I can't find a page where the 2005
version of SQL server is explicitly mentioned.

Short question: is SQL Server 2005 supported, and if so, what driver do I use?

Long details:

We have an older application using an older version of Torque and the
2000 version of SQL Server and using an older version of the SQL
Server JDBC driver from Microsoft. For various reasons we want to
switch to 2005.

I changed the connection url to the new database server (with 2005)
and I got this error which, to be honest, doesn't mean much to me:

FATAL ERROR: Problem connecting with database.([Microsoft][SQLServer JDBC Driver
][SQLServer]The incoming tabular data stream (TDS) remote procedure call (RPC) p
rotocol stream is incorrect. Parameter 1 (""): Data type 0x38 is unknown.)

So it's either our application, torque, or the quite old jdbc driver.

On the assumption that it is the jdbc driver, I downloaded the latest
SQL server jdbc driver from Microsoft and tried to run that. But I got
this error:

FATAL ERROR: Problem connecting with database.(Unknown JDBC driver: com.microsof
t.sqlserver.jdbc.SQLServerDriver: Check your configuration file)

Which I understand to mean that the driver isn't one that Torque
supports (Microsoft changed the package for the driver from the older
driver).

I checked the source code for DBFactory, and the trunk HEAD version
doesn't have this driver either. So am I correct that even the latest
version of Torque doesn't support the latest MS jdbc drivers?

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org