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.net

4 posts in DataWindow .NET Last posting was on 2004-09-02 16:12:18.0Z
"Silvio Piovesan" <silvio.piovesan Posted on 2004-09-02 15:38:23.0Z
From: "Silvio Piovesan" <silvio.piovesan@_no_spam_capita.co.uk>
Newsgroups: sybase.public.datawindow.net
Subject: datastore.net
Lines: 49
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: mailhost.capitagroup.co.uk
Message-ID: <41373ffa@forums-2-dub>
X-Original-Trace: 2 Sep 2004 08:44:58 -0700, mailhost.capitagroup.co.uk
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 2 Sep 2004 08:27:32 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 2 Sep 2004 08:38:23 -0700
X-Trace: forums-1-dub 1094139503 10.22.108.75 (2 Sep 2004 08:38:23 -0700)
X-Original-Trace: 2 Sep 2004 08:38:23 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:287
Article PK: 124716

I am trying to use a datastore in one of my classes but when I try to set
the transaction I get the error:
"An unhandled exception of type
'Sybase.DataWindow.DataWindowNotCreatedException' occurred in datawindow.dll
Additional information: SetTransaction was called when no DataWindow object
was attached."

my code:
public class Engine
{
protected Transaction SQLCA;
protected DataStore dsData;

public Engine()
{
SQLCA = new Transaction();
SQLCA.Database = "*";
SQLCA.Dbms = DbmsType.Informix9;
SQLCA.Password = "*";
SQLCA.ServerName = "*";
SQLCA.UserId = "*";

dsData = new DataStore();
dsData.DataWindowObject = "d_eng_modl";
dsData.LibraryList = @"C:\Develop\dw.net\maintenance.net.pbl";
}

public DataWindowFullState GetData()
{
SQLCA.Connect();
dsData.SetTransaction(SQLCA); <<<< here I get the error
DataWindowFullState FullState = null;
dsData.Retrieve();
FullState = dsData.GetFullState();
return FullState;
}
}



--
Regards,

Silvio Piovesan
Analyst Programmer
Capita Business Services Limited
London.


Jack Addington Posted on 2004-09-02 15:50:40.0Z
From: "Jack Addington" <jaddington@shaw.ca>
Newsgroups: sybase.public.datawindow.net
References: <41373ffa@forums-2-dub>
Subject: Re: datastore.net
Lines: 65
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: s010600e018e32f17.cg.shawcable.net
X-Original-NNTP-Posting-Host: s010600e018e32f17.cg.shawcable.net
Message-ID: <41374150$1@forums-1-dub>
Date: 2 Sep 2004 08:50:40 -0700
X-Trace: forums-1-dub 1094140240 68.147.193.82 (2 Sep 2004 08:50:40 -0700)
X-Original-Trace: 2 Sep 2004 08:50:40 -0700, s010600e018e32f17.cg.shawcable.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:289
Article PK: 124720

I've found that if you pass the libList and dataObject to the new
dataStore( string, string ) function then it will throw an exception if it
doesn't like the values (ie. typo in name etc). Rather than getting the
exception later on when you try to use the datastore.

I have basically the exact same code except for the above...

Not sure that you want the @ infront of the LibList ??? I don't use that.

"Silvio Piovesan" <silvio.piovesan@_no_spam_capita.co.uk> wrote in message
news:41373ffa@forums-2-dub...
> I am trying to use a datastore in one of my classes but when I try to set
> the transaction I get the error:
> "An unhandled exception of type
> 'Sybase.DataWindow.DataWindowNotCreatedException' occurred in
datawindow.dll
> Additional information: SetTransaction was called when no DataWindow
object
> was attached."
>
> my code:
> public class Engine
> {
> protected Transaction SQLCA;
> protected DataStore dsData;
>
> public Engine()
> {
> SQLCA = new Transaction();
> SQLCA.Database = "*";
> SQLCA.Dbms = DbmsType.Informix9;
> SQLCA.Password = "*";
> SQLCA.ServerName = "*";
> SQLCA.UserId = "*";
>
> dsData = new DataStore();
> dsData.DataWindowObject = "d_eng_modl";
> dsData.LibraryList = @"C:\Develop\dw.net\maintenance.net.pbl";
> }
>
> public DataWindowFullState GetData()
> {
> SQLCA.Connect();
> dsData.SetTransaction(SQLCA); <<<< here I get the error
> DataWindowFullState FullState = null;
> dsData.Retrieve();
> FullState = dsData.GetFullState();
> return FullState;
> }
> }
>
>
>
> --
> Regards,
>
> Silvio Piovesan
> Analyst Programmer
> Capita Business Services Limited
> London.
>
>


