Home > Archive > SQL Anywhere Mobile > February 2006 > error in Test script









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author error in Test script
Fantom

2006-02-28, 8:34 pm

I write to simply script :
begin_connection : "create variable @mlu varchar(128)"
begin_synchronizatio
n :"set @mlu = ?"

when i run Test Script i get :

"Connection Script: Testing SQL begin_connection .........
Error: ASA Error -131: Syntax error near 'variable' on line 1
Connection Script: Testing SQL begin_synchronizatio
n .........
Error: ASA Error -260: Variable '@mlu' not found"

What is wrong ?
Fantom
ASA 8.0.3
Reg Domaratzki \(iAnywhere Solutions\)

2006-02-28, 8:34 pm

I'm pretty sure that the test script functionality was expecting a result
set, so it complained whenever no result set was returned. It was actually
too difficult to get the "test script" functionality working properly
against all the RDBMSs, so it was eventually removed in v9 I believe. The
short answer is that you shouldn't trust anything coming from the "Test
Script" functionality in the v8 ML Plugin for Sybase Central.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"


"Fantom" <szczukot@skasujto.poczta.onet.pl> wrote in message
news:44043f02@forums
-2-dub...
> I write to simply script :
> begin_connection : "create variable @mlu varchar(128)"
> begin_synchronizatio
n :"set @mlu = ?"
>
> when i run Test Script i get :
>
> "Connection Script: Testing SQL begin_connection .........
> Error: ASA Error -131: Syntax error near 'variable' on line 1
> Connection Script: Testing SQL begin_synchronizatio
n .........
> Error: ASA Error -260: Variable '@mlu' not found"
>
> What is wrong ?
> Fantom
> ASA 8.0.3



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com