|
Home > Archive > SQL Anywhere Mobile > February 2006 > DBML Sync Param - Auth param and Script Version
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 |
DBML Sync Param - Auth param and Script Version
|
|
|
| Hi,
We are using the ASA 9.0.1.1899 version for ASA and we are
synchronizing the data between Oracle and ASA. In that My
clients want me to make the mobilink script versionised. I
try to pass the requird version in the DBMLsync ( .Net
utility provided by ASA ). using -sv option it says that is
invalid option and some window like getting the DB details
is population. shall i get the sample of passing the version
details in the DBMLSync utitility parameter option. And i
have one more problem in the Authenticate parameter passing
from the Front end.
I have writen an SP for authenticate parameter event in the
Oracle.
the sp is
create or replace procedure SpNumVerify (auth_stat in out
integer,MLUName varchar2,param1 varchar2,param2 Varchar2)
as
RCount Integer;
begin
SELECT count(*) into RCount FROM table where UPPER(Keycol)
= UPPER (param1 );
if RCount > 0 then
Select Count(*) into RCount From Table1 Where
UPPER(Keycol) = UPPER (param1);
if RCount = 0 then
Insert into Table1(col1,col2,col
3) Values
(param1,
'hhh',param2);
else
Update table1 Set .......;
end if;
auth_stat :=1000;
else
auth_stat :=4100;
end if;
end SpNumVerify;
I am always getting 4000 as a result. in the front end code
i am passing only two values i.e. -ap "param1,param2"
Kindly give me proper solution to solve this issue and
implement this process in my application.
Regards,
David
| |
| Liam Cavanagh 2006-01-30, 9:27 am |
| David,
For your script version question, I am thinking yuo might be having a
problem because sv is an extended option. For example you should be calling
dbmlsync like this
dbmlsync .... -e "sv=version1"
For your second question about auth parms, I do not see anything obvious
wrong with what you have done, however, you might try stepping back and
making sure the parameters are coming up as expected. To do this you might
change your stored proc to insert the parms from the stored proc into a
table. This will allow you to verify the parameters are coming up as you
would expect. If they are then you might try calling the stored proc
outside of the MobiLink and pass in the exact parameters from this table and
see if the resulsts are as expected. If it helps there are some
authentication examples on CodeXchange.
ASA902 - Using Custom Authentication Parameters and returning Custom Error
Messages to the Mobile Device
--
Liam Cavanagh
Sr. Product Manager
Certified ASA Developer Version 8
iAnywhere
<David> wrote in message news:43db7323.6cb3.1681692777@sybase.com...
> Hi,
> We are using the ASA 9.0.1.1899 version for ASA and we are
> synchronizing the data between Oracle and ASA. In that My
> clients want me to make the mobilink script versionised. I
> try to pass the requird version in the DBMLsync ( .Net
> utility provided by ASA ). using -sv option it says that is
> invalid option and some window like getting the DB details
> is population. shall i get the sample of passing the version
> details in the DBMLSync utitility parameter option. And i
> have one more problem in the Authenticate parameter passing
> from the Front end.
> I have writen an SP for authenticate parameter event in the
> Oracle.
> the sp is
> create or replace procedure SpNumVerify (auth_stat in out
> integer,MLUName varchar2,param1 varchar2,param2 Varchar2)
> as
> RCount Integer;
> begin
> SELECT count(*) into RCount FROM table where UPPER(Keycol)
> = UPPER (param1 );
> if RCount > 0 then
> Select Count(*) into RCount From Table1 Where
> UPPER(Keycol) = UPPER (param1);
> if RCount = 0 then
> Insert into Table1(col1,col2,col
3) Values
> (param1,
> 'hhh',param2);
> else
> Update table1 Set .......;
> end if;
> auth_stat :=1000;
> else
> auth_stat :=4100;
> end if;
> end SpNumVerify;
>
> I am always getting 4000 as a result. in the front end code
> i am passing only two values i.e. -ap "param1,param2"
>
> Kindly give me proper solution to solve this issue and
> implement this process in my application.
> Regards,
> David
| |
|
| Hi,
Thanks for the response.
I have tried that option what you have mentioned in your
reply.
It says some error at adr=Host option in my dbmlsync option.
I have given my sync option below for your notice pls tell
me what could be the problem
DBMLSYNC -c dsn=DB;uid=DBA;pwd=S
QL; -u MobiUser -x 3m -v+
-o EFBsync.txt -e vo='on' "sv=3.0.0.1" adr=host=MobiServer
-n Pub1 -n Sub2"
I have tried of inserting values to the table on running the
authentication Sp. there was no record in that table and it
returning only 4000 as auth value.
I am facing an another problem also now. Prevoiusly we used
the synchronization process for the file transfer also (
Binary contend from Oracle Blob data to Long binary column
in the ASA database ). it is still woring fine. Now we tried
to split the tables based on the File type. Now more than
one binary table are included All columns are all not null.
but only binary content table is not transferring a content
from oracle to ASA. it is not throwing an error also. it
says 0 rows inserted/updated to ASA table. Pls tell me if
any other settings needed to do this task.
Regards,
David
> David,
>
> For your script version question, I am thinking yuo might
> be having a problem because sv is an extended option.
> For example you should be calling dbmlsync like this
> dbmlsync .... -e "sv=version1"
>
> For your second question about auth parms, I do not see
> anything obvious wrong with what you have done, however,
> you might try stepping back and making sure the
> parameters are coming up as expected. To do this you
> might change your stored proc to insert the parms from
> the stored proc into a table. This will allow you to
> verify the parameters are coming up as you would expect.
> If they are then you might try calling the stored proc
> outside of the MobiLink and pass in the exact parameters
> from this table and see if the resulsts are as expected.
> If it helps there are some authentication examples on
> CodeXchange.
>
> ASA902 - Using Custom Authentication Parameters and
> returning Custom Error Messages to the Mobile Device
>
> --
> Liam Cavanagh
> Sr. Product Manager
> Certified ASA Developer Version 8
> iAnywhere
> <David> wrote in message
> ,param2" >
>
>
| |
| David Fishburn 2006-01-31, 11:24 am |
| David wrote in news:43df34d9.384f.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:
D> DBMLSYNC -c dsn=DB;uid=DBA;pwd=S
QL; -u MobiUser -x 3m -v+
D> -o EFBsync.txt -e vo='on' "sv=3.0.0.1" adr=host=MobiServer
D> -n Pub1 -n Sub2"
Try:
DBMLSYNC -c dsn=DB;uid=DBA;pwd=S
QL; -u MobiUser -x 3m -v+
-o EFBsync.txt -e vo='on' -e "sv=3.0.0.1" -e adr="host=MobiServer"
-n Pub1 -n Sub2"
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
| |
|
| Hi,
Thanks for the response.
I have used the option as you mentioned it is working fine.
but when i am trying to use the -ap option it shows some
DBMLSSYNC setup screen to get the DB and user details. here
is my sync. opion
-ap "2067,3.0.0.12" -c dsn=DB;uid=DBA;pwd=S
QL; -u Mobiuser
-x 3m -e vo='on' -e "sv=default"-e adr=host=S5420 -n pub1
-n pub2
Pls tell me if any wrong in the above statement.
Regards,
David
> David wrote in news:43df34d9.384f.1681692777@sybase.com
> of sybase.public.sqlanywhere.mobilink:
>
> D> DBMLSYNC -c dsn=DB;uid=DBA;pwd=S
QL; -u MobiUser -x 3m
> -v+ D> -o EFBsync.txt -e vo='on' "sv=3.0.0.1"
> adr=host=MobiServer D> -n Pub1 -n Sub2"
>
> Try:
> DBMLSYNC -c dsn=DB;uid=DBA;pwd=S
QL; -u MobiUser -x 3m -v+
> -o EFBsync.txt -e vo='on' -e "sv=3.0.0.1" -e
> adr="host=MobiServer" -n Pub1 -n Sub2"
> --
> David Fishburn
> Certified ASA Developer Version 8
> iAnywhere Solutions - Sybase
> Professional Services
> Please only post to the newsgroup
> Please ALWAYS include version and MORE importantly BUILD
> number with EACH post (dbeng9 -v).
>
> EBFs and Maintenance Releases
> http://downloads.sybase.com/swx/sdmain.stm
>
> Developer Community / Whitepapers
> http://www.ianywhere.com/developer
>
> CaseXpress - to report bugs
> http://casexpress.sybase.com
>
> CodeXchange - Free samples
>
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
>
| |
| Breck Carter [TeamSybase] 2006-02-01, 7:24 am |
| On 1 Feb 2006 05:08:16 -0800, David wrote:
>-ap "2067,3.0.0.12" -c dsn=DB;uid=DBA;pwd=S
QL; -u Mobiuser
>-x 3m -e vo='on' -e "sv=default"-e adr=host=S5420 -n pub1
>-n pub2
Try this...
-ap "2067,3.0.0.12" -c " dsn=DB;uid=DBA;pwd=S
QL" -u Mobiuser
-x 3m -e " vo=on;sv=default;adr
=host=S5420" -n pub1 -n pub2
Breck
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
|
| Hi,
I have used that option you have mentioed here. It is
working fine. I tried to insert the parameter values to the
table as initially suggested in this thread. that table is
not filled with this two values only auth_stat and userid
are passing. please tell me where might be the problem.
Regards,
David
> On 1 Feb 2006 05:08:16 -0800, David wrote:
>
> Mobiuser >-x 3m -e vo='on' -e "sv=default"-e
> adr=host=S5420 -n pub1 >-n pub2
>
> Try this...
> -ap "2067,3.0.0.12" -c " dsn=DB;uid=DBA;pwd=S
QL" -u
> Mobiuser -x 3m -e " vo=on;sv=default;adr
=host=S5420" -n
> pub1 -n pub2
>
> Breck
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
>
http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
| |
| David Fishburn 2006-02-03, 9:24 am |
| David wrote in news:43e34653.6da5.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:
D> I have used that option you have mentioed here. It is
D> working fine. I tried to insert the parameter values to the
D> table as initially suggested in this thread. that table is
D> not filled with this two values only auth_stat and userid
D> are passing. please tell me where might be the problem.
Start ML with -v+ -ot ml.txt.
Perform an sync and show us the output.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
| |
| Breck Carter [TeamSybase] 2006-02-03, 9:24 am |
| Sorry, I don't understand the question.
Please understand that this forum is operated on a *volunteer* basis,
so it's up to you to be clear and precise with your questions :)
The messages most likely to get answers are the ones that start with a
question like "How do I [do some specific thing or avoid some error]"
followed by whatever details are necessary to describe the situation.
The message should be self-contained, and not require the reader to
study past conversations.
Breck
On 3 Feb 2006 05:05:59 -0800, David wrote:
[color=darkred]
>Hi,
>I have used that option you have mentioed here. It is
>working fine. I tried to insert the parameter values to the
>table as initially suggested in this thread. that table is
>not filled with this two values only auth_stat and userid
>are passing. please tell me where might be the problem.
>Regards,
>David
>http://www.amazon.com/exec/obidos/A...7/risingroad-20
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
|
|
|
|
|