Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Ultralite with Oracle 8i

4 posts in General Discussion Last posting was on 2003-11-07 01:42:45.0Z
Mann Posted on 2003-11-04 13:22:07.0Z
Sender: 6f2b.3fa7a796.1804289383@sybase.com
From: Mann
Newsgroups: ianywhere.public.general
Subject: Ultralite with Oracle 8i
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3fa7a7ff.6f32.846930886@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 4 Nov 2003 05:22:07 -0800
X-Trace: forums-1-dub 1067952127 10.22.241.41 (4 Nov 2003 05:22:07 -0800)
X-Original-Trace: 4 Nov 2003 05:22:07 -0800, 10.22.241.41
Lines: 40
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2004
Article PK: 4231

I have an Ultralite application. I created that application
using ASA database(reference database). Once application was
run for the first time, the ultralite schema gets built in.
Now I remove the reference database from the picture and
synchronize my application with the consolidated database
which is oracle 8i.
My oracle database has the same schema as my reference
database.I do the following steps to see if my
syncronization is working.

1. My consolidated database runs at some remote location

2. I create a odbc connection using Oracle ODBC driver.Them
I do dbmlsrv9 -c "dsn=test_oracle;uid=marconi;pwd=marconi"
I get the message

I. 11/04 17:55:34. <Main>: MobiLink server started
I. 11/04 17:55:34. <Main>: Local file for remote
synchronization logs: 'dbmlsrv.mle'
I. 11/04 17:55:34. <Main>: Stream specifier 1: TCPIP

I ASSUME my mobilink server has started and it has made a
succesful connection with the oracle database.

3. I want to connect mobilink client to server..
using dbmlsync -c "dsn=test_oracle" -o dbmlsync.out -v -e
"SendColumnNamesON".
My SYNCHRONIZATION FAILS..I get the following message in the
window

I. 11/04 17:58:11. Connecting to remote database
I. 11/04 17:58:14. Loading synchronization information
E. 11/04 17:58:15. No synchronization subscription found in
the database.
I. 11/04 17:58:15. Disconnecting from remote database


Please help as to what i am doing wrong.?

MannB


Greg Fenton Posted on 2003-11-04 15:26:58.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4; MultiZilla v1.4.0.4A) Gecko/20030624
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Ultralite with Oracle 8i
References: <3fa7a7ff.6f32.846930886@sybase.com>
In-Reply-To: <3fa7a7ff.6f32.846930886@sybase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: gfenton-xp.sybase.com
Message-ID: <3fa7c66c$1@forums-2-dub>
X-Original-Trace: 4 Nov 2003 07:31:56 -0800, gfenton-xp.sybase.com
Lines: 38
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 4 Nov 2003 07:18:45 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 4 Nov 2003 07:26:58 -0800
X-Trace: forums-1-dub 1067959618 10.22.108.75 (4 Nov 2003 07:26:58 -0800)
X-Original-Trace: 4 Nov 2003 07:26:58 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2010
Article PK: 4234

Mann wrote:

Please, always post the version and BUILD number of ASA and/or MobiLink
that you are using.

> I have an Ultralite application. I created that application
> using ASA database(reference database). Once application was
> run for the first time, the ultralite schema gets built in.
> Now I remove the reference database from the picture and
> synchronize my application with the consolidated database
> which is oracle 8i.

Do you have an UltraLite application or are you using ASA? If you are
using UltraLite, then you do NOT use dbmlsync as UltraLite has built-in
synchronization.


> 3. I want to connect mobilink client to server..
> using dbmlsync -c "dsn=test_oracle" -o dbmlsync.out -v -e
> "SendColumnNamesON".

You would NOT use dbmlsync against an UltraLite application. You also
would NOT use dbmlsync against the Oracle database.

Instead, your application will call the ULSynchronize() function that is
appropriate to the API you are using. Which API are you using?

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Mann Posted on 2003-11-05 04:56:13.0Z
Sender: 6fb3.3fa87f62.1804289383@sybase.com
From: Mann
Newsgroups: ianywhere.public.general
Subject: Re: Ultralite with Oracle 8i
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3fa88415.6fc3.846930886@sybase.com>
References: <3fa7a7ff.6f32.846930886@sybase.com><3fa7c66c$1@forums-2-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 4 Nov 2003 21:01:09 -0800, 10.22.241.42
Lines: 15
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 4 Nov 2003 20:47:54 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 4 Nov 2003 20:56:13 -0800
X-Trace: forums-1-dub 1068008173 10.22.108.75 (4 Nov 2003 20:56:13 -0800)
X-Original-Trace: 4 Nov 2003 20:56:13 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2021
Article PK: 4240

My ASA and mobilink have version 9.0 and build 1216

1. My ultimate aim is to syncronize Ultralite
application.What all parameters I have to set while calling
ULSyncronize() function.I am using codewarrior metroworks
for my application.

2. Before syncronizing the Ultralite application, I tried
testing syncronization between ASA refernce database with
Oracle8i consolidated database. I am doing this just to
confirm if settings(i.e all required table and scripts ) are
okay on oracle database.How do I check that? Is there any
way to confirm connection between mobilink client and
mobilink server.If i cannot use "dbmlsync" against oracle
database. Do I have to use it against reference ASA database


Greg Fenton Posted on 2003-11-07 01:42:45.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4; MultiZilla v1.4.0.4A) Gecko/20030624
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Ultralite with Oracle 8i
References: <3fa7a7ff.6f32.846930886@sybase.com><3fa7c66c$1@forums-2-dub> <3fa88415.6fc3.846930886@sybase.com>
In-Reply-To: <3fa88415.6fc3.846930886@sybase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: cpe000625d8278c-cm.cpe.net.cable.rogers.com
Message-ID: <3faaf9c7$1@forums-2-dub>
X-Original-Trace: 6 Nov 2003 17:47:51 -0800, cpe000625d8278c-cm.cpe.net.cable.rogers.com
Lines: 30
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 6 Nov 2003 17:34:17 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 6 Nov 2003 17:42:45 -0800
X-Trace: forums-1-dub 1068169365 10.22.108.75 (6 Nov 2003 17:42:45 -0800)
X-Original-Trace: 6 Nov 2003 17:42:45 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2043
Article PK: 4260


Mann wrote:
> My ASA and mobilink have version 9.0 and build 1216
>

If this is new development, consider upgrading to the latest 9.0 EBF.

> 1. My ultimate aim is to syncronize Ultralite
> application.What all parameters I have to set while calling
> ULSyncronize() function.I am using codewarrior metroworks
> for my application.

You'll need to read the documentation for the synchronization function
of the API you are using (C++ API or ESQL).


> 2. [...] If i cannot use "dbmlsync" against oracle
> database. Do I have to use it against reference ASA database

Yes, you would use dbmlsync against the reference database.

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/