Skip to Content.
Sympa Menu

freetds - Re: jdbc + SQLServer 7 + Exception + DB-Library ??

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT umcc.ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: jdbc + SQLServer 7 + Exception + DB-Library ??
  • Date: Mon, 10 Apr 2000 07:46:20 -0400 (EDT)




On Mon, 10 Apr 2000, Stefanos Karasavvidis wrote:

> Thanks for this. Indeed the error does not occur when I don't select ntext
> fields. There
> is no problem with nvarchar or nchar fields, so I suppose that only the
> ntext fields
> have this problem.
nvarchar are automatically converted to varchar and truncated (if necessary)
when SQL Server is talking TDS 4.2

>
> My problem is that I have to use these kind of fileds, so I would
> appreciate if someone
> could tell me if there is some schedule to support this.
>
It's in the C libs but I can't speak for the JDBC stuff.

> Thanks
>
> Stefanos
>
> Brian Bruns wrote:
>
> > This most likely means that fields of type "ntext" can not be sent to
> > clients
> > using TDS 4.2 (which dblib would be).
> >
> > Brian
> >
> > On Sat, 8 Apr 2000, Stefanos Karasavvidis wrote:
> >
> > > Trying to use the jdbc driver. I've compiled the snapshot from 31st
> > > March with JDK1.2.2.
> > > The OS is Windows 2000 and the DBMS SQL Server7 with SP2
> > >
> > > My URL is
> > >
> > > jdbc:freetds:sqlserver://xxx.xxx.xxx.xxx/cretantournet
> > >
> > > The Statement.executeQuery() throws a SQLException with following
> > > message
> > >
> > > ntext data cannot be sent to clients using DB-Library (such as ISQL) or
> > > ODBC version 3.7 or earlier.
> > >
> > > Can anyone tell me what this means??
> > >
> > > Stefanos
> > >
> > > --
> > > ======================================================================
> > > Stefanos Karasavvidis
> > > Electronics & Computer Engineer
> > > e-mail : stefos AT multimedia-sa.gr
> > >
> > > Multimedia Systems Center S.A.
> > > Kissamou 178
> > > 73100 Chania - Crete - Hellas
> > > http://www.multimedia-sa.gr
> > >
> > > Tel : +30 821 88447
> > > Fax : +30 821 88427
> > >
> > >
> > >
> ======================================================================
> Stefanos Karasavvidis
> Electronics & Computer Engineer
> e-mail : stefos AT multimedia-sa.gr
>
> Multimedia Systems Center S.A.
> Kissamou 178
> 73100 Chania - Crete - Hellas
> http://www.multimedia-sa.gr
>
> Tel : +30 821 88447
> Fax : +30 821 88427
>





Archive powered by MHonArc 2.6.24.

Top of Page