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.

Access 2002 Linked table to ASA 8.0

5 posts in General Discussion Last posting was on 2005-08-05 11:59:16.0Z
Mike Bartosh Posted on 2005-08-04 05:11:05.0Z
From: "Mike Bartosh" <mikebartosh@sbcglobal.net>
Newsgroups: ianywhere.public.general
Subject: Access 2002 Linked table to ASA 8.0
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: adsl-69-111-123-47.dsl.irvnca.pacbell.net
Message-ID: <42f1a364$1@forums-2-dub>
X-Original-Trace: 3 Aug 2005 22:11:00 -0700, adsl-69-111-123-47.dsl.irvnca.pacbell.net
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 3 Aug 2005 22:11:03 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 3 Aug 2005 22:11:05 -0700
X-Trace: forums-1-dub 1123132265 10.22.108.75 (3 Aug 2005 22:11:05 -0700)
X-Original-Trace: 3 Aug 2005 22:11:05 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4667
Article PK: 8471

I setup a linked table in Microsoft Access 2002. I exported my Access table
to ASA and linked it. My ODBC connection is working since I was able to
export the table. I can see the table on the ASA database via the link in
Access, but when I try to update the table, I get an Authentication
Violation (#-98). I tried to setup authentication using the tutorial titled
"Authenticating an Access 2000 Connection Against an ASA 6 or 7
Authenticated Database". Using this procedure, an "Authentication Failed
(#-218) occurs. I don't think I got the signature correct. Unfortunately,
the tutorial doesn't explain how to get the signature. Any help on this
problem would be greatly appreciated.


"Rob Waywell" <rwaywell Posted on 2005-08-04 15:17:59.0Z
From: "Rob Waywell" <rwaywell@no_spam.ianywhere.com>
Newsgroups: ianywhere.public.general
References: <42f1a364$1@forums-2-dub>
Subject: Re: Access 2002 Linked table to ASA 8.0
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: rwaywell-xp.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-xp.sybase.com
Message-ID: <42f231a7$1@forums-1-dub>
Date: 4 Aug 2005 08:17:59 -0700
X-Trace: forums-1-dub 1123168679 10.25.98.159 (4 Aug 2005 08:17:59 -0700)
X-Original-Trace: 4 Aug 2005 08:17:59 -0700, rwaywell-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4668
Article PK: 8473

Since this database appears to already be authenticated, you will need to
get the authentication signature from the creator of the database.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Mike Bartosh" <mikebartosh@sbcglobal.net> wrote in message
news:42f1a364$1@forums-2-dub...
>I setup a linked table in Microsoft Access 2002. I exported my Access
>table to ASA and linked it. My ODBC connection is working since I was able
>to export the table. I can see the table on the ASA database via the link
>in Access, but when I try to update the table, I get an Authentication
>Violation (#-98). I tried to setup authentication using the tutorial
>titled "Authenticating an Access 2000 Connection Against an ASA 6 or 7
>Authenticated Database". Using this procedure, an "Authentication Failed
>(#-218) occurs. I don't think I got the signature correct. Unfortunately,
>the tutorial doesn't explain how to get the signature. Any help on this
>problem would be greatly appreciated.
>


Mike Bartosh Posted on 2005-08-04 20:20:29.0Z
Sender: 337c.42f27804.1804289383@sybase.com
From: Mike Bartosh
Newsgroups: ianywhere.public.general
Subject: Re: Access 2002 Linked table to ASA 8.0
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <42f2788d.3384.1681692777@sybase.com>
References: <42f231a7$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 4 Aug 2005 13:20:29 -0700
X-Trace: forums-1-dub 1123186829 10.22.241.41 (4 Aug 2005 13:20:29 -0700)
X-Original-Trace: 4 Aug 2005 13:20:29 -0700, 10.22.241.41
Lines: 49
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4670
Article PK: 8474

How do I find the authentication signature? The creator is
DBA.

> Since this database appears to already be authenticated,
> you will need to get the authentication signature from
> the creator of the database.
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
>
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available
> through the iAnywhere Developer Community at
> www.ianywhere.com/developer "Mike Bartosh"
> <mikebartosh@sbcglobal.net> wrote in message
> news:42f1a364$1@forums-2-dub... >I setup a linked table in
> Microsoft Access 2002. I exported my Access >table to
> ASA and linked it. My ODBC connection is working since I
> was able >to export the table. I can see the table on
> the ASA database via the link >in Access, but when I try
> to update the table, I get an Authentication >Violation
> (#-98). I tried to setup authentication using the
> tutorial >titled "Authenticating an Access 2000
> Connection Against an ASA 6 or 7 >Authenticated
> Database". Using this procedure, an "Authentication
> Failed >(#-218) occurs. I don't think I got the
> signature correct. Unfortunately, >the tutorial doesn't
> explain how to get the signature. Any help on this
> > >problem would be greatly appreciated.
>
>


Mike Bartosh Posted on 2005-08-04 20:27:23.0Z
Sender: 337c.42f27804.1804289383@sybase.com
From: mike bartosh
Newsgroups: ianywhere.public.general
Subject: Re: Access 2002 Linked table to ASA 8.0
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <42f27a2b.3394.1681692777@sybase.com>
References: <42f2788d.3384.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 4 Aug 2005 13:27:23 -0700
X-Trace: forums-1-dub 1123187243 10.22.241.41 (4 Aug 2005 13:27:23 -0700)
X-Original-Trace: 4 Aug 2005 13:27:23 -0700, 10.22.241.41
Lines: 53
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4671
Article PK: 17329

If I use the -zr SQL option in my startup parameters, will I
see the authentication signature in the log file?

> How do I find the authentication signature? The creator
> is DBA.
>
>
>
> > Since this database appears to already be authenticated,
> > you will need to get the authentication signature from
> > the creator of the database.
> >
> > --
> > -----------------------------------------------
> > Robert Waywell
> > Sybase Adaptive Server Anywhere Developer - Version 8
> > Sybase Certified Professional
> >
> > Sybase's iAnywhere Solutions
> >
> > Please respond ONLY to newsgroup
> >
> > EBF's and Patches: http://downloads.sybase.com
> > choose SQL Anywhere Studio >> change 'time frame' to
> all >
> > To Submit Bug Reports:
> >
>
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug
> >
> > SQL Anywhere Studio Supported Platforms and Support
> > Status http://my.sybase.com/detail?id=1002288
> >
> > Whitepapers, TechDocs, and bug fixes are all available
> > through the iAnywhere Developer Community at
> > www.ianywhere.com/developer "Mike Bartosh"
> > <mikebartosh@sbcglobal.net> wrote in message
> > news:42f1a364$1@forums-2-dub... >I setup a linked table
> > in Microsoft Access 2002. I exported my Access >table
> > to ASA and linked it. My ODBC connection is working
> > since I was able >to export the table. I can see the
> > table on the ASA database via the link >in Access, but
> > when I try to update the table, I get an Authentication
> > >Violation (#-98). I tried to setup authentication
> > using the tutorial >titled "Authenticating an Access
> > 2000 Connection Against an ASA 6 or 7 >Authenticated
> > Database". Using this procedure, an "Authentication
> > Failed >(#-218) occurs. I don't think I got the
> > signature correct. Unfortunately, >the tutorial
> > doesn't explain how to get the signature. Any help on
> > > this >problem would be greatly appreciated.
> >
> >


Chris Keating (iAnywhere Solutions) Posted on 2005-08-05 11:59:16.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <Spam_NoThanks_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <42f2788d.3384.1681692777@sybase.com> <42f27a2b.3394.1681692777@sybase.com>
Subject: Re: Access 2002 Linked table to ASA 8.0
Lines: 65
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: keating-xp2.sybase.com
X-Original-NNTP-Posting-Host: keating-xp2.sybase.com
Message-ID: <42f35494$1@forums-1-dub>
Date: 5 Aug 2005 04:59:16 -0700
X-Trace: forums-1-dub 1123243156 10.25.98.199 (5 Aug 2005 04:59:16 -0700)
X-Original-Trace: 5 Aug 2005 04:59:16 -0700, keating-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4673
Article PK: 8475

Are the vendor that owns the database file? If so, please review the Readme
First Authenticated Edition documentation which covers the methodology of
obtaining the key.

If you are an end-user of this database, you are restricted as to what you
can do with the database outside the application in which it was provided.
Please work with the vendor to understand those restrictions.

<mike bartosh> wrote in message news:42f27a2b.3394.1681692777@sybase.com...
> If I use the -zr SQL option in my startup parameters, will I
> see the authentication signature in the log file?
>
>> How do I find the authentication signature? The creator
>> is DBA.
>>
>>
>>
>> > Since this database appears to already be authenticated,
>> > you will need to get the authentication signature from
>> > the creator of the database.
>> >
>> > --
>> > -----------------------------------------------
>> > Robert Waywell
>> > Sybase Adaptive Server Anywhere Developer - Version 8
>> > Sybase Certified Professional
>> >
>> > Sybase's iAnywhere Solutions
>> >
>> > Please respond ONLY to newsgroup
>> >
>> > EBF's and Patches: http://downloads.sybase.com
>> > choose SQL Anywhere Studio >> change 'time frame' to
>> all >
>> > To Submit Bug Reports:
>> >
>>
> http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug
>> >
>> > SQL Anywhere Studio Supported Platforms and Support
>> > Status http://my.sybase.com/detail?id=1002288
>> >
>> > Whitepapers, TechDocs, and bug fixes are all available
>> > through the iAnywhere Developer Community at
>> > www.ianywhere.com/developer "Mike Bartosh"
>> > <mikebartosh@sbcglobal.net> wrote in message
>> > news:42f1a364$1@forums-2-dub... >I setup a linked table
>> > in Microsoft Access 2002. I exported my Access >table
>> > to ASA and linked it. My ODBC connection is working
>> > since I was able >to export the table. I can see the
>> > table on the ASA database via the link >in Access, but
>> > when I try to update the table, I get an Authentication
>> > >Violation (#-98). I tried to setup authentication
>> > using the tutorial >titled "Authenticating an Access
>> > 2000 Connection Against an ASA 6 or 7 >Authenticated
>> > Database". Using this procedure, an "Authentication
>> > Failed >(#-218) occurs. I don't think I got the
>> > signature correct. Unfortunately, >the tutorial
>> > doesn't explain how to get the signature. Any help on
>> > > this >problem would be greatly appreciated.
>> >
>> >