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.

Datastore Error using OLEDB and SQL Server

2 posts in Objects Last posting was on 2004-12-16 09:00:25.0Z
Hector Posted on 2004-12-13 11:54:24.0Z
Sender: 2915.41bd7ebb.1804289383@sybase.com
From: Hector
Newsgroups: sybase.public.powerbuilder.objects
Subject: Datastore Error using OLEDB and SQL Server
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <41bd82f0.2971.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 13 Dec 2004 03:54:24 -0800
X-Trace: forums-1-dub 1102938864 10.22.241.41 (13 Dec 2004 03:54:24 -0800)
X-Original-Trace: 13 Dec 2004 03:54:24 -0800, 10.22.241.41
Lines: 21
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:8143
Article PK: 735411

I've a problem when i try to create a datastore from a
select.
I create de sintax ok using SyntacfromSQL function. then i
create the datastore from that sintax and it creates ok,
then i call settransobject and ok, BUT qhe i try to retrieve
the data i fails (Program crash and close).

I notice that it occurs when my select inlcudes columns that
are from 'uniqueidentifier' datatype.
'select * from facturas where tipo=3' and table 'facturas'
has a column uniqueidentifier datatype.

I'm using Powerbuilder 9 Build 5507 and OLEDB to connect to
a MSSQL Server 2000.

When i use ODBC to connect it works well and i've no error.
But i want to use OLEDB becase ODBC cause me another
problems.

Sorry by my english
Thanks.


Sanjiv Das [TeamSybase] Posted on 2004-12-16 09:00:25.0Z
From: "Sanjiv Das [TeamSybase]" <No-Spam-SDas_TeamSybase@HotMail.Com>
Newsgroups: sybase.public.powerbuilder.objects
References: <41bd82f0.2971.1681692777@sybase.com>
Subject: Re: Datastore Error using OLEDB and SQL Server
Lines: 35
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: ip68-5-200-98.oc.oc.cox.net
Message-ID: <41c14ea4$1@forums-2-dub>
X-Original-Trace: 16 Dec 2004 01:00:20 -0800, ip68-5-200-98.oc.oc.cox.net
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 16 Dec 2004 01:00:22 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 16 Dec 2004 01:00:25 -0800
X-Trace: forums-1-dub 1103187625 10.22.108.75 (16 Dec 2004 01:00:25 -0800)
X-Original-Trace: 16 Dec 2004 01:00:25 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:8144
Article PK: 735410

First thing to check would probably be the datatype of the identity column
in the DW. You could then try running a trace of database activity and see
if that sheds light on the problem.

You should also probably update your PB software to 9.0.2 and check if that
makes a difference.

Sanjiv.

<Hector> wrote in message news:41bd82f0.2971.1681692777@sybase.com...
> I've a problem when i try to create a datastore from a
> select.
> I create de sintax ok using SyntacfromSQL function. then i
> create the datastore from that sintax and it creates ok,
> then i call settransobject and ok, BUT qhe i try to retrieve
> the data i fails (Program crash and close).
>
> I notice that it occurs when my select inlcudes columns that
> are from 'uniqueidentifier' datatype.
> 'select * from facturas where tipo=3' and table 'facturas'
> has a column uniqueidentifier datatype.
>
> I'm using Powerbuilder 9 Build 5507 and OLEDB to connect to
> a MSSQL Server 2000.
>
> When i use ODBC to connect it works well and i've no error.
> But i want to use OLEDB becase ODBC cause me another
> problems.
>
> Sorry by my english
> Thanks.