"Silvio Piovesan" <silvio.piovesan Posted on 2004-09-02 15:59:31.0Z
From: "Silvio Piovesan" <silvio.piovesan@_no_spam_capita.co.uk>
Newsgroups: sybase.public.datawindow.net
References: <41373ffa@forums-2-dub> <41374150$1@forums-1-dub>
Subject: Re: datastore.net
Lines: 88
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: mailhost.capitagroup.co.uk
X-Original-NNTP-Posting-Host: mailhost.capitagroup.co.uk
Message-ID: <41374363@forums-1-dub>
Date: 2 Sep 2004 08:59:31 -0700
X-Trace: forums-1-dub 1094140771 194.129.126.226 (2 Sep 2004 08:59:31 -0700)
X-Original-Trace: 2 Sep 2004 08:59:31 -0700, mailhost.capitagroup.co.uk
X-Authenticated-User: pbtenbeta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:290
Article PK: 124721

Thanks Jack

it works!

FYIO the @ in front of the string makes the compiler scape special chars.
that means
"C:\\Develop\\dw.net\\maintenance.net.pbl" =
@"C:\Develop\dw.net\maintenance.net.pbl"



--
Regards,

Silvio Piovesan
Analyst Programmer
Capita Business Services Limited
London.

"Jack Addington" <jaddington@shaw.ca> wrote in message
news:41374150$1@forums-1-dub...
> I've found that if you pass the libList and dataObject to the new
> dataStore( string, string ) function then it will throw an exception if it
> doesn't like the values (ie. typo in name etc). Rather than getting the
> exception later on when you try to use the datastore.
>
> I have basically the exact same code except for the above...
>
> Not sure that you want the @ infront of the LibList ??? I don't use that.
>
>
> "Silvio Piovesan" <silvio.piovesan@_no_spam_capita.co.uk> wrote in message
> news:41373ffa@forums-2-dub...
> > I am trying to use a datastore in one of my classes but when I try to
set
> > the transaction I get the error:
> > "An unhandled exception of type
> > 'Sybase.DataWindow.DataWindowNotCreatedException' occurred in
> datawindow.dll
> > Additional information: SetTransaction was called when no DataWindow
> object
> > was attached."
> >
> > my code:
> > public class Engine
> > {
> > protected Transaction SQLCA;
> > protected DataStore dsData;
> >
> > public Engine()
> > {
> > SQLCA = new Transaction();
> > SQLCA.Database = "*";
> > SQLCA.Dbms = DbmsType.Informix9;
> > SQLCA.Password = "*";
> > SQLCA.ServerName = "*";
> > SQLCA.UserId = "*";
> >
> > dsData = new DataStore();
> > dsData.DataWindowObject = "d_eng_modl";
> > dsData.LibraryList = @"C:\Develop\dw.net\maintenance.net.pbl";
> > }
> >
> > public DataWindowFullState GetData()
> > {
> > SQLCA.Connect();
> > dsData.SetTransaction(SQLCA); <<<< here I get the error
> > DataWindowFullState FullState = null;
> > dsData.Retrieve();
> > FullState = dsData.GetFullState();
> > return FullState;
> > }
> > }
> >
> >
> >
> > --
> > Regards,
> >
> > Silvio Piovesan
> > Analyst Programmer
> > Capita Business Services Limited
> > London.
> >
> >
>
>


Jim O'Neil [Sybase] Posted on 2004-09-02 16:12:18.0Z
From: "Jim O'Neil [Sybase]" <joneil_at_sybase_dot_com>
Newsgroups: sybase.public.datawindow.net
Subject: Re: datastore.net
Message-ID: <9tgej051vnr0okldhijin9ddr3kne2nnbm@4ax.com>
References: <41373ffa@forums-2-dub> <41374150$1@forums-1-dub> <41374363@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.652
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: joneilw2k.sybase.com
X-Original-NNTP-Posting-Host: joneilw2k.sybase.com
Date: 2 Sep 2004 09:12:18 -0700
X-Trace: forums-1-dub 1094141538 10.18.63.187 (2 Sep 2004 09:12:18 -0700)
X-Original-Trace: 2 Sep 2004 09:12:18 -0700, joneilw2k.sybase.com
Lines: 17
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:291
Article PK: 124722

I think the explanation is a little simpler though. You need to set
the library list BEFORE the datawindow object. When you assigne the
DataWindowObject is looks for in the list - and at this point of the
code there is no library list.

On 2 Sep 2004 08:59:31 -0700, "Silvio Piovesan"

<silvio.piovesan@_no_spam_capita.co.uk> wrote:

>Thanks Jack
>
>it works!
>
>FYIO the @ in front of the string makes the compiler scape special chars.
>that means
>"C:\\Develop\\dw.net\\maintenance.net.pbl" =
>@"C:\Develop\dw.net\maintenance.net.pbl"