I have another problem with this drivers. It seems to me driver change the
position of ')'- right parenthesis - and places it at the end of the SQL
query string. Therefore, query like
"if exists(select * from MyDB) select begin res=1 end else begin select
res=0 end"
after processing by driver sent to SQL Server as
"if exists(select * from MyDB select begin res=1 end else begin select res=0
end)"
and SQL Server obviously returns error.
Did you try to get help directly from Merant? I tried to register at their
support forum, but website asked me for serial number, and I was not sure
they expected JRun's serial number (in any case, I can't obtain JRun's
serial from my hosting provider).
As for your errors, I've reproduced error with TDS_SMALLDATETIME
java.sql.SQLException: [Allaire JRun][SQLServer JDBC Driver]Unhandled data
type: TDS_SMALLDATETIME
when I used column name containing Alt ASCII symbols, I was unable to
retrieve values even with JDBC-ODBC bridge (I've got column values by col
number, not col name...)
Vitalik.
----- 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
