vserver problem

[Robert Nichols]

Ivan,

Thanks for your response.

I am using v4rb 2.5.10. Perhaps the problem is vserver 2.5.10? This  
code worked with much earlier versions - vserver 2.0 and also when I  
tested with 2.5.6. When I said the SQL search worked with Studio,  
that is when I open the database as a local file. I can't seem to get  
Studio to connect to vserver (ERROR 0x82514: Received packet's  
version is inconsistent. ). Is Studio 3.0 able to connect to server  
2.5.10?

Whole project is large with a lot of dependencies. Snippet follow:


  START CODE
   d = new cDate

   d.month = d.month-3
   ds = "slips.flddate > '" + d.shortdate + "' "


   s = "select slips.flddate,projects.fullname,exptypes.shortname, "
   s = s + "slips.description,slips.rate,slips.duration,slips.recid "
   s = s + "from slips,exptypes,projects where exp = 1 and "
   s = s + ds
   s = s  + "order by flddate desc"

   cur = new cvCursor 
(s,evCursorLocation.kServerSide,evLockType.kNoLocks,evCursorDirection.kR 
andom)

  END CODE

Obviously this code, which I believe is clean, could be having  
trouble with the app's state established elsewhere, but I really  
believe I haven't changed anything significant since AI had it  
working with 2.5.6. I suspect v4rb or vserver

On May 16, 2007, at 6:57 PM, Robert Nichols wrote:


Begin forwarded message:
From: Ivan Smahin <IvanSmahin at public.kherson.ua>
Date: May 16, 2007 8:10:10 AM EDT
To: Valentina Developers <valentina at lists.macserve.net>
Subject: Re: vserver problem
Reply-To: Valentina Developers <valentina at lists.macserve.net>

Hello Robert,

Wednesday, May 16, 2007, 2:12:25 PM, you wrote:

RN> I'm using 2.5.10 office server and v4rb. I have a query that works
RN> fine in Studio, but chokes in my application environment. The
RN> exception indicates error number 394504, with no description.

<SQLSTATE name="60508">
<DESCRIPTION>ERR_STREAM_EOF</DESCRIPTION>
<MESSAGE>Stream EOF reached.</MESSAGE>
</SQLSTATE>

Seems, client has been disconnected. It could be a various reasons.


RN> As I
RN> said, Valentina Studio has no problem with the query. The query also
RN> worked with earlier versions of vserver.

RN> How to troubleshoot?

That is strange. What V4RB version do you use?
Could  I  take  a  look  at  that  problematic  code snippet (or whole
project)?

Commonly  I  would say: if it works with VStudio then something is wrong
with your project or V4RB self.

-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina

________________________________________________________________________ 
_____

robert nichols

formwork design llc
114 3rd st ne | charlottesville, va 22902 | 434.296.2223 |  
www.formworkdesign.com




________________________________________________________________________ 
_____

robert nichols

formwork design llc | 114 3rd st ne | charlottesville, va 22902 |  
www.formworkdesign.com