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.

Newbie. Connect datastore to database in MTS component.

3 posts in General Discussion (old) Last posting was on 2000-03-20 16:29:31.0Z
Jamie White Posted on 2000-03-17 14:33:52.0Z
Newsgroups: sybase.public.easerver
From: "Jamie White" <jwhite@naroyal.com>
Subject: Newbie. Connect datastore to database in MTS component.
Date: Fri, 17 Mar 2000 09:33:52 -0500
Lines: 19
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: 199.79.243.60
Message-ID: <347_1a8yl3Bk$GA.261@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:1610
Article PK: 130931

I'm fairly experienced with PB client-server and using the transaciton
objects. Now though I want to use an MTS component to 1.create a datastore,
2.connect to database, 3.retrieve data, 4.do some processing, and 5.return
HTML to an ASP page. Everything seems pretty straightforward except for #2.

I tried using standard client-server where you set properties of SQLCA and
connect but this doesn't work. I actually get the error when I attempt to
setTransObject on my datastore. BOL seems to just skip over this topic all
they say is "Connect to your database." then there is a big discussion on
using ADO result sets.

I've already successfully created and loaded the componenet into MTS. Each
step is broken out into a seperate function so that I can easily test them.
I am using PB 7.0, IIS 4.0, and MTS 2.0.

Thanks,
Jamie White


Dean Jones [TeamSybase] Posted on 2000-03-18 01:56:02.0Z
Newsgroups: sybase.public.easerver
From: "Dean Jones [TeamSybase]" <dean_no_spam@powerobjects.com>
Subject: Re: Newbie. Connect datastore to database in MTS component.
Date: Fri, 17 Mar 2000 19:56:02 -0600
Lines: 40
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: dsl131.outtech.com 216.207.145.131
Message-ID: <347_zZW144Hk$GA.285@forums.sybase.com>
References: <347_1a8yl3Bk$GA.261@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:1609
Article PK: 130930

Are you using a native driver or ODBC? If you are using ODBC make sure it is
a System DSN.

HTH

--
Dean Jones, CPD Professional
PowerTeam, In.
http://www.powerobjects.com

http://www.powerobjects.com/seminar

Jamie White <jwhite@naroyal.com> wrote in message
news:1a8yl3Bk$GA.261@forums.sybase.com...
> I'm fairly experienced with PB client-server and using the transaciton
> objects. Now though I want to use an MTS component to 1.create a
datastore,
> 2.connect to database, 3.retrieve data, 4.do some processing, and 5.return
> HTML to an ASP page. Everything seems pretty straightforward except for
#2.
>
> I tried using standard client-server where you set properties of SQLCA and
> connect but this doesn't work. I actually get the error when I attempt to
> setTransObject on my datastore. BOL seems to just skip over this topic
all
> they say is "Connect to your database." then there is a big discussion on
> using ADO result sets.
>
> I've already successfully created and loaded the componenet into MTS.
Each
> step is broken out into a seperate function so that I can easily test
them.
> I am using PB 7.0, IIS 4.0, and MTS 2.0.
>
> Thanks,
> Jamie White
>
>


Jamie White Posted on 2000-03-20 16:29:31.0Z
Newsgroups: sybase.public.easerver
From: "Jamie White" <jwhite@naroyal.com>
Subject: Re: Newbie. Connect datastore to database in MTS component.
Date: Mon, 20 Mar 2000 11:29:31 -0500
Lines: 32
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: 199.79.243.60
Message-ID: <347_pjHtRmok$GA.34@forums.sybase.com>
References: <347_1a8yl3Bk$GA.261@forums.sybase.com> <347_zZW144Hk$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:1608
Article PK: 130929

Thanks for your help, Dean.

Turns out the problem was that my MS SQL Server machine did not have DTC
turned on. I feel silly now :) Once that was fixed I was able to create,
set, and destroy Transaction Objects no problem.

In the process I discovered what a GREAT! tool the PowerBuilder profile
creator is for creating ODBC connect strings.

Jamie White

Dean Jones [TeamSybase] wrote in message ...
>Are you using a native driver or ODBC? If you are using ODBC make sure it
is
>a System DSN.
>
>HTH
>
...
>>
>> I tried using standard client-server where you set properties of SQLCA
and
>> connect but this doesn't work. I actually get the error when I attempt
to
>> setTransObject on my datastore. BOL seems to just skip over this topic
>> I've already successfully created and loaded the componenet into MTS.
...
>> I am using PB 7.0, IIS 4.0, and MTS 2.0.
>>