I try to access INTs and VARCHARs
Vitalik.
----- Original Message -----
From: "Matthew L. Wright" <[EMAIL PROTECTED]>
To: "JRun-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 17, 2001 12:45 PM
Subject: Re: JRun JDBC drivers
> What sort of field are you accessing. Not a BLOB, CLOB or LONG field is
it?
>
> Matt
>
>
> Matthew L. Wright
> Java Internet Programmer
> Jupiter One
> Web World Studios West Coast
> www.jupiterone.com
> (818) 763-2927
> ----- Original Message -----
> From: "Mike Viens" <[EMAIL PROTECTED]>
> To: "JRun-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, April 16, 2001 4:53 PM
> Subject: RE: JRun JDBC drivers
>
>
> > I can successfully using JDBC-ODBC to access my extended ASCII strings,
> but
> > just not via the JRun JDBC drivers. No, I have not tried contacting
> Merant
> > yet. I was planning on downloading their trial version drivers and plug
> > them into JRun and see what happens.
> >
> > Mike Viens
> > Lead Java Developer
> > iConvention, Inc.
> > http://www.iconvention.com
> > Extraordinary results through unconventional means!
> >
> >
> > -----Original Message-----
> > From: Vitaly Shorin [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, April 16, 2001 4:36 PM
> > To: JRun-Talk
> > Subject: Re: JRun JDBC drivers
> >
> >
> > 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
