TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to
[EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any problems!
----------------------------------------------------------------------------
Hi Steve,
thanks for the hint that we have to access Oracle via Access (linking the
tables via ODBC).
There are some problems left:
- There are no more reports. (We expected that. We really don't miss them.)
- We see not longer how many records are in the Database. (File -> Maintain
Database)
- We can not update the database any more. (That is a big problem.)
Problem 2 and 3 have the same roots (we think). Oracle don't understand the
auto-increment which Access has.
How did you solved that? Or is there another issue with the log entries?
(Problem 3 is the mission critcal one.)
What had we done so far:
We generated with the Workbench a migration script, let it run against a
newly created database, created a new Access DB with the tables linked via
ODBC and put it in place at the RealSecure home directory. We can save only
1(!) log value in the database.
BTW: We are testing the migration with RealSecure 5.0 with Access 97 under
Win NT and RealSecure 5.5 with Access 2000 under Win 2k.
Thanks in advance
Marc Perisa
PS: We will read the document about SQL Server tomorrow. When we are
finished, we will send a detailed how-to to the list.
[EMAIL PROTECTED] wrote:
>
> Hi,
> You can refer RealSecure White page "Using SQL Server 7.0 as an alternate
> database backedn for Realsecure 3.1".
>
> The most important thing is RealSecure connect to Oracle through Access. After
> you use Oracle "Migration Workbench" to migrate rsntclientlog.mdb into Oracle,
> you can create table links between rsntclientlog.mdb table and Oracle table.
>
> We use RealSecure 5.0 with Access 97.
>
> Good Luck.
>
> Steven Mei
>
> Information System Managerment
> University of Waterloo
> Canada
> (519) 888 4567 ext.3820
>
> > Hi Steve,
> >
> > in the mailing list ISS-forum you wrote on 29. Juni 2001 about a successful
> > migration of the access database into Oracle by using the Migration
> > Workbench.
> >
> > Which problems and issues did occure ?
> > Which version of RealSecure to you have ? RealSecure 5.0 (with Access 97) or
> > RS 5.5 (with Access 2000) ?
> >
> > Can you tell me about your experience when doing the migration ?
> >
> >
> > Thanks in advance
> >
> >
> > Marc Perisa
> >
>
> ---------------------------------------------
> This message was sent using Endymion MailMan.
> http://www.endymion.com/products/mailman/
