http://forums.hotjoe.com/posts/list/28.page JForum - http://www.jforum.net http://forums.hotjoe.com/posts/preList/31/77.page http://forums.hotjoe.com/posts/preList/31/77.page GMT
Also, can you run jisql with the -driverinfo command line argument? I'd like to be able to test with the same versions that you're using.

Thanks for reporting this!]]> http://forums.hotjoe.com/posts/preList/31/250.page http://forums.hotjoe.com/posts/preList/31/250.page GMT
create table tblLenTest ( mycol varchar (50))
GO
insert into tblLenTest(mycol) values('This is a string which is longer than 24 chars')
GO

Then, executing:
java -classpath /Users/leon/Desktop/Download/jisql/lib/jisql.jar:/Users/leon/cvs/_shared/_Java/mssql/mssqlserver.jar:/Users/leon/cvs/_shared/_Java/mssql/msbase.jar:/Users/leon/cvs/_shared/_Java/mssql/msutil.jar com.xigole.util.sql.Jisql -driver mssql -user XXX -password XXX -c \; -cstring jdbc:microsoft:sqlserver://XXX:1433;databaseName=master


and entering:
1 > select * from tblLenTest;

results in:
mycol |
-------------------------|
This is a string which i |


Driver Info:

driver.getMajorVersion() is 2
driver.getMinorVersion() is 2
driver is JDBC compliant
driver property named "netAddress"
description: "Workstation's network interface card address"
required parameter?: "false"
current value: "000000000000"

driver property named "portNumber"
description: "Port number"
required parameter?: "false"
current value: "1433"

driver property named "hostProcess"
description: "Workstation process ID number"
required parameter?: "false"
current value: "0"

driver property named "user"
description: "Login ID"
required parameter?: "true"
current value: ""

driver property named "sendStringParametersAsUnicode"
choices:
choice 0: "false"
choice 1: "true"
description: "Send UCS2 String Parameters As Unicode"
required parameter?: "false"
current value: "true"

driver property named "databaseName"
description: "Database name"
required parameter?: "false"
current value: ""

driver property named "programName"
description: "Name of the application program"
required parameter?: "false"
current value: ""

driver property named "serverName"
description: "Server name"
required parameter?: "true"
current value: ""

driver property named "selectMethod"
choices:
choice 0: "cursor"
choice 1: "direct"
description: "Select Method"
required parameter?: "false"
current value: "direct"

driver property named "WSID"
description: "Workstation's ID"
required parameter?: "false"
current value: ""

driver property named "password"
description: "Login Password"
required parameter?: "true"
current value: ""

metaData.getDatabaseProductName(): "Microsoft SQL Server"
metaData.getDatabaseProductVersion(): "Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 1)
"
metaData.getDriverName(): "SQLServer"
metaData.getDriverVersion(): "2.2.0029"]]> http://forums.hotjoe.com/posts/preList/31/251.page http://forums.hotjoe.com/posts/preList/31/251.page GMT http://forums.hotjoe.com/posts/preList/31/257.page http://forums.hotjoe.com/posts/preList/31/257.page GMT http://forums.hotjoe.com/posts/preList/31/261.page http://forums.hotjoe.com/posts/preList/31/261.page GMT http://forums.hotjoe.com/posts/preList/31/262.page http://forums.hotjoe.com/posts/preList/31/262.page GMT http://forums.hotjoe.com/posts/preList/31/264.page http://forums.hotjoe.com/posts/preList/31/264.page GMT