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.

pb component and ase dbo

7 posts in General Discussion (old) Last posting was on 2000-03-20 22:00:11.0Z
Sem Kazazic Posted on 2000-03-18 18:40:56.0Z
Newsgroups: sybase.public.easerver
From: "Sem Kazazic" <semk@ica.net>
Subject: pb component and ase dbo
Date: Sat, 18 Mar 2000 13:40:56 -0500
Lines: 13
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: max2-net131-ip020-toronto.ica.net 209.151.131.20
Message-ID: <347_WVunOqQk$GA.285@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26131
Article PK: 156811

Hi,
when you have pb jaguar component and ASE db, what you usually do with dbo
prefix in SQL select, dw etc ?
Thanks
Regards,
Sem.


--
Sem Kazazic
semk@ica.net


Scott McReynolds [Sybase] Posted on 2000-03-20 17:05:43.0Z
Newsgroups: sybase.public.easerver
From: "Scott McReynolds [Sybase]" <scottmc@sybase.com>
Subject: Re: pb component and ase dbo
Date: Mon, 20 Mar 2000 10:05:43 -0700
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: scottmc-lpt.sybase.com 157.133.56.40
Message-ID: <347_Uk9oc8ok$GA.290@forums.sybase.com>
References: <347_WVunOqQk$GA.285@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26073
Article PK: 156078

Sem,

I like to include the dbo in my sql statement as well as the database. It
depends on whether I know that the connection cache I am going to be
connecting is connecting to the database I want to use or not.

Scott

"Sem Kazazic" <semk@ica.net> wrote in message
news:WVunOqQk$GA.285@forums.sybase.com...
> Hi,
> when you have pb jaguar component and ASE db, what you usually do with dbo
> prefix in SQL select, dw etc ?
> Thanks
> Regards,
> Sem.
>
>
> --
> Sem Kazazic
> semk@ica.net
>
>


Sem Kazazic Posted on 2000-03-20 20:00:49.0Z
Newsgroups: sybase.public.easerver
From: "Sem Kazazic" <semk@vytalnet.com>
Subject: Re: pb component and ase dbo
Date: Mon, 20 Mar 2000 15:00:49 -0500
Lines: 57
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: 209.121.88.73
Message-ID: <347_t9Vzueqk$GA.201@forums.sybase.com>
References: <347_WVunOqQk$GA.285@forums.sybase.com> <347_Uk9oc8ok$GA.290@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26064
Article PK: 156067

Hi Scott,

where to find more about - white papers , other documents etc?
I am new with ase, and currently I have a problem with very simple sql used
from powerbuilder jaguar component., like:

SELECT users.userid, users.password
FROM users
WHERE users.userid = :ls_userid AND users.password = :ls_password;

If my component use ASA db and ODBC jag connection cache , everything is
fine.

If I try to use ASE db , I have two situation;

1. SQLCA.DBMS = "ODBC" and related named cache, then I have SQLCA.CODE = -1

2. SQLCA.DBMS = "SYJ" and related open jaguar client cache, then I am
getting
208/16/1/42000;users not found.Specify owner.objectname or use sp_help
to check whether the object exist

Both connection cache are tested, can ping to them.
Thanks.
Regards,
Sem.

Scott McReynolds [Sybase] wrote in message ...
>Sem,
>
>I like to include the dbo in my sql statement as well as the database. It
>depends on whether I know that the connection cache I am going to be
>connecting is connecting to the database I want to use or not.
>
>Scott
>
>"Sem Kazazic" <semk@ica.net> wrote in message
>news:WVunOqQk$GA.285@forums.sybase.com...
>> Hi,
>> when you have pb jaguar component and ASE db, what you usually do with
dbo
>> prefix in SQL select, dw etc ?
>> Thanks
>> Regards,
>> Sem.
>>
>>
>> --
>> Sem Kazazic
>> semk@ica.net
>>
>>
>
>


Jim O'Neil [Sybase] Posted on 2000-03-20 20:26:09.0Z
Newsgroups: sybase.public.easerver
Date: Mon, 20 Mar 2000 15:26:09 -0500
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: pb component and ase dbo
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 48
NNTP-Posting-Host: joneil-nt.sybase.com 204.167.42.111
Message-ID: <347_38D68960.8B38EBB1@sybase.com>
References: <347_WVunOqQk$GA.285@forums.sybase.com> <347_Uk9oc8ok$GA.290@forums.sybase.com> <347_t9Vzueqk$GA.201@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26063
Article PK: 156066


Sem Kazazic wrote:

> Hi Scott,
>
> where to find more about - white papers , other documents etc?
> I am new with ase, and currently I have a problem with very simple sql used
> from powerbuilder jaguar component., like:
>
> SELECT users.userid, users.password
> FROM users
> WHERE users.userid = :ls_userid AND users.password = :ls_password;
>
> If my component use ASA db and ODBC jag connection cache , everything is
> fine.
>
> If I try to use ASE db , I have two situation;
>
> 1. SQLCA.DBMS = "ODBC" and related named cache, then I have SQLCA.CODE = -1
>
> 2. SQLCA.DBMS = "SYJ" and related open jaguar client cache, then I am
> getting
> 208/16/1/42000;users not found.Specify owner.objectname or use sp_help
> to check whether the object exist
>
> Both connection cache are tested, can ping to them.
> Thanks.
> Regards,
> Sem.
>
> Scott McReynolds [Sybase] wrote in message ...
> >Sem,
> >
> >I like to include the dbo in my sql statement as well as the database. It
> >depends on whether I know that the connection cache I am going to be
> >connecting is connecting to the database I want to use or not.
> >
> >Scott
> >
> >"Sem Kazazic" <semk@ica.net> wrote in message
> >news:WVunOqQk$GA.285@forums.sybase.com...
> >> Hi,
> >> when you have pb jaguar component and ASE db, what you usually do with
> dbo
> >> prefix in SQL select, dw etc ?
> >> Thanks
> >> Regards,
> >> Sem.
> >>
> >>
> >> --
> >> Sem Kazazic
> >> semk@ica.net
> >>
> >>
> >
> >

What operation are you doing when you get the SQLCode=-1? Are you using embedded
SQL and opening a cursor? datawindow retrieve? For the ODBC instance, what is
the associated error message in SQLCA.SQLErrText? For the SYJ case, did you set
SQLCA.Database='<your database>' before connecting?


--
Jim O'Neil
Senior Technical Support Engineer
Sybase, Inc


Sem Kazazic Posted on 2000-03-20 21:02:03.0Z
Newsgroups: sybase.public.easerver
From: "Sem Kazazic" <semk@vytalnet.com>
Subject: Re: pb component and ase dbo
Date: Mon, 20 Mar 2000 16:02:03 -0500
Lines: 96
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: 209.121.88.73
Message-ID: <347_xRA39Ark$GA.298@forums.sybase.com>
References: <347_WVunOqQk$GA.285@forums.sybase.com> <347_Uk9oc8ok$GA.290@forums.sybase.com> <347_t9Vzueqk$GA.201@forums.sybase.com> <347_38D68960.8B38EBB1@sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26060
Article PK: 156064

Hi Jim,
This will be a part of the method to pullout the user profile. It's embedded
SQL and no cursor.

Here is SQLCA.SQLErrText
SQLErrText =SQLSTATE = S0002
[INTERSOLV][ODBC SQL Server driver][SQL Server]users not found.
Specify owner.objectname or use sp_help to check whether the object exists
(sp_help may produce lots of output).

For SYJ case I had no SQLCA.Database='<mydatabase>'
Is this mandatory even for named connection cache?

Thanks.
Regards,
Sem.

Jim O'Neil [Sybase] wrote in message <38D68960.8B38EBB1@sybase.com>...
>Sem Kazazic wrote:
>
>> Hi Scott,
>>
>> where to find more about - white papers , other documents etc?
>> I am new with ase, and currently I have a problem with very simple sql
used
>> from powerbuilder jaguar component., like:
>>
>> SELECT users.userid, users.password
>> FROM users
>> WHERE users.userid = :ls_userid AND users.password = :ls_password;
>>
>> If my component use ASA db and ODBC jag connection cache , everything is
>> fine.
>>
>> If I try to use ASE db , I have two situation;
>>
>> 1. SQLCA.DBMS = "ODBC" and related named cache, then I have SQLCA.CODE
= -1
>>
>> 2. SQLCA.DBMS = "SYJ" and related open jaguar client cache, then I am
>> getting
>> 208/16/1/42000;users not found.Specify owner.objectname or use
sp_help
>> to check whether the object exist
>>
>> Both connection cache are tested, can ping to them.
>> Thanks.
>> Regards,
>> Sem.
>>
>> Scott McReynolds [Sybase] wrote in message ...
>> >Sem,
>> >
>> >I like to include the dbo in my sql statement as well as the database.
It
>> >depends on whether I know that the connection cache I am going to be
>> >connecting is connecting to the database I want to use or not.
>> >
>> >Scott
>> >
>> >"Sem Kazazic" <semk@ica.net> wrote in message
>> >news:WVunOqQk$GA.285@forums.sybase.com...
>> >> Hi,
>> >> when you have pb jaguar component and ASE db, what you usually do with
>> dbo
>> >> prefix in SQL select, dw etc ?
>> >> Thanks
>> >> Regards,
>> >> Sem.
>> >>
>> >>
>> >> --
>> >> Sem Kazazic
>> >> semk@ica.net
>> >>
>> >>
>> >
>> >
>
>What operation are you doing when you get the SQLCode=-1? Are you using
embedded
>SQL and opening a cursor? datawindow retrieve? For the ODBC instance,
what is
>the associated error message in SQLCA.SQLErrText? For the SYJ case, did
you set
>SQLCA.Database='<your database>' before connecting?
>
>
>--
>Jim O'Neil
>Senior Technical Support Engineer
>Sybase, Inc
>
>


