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 10.0 connect using ADO.NET problem...

4 posts in Objects Last posting was on 2005-08-31 10:03:30.0Z
p platan Posted on 2005-08-30 09:47:34.0Z
Sender: 6408.43142403.1804289383@sybase.com
From: P Platan
Newsgroups: sybase.public.powerbuilder.objects
Subject: PB 10.0 connect using ADO.NET problem...
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <43142b32.64a6.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 30 Aug 2005 02:47:30 -0700, 10.22.241.42
Lines: 30
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 30 Aug 2005 02:47:31 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 30 Aug 2005 02:47:34 -0700
X-Trace: forums-1-dub 1125395254 10.22.108.75 (30 Aug 2005 02:47:34 -0700)
X-Original-Trace: 30 Aug 2005 02:47:34 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:8558
Article PK: 735783

Hi,
I am using Powerbuilder 10.0 , XP SP2 , Microsoft SQL Server
2000 and the Net Framework is installed.
I am having problem connecting to Microsoft SQLSERVER 2000
using ADO.NET
My connection is
// Profile sqlado
SQLCA.DBMS = "TRACE ADO.Net"
SQLCA.LogPass = "123"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = True
SQLCA.DBParm="Namespace='System.Data.OleDb',DATASOURCE='internetpc'
,Database='db1',Provider='SQLOLEDB',PROVIDERSTRING='database=db1'
,DelimitIdentifier='Yes',PBCatalogOwner='dbo',DefaultProcOwner='dbo'"

The trace file is
/*---------------------------------------------------*/
/* 29/8/2005 23:40 */
/*---------------------------------------------------*/
(1ba7a40): LOGIN: (0 MilliSeconds)
(1ba7a40):
Error 999 (rc -1) : Failed to create a instance of type
DbRoutine.
(1ba7a40): SHUTDOWN DATABASE INTERFACE: (0 MilliSeconds)

I searched the internet to find out what this message
actually means but I had no luck yet.

Any clues?
Thanx in advance...


Jim O'Neil [Sybase] Posted on 2005-08-30 23:03:19.0Z
From: "Jim O'Neil [Sybase]" <joneil_at_sybase_dot_com>
Newsgroups: sybase.public.powerbuilder.objects
Subject: Re: PB 10.0 connect using ADO.NET problem...
Message-ID: <7cp9h1pbi3gf6rijtld5evrelajqs4va7b@4ax.com>
References: <43142b32.64a6.1681692777@sybase.com>
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: 30 Aug 2005 16:03:19 -0700
X-Trace: forums-1-dub 1125442999 10.18.43.183 (30 Aug 2005 16:03:19 -0700)
X-Original-Trace: 30 Aug 2005 16:03:19 -0700, joneilw2k.sybase.com
Lines: 38
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:8561
Article PK: 735781

Not that you shouldn't be able to do this, but I would recommend not
using ADO.NET with PowerBuidler. There is no advantage in doing so,
since ADO.NET just adds more overhead to the OLE-DB connectivity
already offered in PB.

On 30 Aug 2005 02:47:34 -0700, P Platan wrote:

>Hi,
>I am using Powerbuilder 10.0 , XP SP2 , Microsoft SQL Server
>2000 and the Net Framework is installed.
>I am having problem connecting to Microsoft SQLSERVER 2000
>using ADO.NET
>My connection is
>// Profile sqlado
>SQLCA.DBMS = "TRACE ADO.Net"
>SQLCA.LogPass = "123"
>SQLCA.LogId = "sa"
>SQLCA.AutoCommit = True
>SQLCA.DBParm="Namespace='System.Data.OleDb',DATASOURCE='internetpc'
>,Database='db1',Provider='SQLOLEDB',PROVIDERSTRING='database=db1'
>,DelimitIdentifier='Yes',PBCatalogOwner='dbo',DefaultProcOwner='dbo'"
>
>The trace file is
>/*---------------------------------------------------*/
>/* 29/8/2005 23:40 */
>/*---------------------------------------------------*/
>(1ba7a40): LOGIN: (0 MilliSeconds)
>(1ba7a40):
> Error 999 (rc -1) : Failed to create a instance of type
>DbRoutine.
>(1ba7a40): SHUTDOWN DATABASE INTERFACE: (0 MilliSeconds)
>
>I searched the internet to find out what this message
>actually means but I had no luck yet.
>
>Any clues?
>Thanx in advance...


p platan Posted on 2005-08-31 07:35:09.0Z
Sender: 6fc9.43155d45.846930886@sybase.com
From: P Platan
Newsgroups: sybase.public.powerbuilder.objects
Subject: Re: PB 10.0 connect using ADO.NET problem...
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <43155daa.6fce.1681692777@sybase.com>
References: <7cp9h1pbi3gf6rijtld5evrelajqs4va7b@4ax.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 31 Aug 2005 00:35:07 -0700, 10.22.241.42
Lines: 53
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 31 Aug 2005 00:35:07 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 31 Aug 2005 00:35:09 -0700
X-Trace: forums-1-dub 1125473709 10.22.108.75 (31 Aug 2005 00:35:09 -0700)
X-Original-Trace: 31 Aug 2005 00:35:09 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:8563
Article PK: 735782

