Will LiveCode Server Side Scripting work with vServer?

Wed Mar 7 15:49:04 CST 2012

Hi Mike,

If you could please give specific details as to exactly what you did 
I can write a step-by-step guide with snap shots.

If you would be so kind as to 
please give exact .dll names and folder names 
that you got to work on whatever computer you have.

Please be sure to include the exact LiveCode script you got to work.

I'll change the pathnames etc. for my computer.

Thanks in advance.

Barry G. Sumpter
P.S.  If you would prefer to do this offline as to protect specific path,
file, db names 
you can email me at BarrySum at bigpond.net.au

------------------------------

Message: 2
Date: Wed, 7 Mar 2012 11:48:35 -0700
From: Mike Bonner <bonnmike at gmail.com>
To: Valentina Developers <valentina at lists.macserve.net>
Subject: Re: wILL LiceCode Server Side Scripting work with vServer
	Office 4	ulimited
Message-ID:
	<CAG1cpSojVtJdKjsANcTmT2h=3DywnJHwwtH6DTxU=gJA2Mrypw at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Holy cow, never mind. :) Was using valentina.init (which was in the very
first email I recieved after purchase of the adk.) and its apparently
valentina_init instead. And works!  Copied the dlls to the folder and viola'
so thx for pointing me to the answer.

On Wed, Mar 7, 2012 at 11:36 AM, Mike Bonner <bonnmike at gmail.com> wrote:

> K I give. If theres a way to get the v4rev external to load using 
> livecode server I don't know what it would be, but the odbc option is 
> still there and available for livecode server.
>
>
> On Wed, Mar 7, 2012 at 10:17 AM, Mike Bonner <bonnmike at gmail.com> wrote:
>
>> I'd be curious about this too. I know in the IDE there are 2 .dll 
>> files for the external that are set up using the v4rev installer so 
>> that the ide knows about them.  Any info on how livecode server loads 
>> its externals? I might just try copying the 2 dlls over to the 
>> externals folder for lc server and see what haps. /shrug Worst case it
doesnt work.
>>
>>
>> On Wed, Mar 7, 2012 at 9:47 AM, Bernard Devlin <bdrunrev at gmail.com>wrote:
>>
>>> On Wed, Mar 7, 2012 at 3:34 PM, Mike Bonner <bonnmike at gmail.com> wrote:
>>> > valentina used to be part of the revdb external (IDE) but seems to 
>>> > have disappeared despite still appearing as an option in the
documentation.
>>>
>>> It may no longer be bundled as part of the Livecode IDE, but V4REV 
>>> obtained from Paradigma still works.  I'm using it currently with 
>>> SQL Yoga (a Livecode database abstraction layer).
>>>
>>> I cannot see why V4REV would not work within Livecode server once 
>>> installed correctly on a server.  I would try connecting using V4REV 
>>> to a local database, and then once that is working, try connecting 
>>> to a Valentina Office Server.
>>>
>>> Bernard
>>> _______________________________________________
>>> Valentina mailing list
>>> Valentina at lists.macserve.net
>>> http://lists.macserve.net/mailman/listinfo/valentina
>>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.macserve.net/pipermail/valentina/attachments/20120307/eec5f3f9
/attachment-0001.html>

------------------------------

Message: 3
Date: Thu, 8 Mar 2012 07:26:59 +1100
From: "Barry G. Sumpter" <barrysum at bigpond.net.au>
To: <valentina at lists.macserve.net>
Subject: Shocked to find can't init valentina with LiveCode
Message-ID: <002201ccfca0$a644dec0$f2ce9c40$@bigpond.net.au>
Content-Type: text/plain;	charset="us-ascii"

Hi all,

I was absolutely convinced I had v4Rev working with vServer.
For some reason I can't get the sample apps to work for v4Rev.

Which of the vServer sample should I be testing first?
vServer
vServer_Bonjour
vServer_RegisterDB
vServer_ScheduledBackup
There is also an Install.rev

----

I've read thru all the install documents but can't seem to find anything
I've missed.

M:\Program Files\RunRev\LiveCode 4.6.4\Plugins\V4REV_4\Install.rev Valentina
4 Revolution Instalation shows this on clicking the Install
button:
----
M:/Documents and Settings/Barry/My Documents/My LiveCode/Externals/Database
Drivers/dbvalentina4.dll  already exists. Please trash it manually and run
this stack again. 
M:/Documents and Settings/Barry/My Documents/My LiveCode/Externals/v4rev.dll
already exists. Please trash it manually and run this stack again. 
Externals list already updated. 
Database Drivers list already updated. 
M:/Documents and Settings/Barry/My Documents/My
LiveCode/Runtime/Windows/x86-32/Externals/Database Drivers/dbvalentina4.dll
already exists. Please trash it manually and run this stack again. 
M:/Documents and Settings/Barry/My Documents/My
LiveCode/Runtime/Windows/x86-32/Externals/v4rev.dll
 already exists. Please trash it manually and run this stack again. 
Externals list already updated. 
Database Drivers list already updated.
----

I don't recall reading any install doco regarding this Install.rev app.

I thought there was a initValentina(x,y,z) command that was not executing.
But I'm now getting an error on the following when executing vServer/vServer
sample app:
----
local mDBRef
local mFldRef
local mConn
local mSrv

----------------------------------------------------------
function DoConnect

  -- clear field
  put return into field Field1

  -- init
  put VConnection_Constructor( "localhost", "sa", "sa") into mConn
  get VConnection_Open( mConn )

  put VServer_New( mConn ) into mSrv

  -- work
  put VServer_Version( mSrv ) into res
  get OUT( res )     -- ==========>>> errors here with error in function
handler near "out"

---

Looks like I'm going to have to write a step by step install and testing
procedure for vServer as well.

Any help would be greatly appreciated.

------------------------------

Message: 4
Date: Thu, 8 Mar 2012 08:34:03 +1100
From: "Barry G. Sumpter" <barrysum at bigpond.net.au>
To: <valentina at lists.macserve.net>
Subject: RE: Shocked to find can't init valentina with LiveCode
Message-ID: <002601ccfcaa$04c040d0$0e40c270$@bigpond.net.au>
Content-Type: text/plain; charset="us-ascii"

  put VServer_New( mConn ) into mSrv                         --  Contains
"Error: 0x82503"

Big of debugging found the above.

-----Original Message-----
From: Barry G. Sumpter [mailto:barrysum at bigpond.net.au]
Sent: Thursday, 8 March 2012 7:27 AM
To: 'valentina at lists.macserve.net'
Subject: Shocked to find can't init valentina with LiveCode