Jim O'Neil [Sybase] Posted on 2000-03-20 21:22:16.0Z
Newsgroups: sybase.public.easerver
Date: Mon, 20 Mar 2000 16:22:16 -0500
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: pb component and ase dbo
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 34
NNTP-Posting-Host: joneil-nt.sybase.com 204.167.42.111
Message-ID: <347_38D69688.2BD65212@sybase.com>
References: <347_WVunOqQk$GA.285@forums.sybase.com> <347_Uk9oc8ok$GA.290@forums.sybase.com> <347_t9Vzueqk$GA.201@forums.sybase.com> <347_38D68960.8B38EBB1@sybase.com> <347_xRA39Ark$GA.298@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26058
Article PK: 156062


Sem Kazazic wrote:

> Hi Jim,
> This will be a part of the method to pullout the user profile. It's embedded
> SQL and no cursor.
>
> Here is SQLCA.SQLErrText
> SQLErrText =SQLSTATE = S0002
> [INTERSOLV][ODBC SQL Server driver][SQL Server]users not found.
> Specify owner.objectname or use sp_help to check whether the object exists
> (sp_help may produce lots of output).
>
> For SYJ case I had no SQLCA.Database='<mydatabase>'
> Is this mandatory even for named connection cache?
>
> Thanks.
> Regards,
> Sem.
>

In a very strict sense, I don't think so, but I'm a bit rusty on ASE here - I
believe each user can be assigned a default database, so whatever your cache
specifies as userid would determine what database you would use (either that or
it will just default to master). In any case, the cache is really just getting
you to the ASE server and there's no place in the cache properties to specify
the particular database, so by using SQLCA.Database, you'll ensure that
PowerBuilder issues the appropriate USE DATABASE <your db> to point you the
right place. Alternatively you can specify three-part names in your SQL "SELECT
* FROM database.owner.table" and not leave it to chance as to what the 'default'
database is.
--
Jim O'Neil
Senior Technical Support Engineer
Sybase, Inc


Sem Kazazic Posted on 2000-03-20 22:00:11.0Z
Newsgroups: sybase.public.easerver
From: "Sem Kazazic" <semk@vytalnet.com>
Subject: Re: pb component and ase dbo
Date: Mon, 20 Mar 2000 17:00:11 -0500
Lines: 62
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: 209.121.88.73
Message-ID: <347_bdWHchrk$GA.290@forums.sybase.com>
References: <347_WVunOqQk$GA.285@forums.sybase.com> <347_Uk9oc8ok$GA.290@forums.sybase.com> <347_t9Vzueqk$GA.201@forums.sybase.com> <347_38D68960.8B38EBB1@sybase.com> <347_xRA39Ark$GA.298@forums.sybase.com> <347_38D69688.2BD65212@sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26050
Article PK: 154381

Jim,

thanks for the wonderful explanation. Now I know how SYJ connection find
the database.
But then I got again same error related to dbo.
And guess what - I have to admit I was stupid enough to forget that ASE is a
case sensitive and PDesigner made all tablenames and columnnames as upper
case.
I changed that and method is working fine.

Thanks again.
Regards,
Sem.

Jim O'Neil [Sybase] wrote in message <38D69688.2BD65212@sybase.com>...
>Sem Kazazic wrote:
>
>> Hi Jim,
>> This will be a part of the method to pullout the user profile. It's
embedded
>> SQL and no cursor.
>>
>> Here is SQLCA.SQLErrText
>> SQLErrText =SQLSTATE = S0002
>> [INTERSOLV][ODBC SQL Server driver][SQL Server]users not found.
>> Specify owner.objectname or use sp_help to check whether the object
exists
>> (sp_help may produce lots of output).
>>
>> For SYJ case I had no SQLCA.Database='<mydatabase>'
>> Is this mandatory even for named connection cache?
>>
>> Thanks.
>> Regards,
>> Sem.
>>
>
>In a very strict sense, I don't think so, but I'm a bit rusty on ASE here -
I
>believe each user can be assigned a default database, so whatever your
cache
>specifies as userid would determine what database you would use (either
that or
>it will just default to master). In any case, the cache is really just
getting
>you to the ASE server and there's no place in the cache properties to
specify
>the particular database, so by using SQLCA.Database, you'll ensure that
>PowerBuilder issues the appropriate USE DATABASE <your db> to point you the
>right place. Alternatively you can specify three-part names in your SQL
"SELECT
>* FROM database.owner.table" and not leave it to chance as to what the
'default'
>database is.
>--
>Jim O'Neil
>Senior Technical Support Engineer
>Sybase, Inc
>
>