BTW, Merant published a patch for this bug (TDS_SMALLDATETIME).
You should search their knowledgebase (support.merant.com) for "Document ID
= 29158"
Nonetheless they require authorization to download applicable patch.
Subject:
[MERANT][SQLServer JDBC Driver]Unhandled data type: TDS_datatype
Analysis:
When issuing SELECT stmts, where the datatype is either MONEY,
SMALLDATETIME, or SMALLMONEY, I get the error above.
Note: This issue only occurs if the column with the datatype of MONEY,
SMALLDATETIME, or SMALLMONEY does not allow NULL values.
Solution:
Connect JDBC 2.0 SQL Server patch:
To install the patch on Windows 32-bit:
1) Place the file into a temporary directory on your Unix machine.
2) Navigate to that directory and run the setup executable.
To install the patch on Unix or Linux:
1) Place the file into a temporary directory on your Unix machine.
2) Change to your ODBC_HOME directory.
3) Untar the files.
Example: tar -xvf /home/guest/tmp/200UNIX.tar
Patch or Update for DataDirect, Connect JDBC, version 2.0.00
----- Original Message -----
From: "Mike Viens" <[EMAIL PROTECTED]>
To: "JRun-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 17, 2001 2:42 AM
Subject: RE: JRun JDBC drivers
> I have been using the JDBC drivers with JRun for SQLServer and have
> significant problems with them. I am working with a guy at Allaire to
> resolve the issues, but it is really tough when he is unable to reproduce
> any of the issues. The errors I am getting are:
>
> 1) When querying a field that contains extended ASCII (128-255), the
> character(s) are returned as ?
> 2) Unable to select a field of type SMALLDATETIME. The driver reports
that
> is can not handle this type even though the documentation says it can.
>
> If anyone has seen this, and/or knows a fix for it, please contact me.
>
> Mike Viens
>
> -----Original Message-----
> From: Vitaly Shorin [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 16, 2001 3:30 PM
> To: JRun-Talk
> Subject: JRun JDBC drivers
>
>
> Hi,
> does anybody use JDBC drivers shipped with JRun (AE/EE)?
> Do you have any problems with them?
>
> regards,
> Vitalik.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
