> Newsgroups: comp.databases.sybase
> Subject: Re: ODBC Problem conn. to Sybase, TDS bufferlength too large
> Date: Sun, 05 Feb 95 09:16:23 PDT
> Organization: Alpha.net -- Milwaukee, WI
> Lines: 27
> NNTP-Posting-Host: umbriel.execpc.com
> Mime-Version: 1.0
> Content-Type: TEXT/PLAIN; charset=US-ASCII
> X-Newsreader: NEWTNews & Chameleon -- TCP/IP for MS Windows from NetManage
> > I have a problem using VB 3.0 and the Microsoft ODBC driver accessing the
> > Sybase database.
> > The error which occurs is "TDS bufferlength too large, query cancelled".
> > fun thing about it is if I use the same sql-statement with Access 2.0 and
> > same ODBC driver no problem occurs. The query just returns 2 records !
> > I can't find anything in the documentations. I am confident that anyone
> > has encountered the same problem and might help me.
> > can't read this newsgroup frequentely.
> > Thanks
> > Chris
> I ran into the same problem on my current project. I found that if I take the
> SQL statement I am sending (via ODBC SQLExecute?) and paste it into the
> program (SQL /L???) that it runs just fine. I think it may have to do with
> length of the string you are passing... Any more ideas??
> "Binary Poet"
I Ran into a strange ODBC problem that would not let me connect to my 4.9.2
server on AIX..if I tried to log in as a DBO...when I logged in as a regular
user..it all clears up. Go figure. :)