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.

Mac OS X Examples

4 posts in General Discussion Last posting was on 2005-01-19 11:08:49.0Z
Clayton Leitch Posted on 2005-01-18 19:55:06.0Z
From: Clayton Leitch <captchoas@mac.com>
User-Agent: Mozilla Thunderbird 1.0 (Macintosh/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Mac OS X Examples
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: wbar2-4-10-028-153.wdc2.elnk.dsl.genuity.net
X-Original-NNTP-Posting-Host: wbar2-4-10-028-153.wdc2.elnk.dsl.genuity.net
Message-ID: <41ed699a$1@forums-1-dub>
Date: 18 Jan 2005 11:55:06 -0800
X-Trace: forums-1-dub 1106078106 4.10.28.153 (18 Jan 2005 11:55:06 -0800)
X-Original-Trace: 18 Jan 2005 11:55:06 -0800, wbar2-4-10-028-153.wdc2.elnk.dsl.genuity.net
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4072
Article PK: 7959

Downloaded the developer package with the samples. I compiled the
samples. They work just fine. However, I decided to set up a non-DBA
user and change out the user ID and password with my new user. I set up
the new user to have access to all the tables in the demo to the new
user. I set the source code to the new user ID and password.
Application and logs indicate that table contact cannot be found.

Any ideas?


Tom Slee Posted on 2005-01-18 21:52:52.0Z
From: Tom Slee <tom.slee@sybase.com>
Reply-To: tom.slee_no_spam@sybase.com
User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Mac OS X Examples
References: <41ed699a$1@forums-1-dub>
In-Reply-To: <41ed699a$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: tslee-pc2.sybase.com
Message-ID: <41ed8530$1@forums-2-dub>
X-Original-Trace: 18 Jan 2005 13:52:48 -0800, tslee-pc2.sybase.com
Lines: 15
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 18 Jan 2005 13:52:49 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 18 Jan 2005 13:52:52 -0800
X-Trace: forums-1-dub 1106085172 10.22.108.75 (18 Jan 2005 13:52:52 -0800)
X-Original-Trace: 18 Jan 2005 13:52:52 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4073
Article PK: 7957

You probably have to qualify the table name with the owner -- reference
it as "DBA".contact.

Tom Slee
iAnywhere Product Management

Clayton Leitch wrote:
> Downloaded the developer package with the samples. I compiled the
> samples. They work just fine. However, I decided to set up a non-DBA
> user and change out the user ID and password with my new user. I set up
> the new user to have access to all the tables in the demo to the new
> user. I set the source code to the new user ID and password.
> Application and logs indicate that table contact cannot be found.
>
> Any ideas?


Clayton Leitch Posted on 2005-01-19 01:18:29.0Z
From: Clayton Leitch <captchoas@mac.com>
User-Agent: Mozilla Thunderbird 1.0 (Macintosh/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Mac OS X Examples
References: <41ed699a$1@forums-1-dub> <41ed8530$1@forums-2-dub>
In-Reply-To: <41ed8530$1@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: wbar2-4-10-028-153.wdc2.elnk.dsl.genuity.net
X-Original-NNTP-Posting-Host: wbar2-4-10-028-153.wdc2.elnk.dsl.genuity.net
Message-ID: <41edb565$1@forums-1-dub>
Date: 18 Jan 2005 17:18:29 -0800
X-Trace: forums-1-dub 1106097509 4.10.28.153 (18 Jan 2005 17:18:29 -0800)
X-Original-Trace: 18 Jan 2005 17:18:29 -0800, wbar2-4-10-028-153.wdc2.elnk.dsl.genuity.net
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4074
Article PK: 7960


Tom Slee wrote:
> You probably have to qualify the table name with the owner -- reference
> it as "DBA".contact.
>
> Tom Slee
> iAnywhere Product Management
>
> Clayton Leitch wrote:
>
>> Downloaded the developer package with the samples. I compiled the
>> samples. They work just fine. However, I decided to set up a non-DBA
>> user and change out the user ID and password with my new user. I set
>> up the new user to have access to all the tables in the demo to the
>> new user. I set the source code to the new user ID and password.
>> Application and logs indicate that table contact cannot be found.
>>
>> Any ideas?

Thanks, that solved the problem. I am afraid I am a little more
familiar with WebObjects which removes all this complexity.


Breck Carter [TeamSybase] Posted on 2005-01-19 11:08:49.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Mac OS X Examples
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <pnfsu0t8bm24a220p33fp02603d0mfharh@4ax.com>
References: <41ed699a$1@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 208.254.244.99
X-Original-NNTP-Posting-Host: 208.254.244.99
Date: 19 Jan 2005 03:08:49 -0800
X-Trace: forums-1-dub 1106132929 208.254.244.99 (19 Jan 2005 03:08:49 -0800)
X-Original-Trace: 19 Jan 2005 03:08:49 -0800, 208.254.244.99
Lines: 33
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4076
Article PK: 7962

You can also avoid having to qualify table names:

GRANT GROUP TO DBA;
GRANT MEMBERSHIP IN GROUP DBA TO otheruser;

If there is no table "otheruser.contact", a reference to "contact"
will be resolved to "dba.contact".

The GRANT MEMBERSHIP does *not* convey "DBA privileges" to otheruser,
so there is no danger. It simply makes the table name "visible" to
members of the group.

Breck


On 18 Jan 2005 11:55:06 -0800, Clayton Leitch <captchoas@mac.com>

wrote:

>Downloaded the developer package with the samples. I compiled the
>samples. They work just fine. However, I decided to set up a non-DBA
>user and change out the user ID and password with my new user. I set up
>the new user to have access to all the tables in the demo to the new
>user. I set the source code to the new user ID and password.
>Application and logs indicate that table contact cannot be found.
>
>Any ideas?

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com