Thanx for the reply!
But has anyone a clue why do I get this message?
It is not documented anywhere (at least I could not find it
in neither Sybooks nor Internet).
PB 10.0 supports namespace System.Data.OleDb
PB 10.2 in addition supports namespace
System.Data.SqlClient as well.
Does this have anything to do with my problem??

Thanx!!!

> Not that you shouldn't be able to do this, but I would
> recommend not using ADO.NET with PowerBuidler. There is
> no advantage in doing so, since ADO.NET just adds more
> overhead to the OLE-DB connectivity already offered in PB.
>
> On 30 Aug 2005 02:47:34 -0700, P Platan wrote:
>
> >Hi,
> >I am using Powerbuilder 10.0 , XP SP2 , Microsoft SQL
> Server >2000 and the Net Framework is installed.
> >I am having problem connecting to Microsoft SQLSERVER
> 2000 >using ADO.NET
> >My connection is
> >// Profile sqlado
> >SQLCA.DBMS = "TRACE ADO.Net"
> >SQLCA.LogPass = "123"
> >SQLCA.LogId = "sa"
> >SQLCA.AutoCommit = True
> >SQLCA.DBParm="Namespace='System.Data.OleDb'
> ,DATASOURCE='internetpc' >,Database='db1'
> ,Provider='SQLOLEDB',PROVIDERSTRING='database=db1' >
> ,DelimitIdentifier='Yes',PBCatalogOwner='dbo'
> ,DefaultProcOwner='dbo'" >
> >The trace file is
> >/*---------------------------------------------------*/
> >/* 29/8/2005 23:40 */
> >/*---------------------------------------------------*/
> >(1ba7a40): LOGIN: (0 MilliSeconds)
> >(1ba7a40):
> > Error 999 (rc -1) : Failed to create a instance of type
> >DbRoutine.
> >(1ba7a40): SHUTDOWN DATABASE INTERFACE: (0 MilliSeconds)
> >
> >I searched the internet to find out what this message
> >actually means but I had no luck yet.
> >
> >Any clues?
> >Thanx in advance...
>


P Platan Posted on 2005-08-31 10:03:30.0Z
From: "P Platan" <pplat@exnds.com>
Newsgroups: sybase.public.powerbuilder.objects
References: <7cp9h1pbi3gf6rijtld5evrelajqs4va7b@4ax.com> <43155daa.6fce.1681692777@sybase.com>
Subject: Re: PB 10.0 connect using ADO.NET problem...
Lines: 64
Organization: exnds
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: 213.16.165.189
Message-ID: <4315806e@forums-2-dub>
X-Original-Trace: 31 Aug 2005 03:03:26 -0700, 213.16.165.189
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 31 Aug 2005 03:03:30 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 31 Aug 2005 03:03:30 -0700
X-Trace: forums-1-dub 1125482610 10.22.108.75 (31 Aug 2005 03:03:30 -0700)
X-Original-Trace: 31 Aug 2005 03:03:30 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:8564
Article PK: 735785

update!!
When I installed PB 10.0 in the PC that has the sql server 2000 installed it
worked OK.

So, can it be a security issue or something like that?

Any suggestion from where to start looking??

<P Platan> wrote in message news:43155daa.6fce.1681692777@sybase.com...
> Thanx for the reply!
> But has anyone a clue why do I get this message?
> It is not documented anywhere (at least I could not find it
> in neither Sybooks nor Internet).
> PB 10.0 supports namespace System.Data.OleDb
> PB 10.2 in addition supports namespace
> System.Data.SqlClient as well.
> Does this have anything to do with my problem??
>
> Thanx!!!
>
>
>
>
>> Not that you shouldn't be able to do this, but I would
>> recommend not using ADO.NET with PowerBuidler. There is
>> no advantage in doing so, since ADO.NET just adds more
>> overhead to the OLE-DB connectivity already offered in PB.
>>
>> On 30 Aug 2005 02:47:34 -0700, P Platan wrote:
>>
>> >Hi,
>> >I am using Powerbuilder 10.0 , XP SP2 , Microsoft SQL
>> Server >2000 and the Net Framework is installed.
>> >I am having problem connecting to Microsoft SQLSERVER
>> 2000 >using ADO.NET
>> >My connection is
>> >// Profile sqlado
>> >SQLCA.DBMS = "TRACE ADO.Net"
>> >SQLCA.LogPass = "123"
>> >SQLCA.LogId = "sa"
>> >SQLCA.AutoCommit = True
>> >SQLCA.DBParm="Namespace='System.Data.OleDb'
>> ,DATASOURCE='internetpc' >,Database='db1'
>> ,Provider='SQLOLEDB',PROVIDERSTRING='database=db1' >
>> ,DelimitIdentifier='Yes',PBCatalogOwner='dbo'
>> ,DefaultProcOwner='dbo'" >
>> >The trace file is
>> >/*---------------------------------------------------*/
>> >/* 29/8/2005 23:40 */
>> >/*---------------------------------------------------*/
>> >(1ba7a40): LOGIN: (0 MilliSeconds)
>> >(1ba7a40):
>> > Error 999 (rc -1) : Failed to create a instance of type
>> >DbRoutine.
>> >(1ba7a40): SHUTDOWN DATABASE INTERFACE: (0 MilliSeconds)
>> >
>> >I searched the internet to find out what this message
>> >actually means but I had no luck yet.
>> >
>> >Any clues?
>> >Thanx in advance...
>>