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.

Powerbuilder 12.5.1 .NET SQL Server connection problem

5 posts in .NET Last posting was on 2012-11-15 17:29:40Z
Thomas Chiu Posted on 2012-11-02 16:20:34Z
Sender: 7f08.5093f158.1804289383@sybase.com
From: Thomas Chiu
Newsgroups: sybase.public.powerbuilder.net
Subject: Powerbuilder 12.5.1 .NET SQL Server connection problem
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <5093f2d2.7f86.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 2 Nov 2012 08:20:34 -0800
X-Trace: forums-1-dub 1351873234 172.20.134.41 (2 Nov 2012 08:20:34 -0800)
X-Original-Trace: 2 Nov 2012 08:20:34 -0800, 172.20.134.41
Lines: 26
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.net:4516
Article PK: 705362

Hi,
I created simple application in Powerbuilder 12.5.1 Build
4595 which connects to a SQL Server 2008 R2 database. I am
using the SQL Server native client has the connection
method.

When I try to connect to the database within code, I am
getting a Transaction Not Connected Error with a sqlcode of
-1.

The error is coming from a client machine which has Windows
XP SP3 installed.

I have installed the SQL Server 2008 R2 native client
drivers along with the PB.NET 12.5 runtime libraries which
was generated via Sybase's runtime packager.

So my question is are there libraries that are missing from
the runtime packager that would prevent me from connecting
to our SQL Server?

Also, just to simulate that it is a sql server driver issue,
I changed the password to an invalid password and tried it
again. I don't get the "Invalid password" error message, it
is also the Transaction Not Connected message. Any ideas on
why this is happening?


Chris Pollach Posted on 2012-11-02 16:34:21Z
From: Chris Pollach <cpollach@travel-net.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:16.0) Gecko/20121026 Thunderbird/16.0.2
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.net
Subject: Re: Powerbuilder 12.5.1 .NET SQL Server connection problem
References: <5093f2d2.7f86.1681692777@sybase.com>
In-Reply-To: <5093f2d2.7f86.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <5093f60d$1@forums-1-dub>
Date: 2 Nov 2012 08:34:21 -0800
X-Trace: forums-1-dub 1351874061 172.20.134.152 (2 Nov 2012 08:34:21 -0800)
X-Original-Trace: 2 Nov 2012 08:34:21 -0800, vip152.sybase.com
Lines: 46
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.net:4517
Article PK: 705359

Hi Thomas;

Have a llok in the PB Help sub-system and search for the key word
"deploy". That should bring you to a list of required DLL's that you
need by feature and where they need to go.

HTH

--
Regards ... Chris
President: OSUG / STD Inc.
Vice President: ISUG
Blog: http://chrispollach.blogspot.com
SourceForge: http://sourceforge.net/projects/stdfndclass
PBDJ: http://chrispollach.sys-con.com

On 11/2/2012 12:20 PM, Thomas Chiu wrote:
> Hi,
> I created simple application in Powerbuilder 12.5.1 Build
> 4595 which connects to a SQL Server 2008 R2 database. I am
> using the SQL Server native client has the connection
> method.
>
> When I try to connect to the database within code, I am
> getting a Transaction Not Connected Error with a sqlcode of
> -1.
>
> The error is coming from a client machine which has Windows
> XP SP3 installed.
>
> I have installed the SQL Server 2008 R2 native client
> drivers along with the PB.NET 12.5 runtime libraries which
> was generated via Sybase's runtime packager.
>
> So my question is are there libraries that are missing from
> the runtime packager that would prevent me from connecting
> to our SQL Server?
>
> Also, just to simulate that it is a sql server driver issue,
> I changed the password to an invalid password and tried it
> again. I don't get the "Invalid password" error message, it
> is also the Transaction Not Connected message. Any ideas on
> why this is happening?
>


Andreas Mykonios Posted on 2012-11-05 10:38:09Z
From: Andreas Mykonios <Andreas Mykonios>
Newsgroups: sybase.public.powerbuilder.net
Subject: Re: Powerbuilder 12.5.1 .NET SQL Server connection problem
Message-ID: <dk5f98d0dbsmu37m71t6bap8acgt4n3rv2@4ax.com>
References: <5093f2d2.7f86.1681692777@sybase.com>
X-Newsreader: Forte Agent 4.2/32.1118
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 5 Nov 2012 02:38:09 -0800
X-Trace: forums-1-dub 1352111889 172.20.134.152 (5 Nov 2012 02:38:09 -0800)
X-Original-Trace: 5 Nov 2012 02:38:09 -0800, vip152.sybase.com
Lines: 41
X-Authenticated-User: pb125beta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.net:4521
Article PK: 705360

Hi.

Do not forget to deploy with runtime msvcp100.dll,
msvcr100.dll and probably msvcp71.dll, msvcr71.dll, atl71.dll.

I had the same issue, wich disappeared when I deployed those files
with the pb.net runtime. Also I've read in some posts that pb.net
needs some files from pb.classic runtime (pbvm), but I'm not sure, as
my client machines have both runtimes installed.

Andreas.

On 2 Nov 2012 08:20:34 -0800, Thomas Chiu wrote:

>Hi,
>I created simple application in Powerbuilder 12.5.1 Build
>4595 which connects to a SQL Server 2008 R2 database. I am
>using the SQL Server native client has the connection
>method.
>
>When I try to connect to the database within code, I am
>getting a Transaction Not Connected Error with a sqlcode of
>-1.
>
>The error is coming from a client machine which has Windows
>XP SP3 installed.
>
>I have installed the SQL Server 2008 R2 native client
>drivers along with the PB.NET 12.5 runtime libraries which
>was generated via Sybase's runtime packager.
>
>So my question is are there libraries that are missing from
>the runtime packager that would prevent me from connecting
>to our SQL Server?
>
>Also, just to simulate that it is a sql server driver issue,
>I changed the password to an invalid password and tried it
>again. I don't get the "Invalid password" error message, it
>is also the Transaction Not Connected message. Any ideas on
>why this is happening?


Chris Pollach Posted on 2012-11-05 12:46:56Z
From: Chris Pollach <cpollach@travel-net.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:16.0) Gecko/20121026 Thunderbird/16.0.2
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.net
Subject: Re: Powerbuilder 12.5.1 .NET SQL Server connection problem
References: <5093f2d2.7f86.1681692777@sybase.com> <dk5f98d0dbsmu37m71t6bap8acgt4n3rv2@4ax.com>
In-Reply-To: <dk5f98d0dbsmu37m71t6bap8acgt4n3rv2@4ax.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <5097b540@forums-1-dub>
Date: 5 Nov 2012 04:46:56 -0800
X-Trace: forums-1-dub 1352119616 172.20.134.152 (5 Nov 2012 04:46:56 -0800)
X-Original-Trace: 5 Nov 2012 04:46:56 -0800, vip152.sybase.com
Lines: 48
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.net:4522
Article PK: 705365

You are correct, PB.Net still uses part of PB Classic's run-time!

On 11/5/2012 5:38 AM, Andreas Mykonios wrote:
> Hi.
>
> Do not forget to deploy with runtime msvcp100.dll,
> msvcr100.dll and probably msvcp71.dll, msvcr71.dll, atl71.dll.
>
> I had the same issue, wich disappeared when I deployed those files
> with the pb.net runtime. Also I've read in some posts that pb.net
> needs some files from pb.classic runtime (pbvm), but I'm not sure, as
> my client machines have both runtimes installed.
>
> Andreas.
>
>
> On 2 Nov 2012 08:20:34 -0800, Thomas Chiu wrote:
>
>> Hi,
>> I created simple application in Powerbuilder 12.5.1 Build
>> 4595 which connects to a SQL Server 2008 R2 database. I am
>> using the SQL Server native client has the connection
>> method.
>>
>> When I try to connect to the database within code, I am
>> getting a Transaction Not Connected Error with a sqlcode of
>> -1.
>>
>> The error is coming from a client machine which has Windows
>> XP SP3 installed.
>>
>> I have installed the SQL Server 2008 R2 native client
>> drivers along with the PB.NET 12.5 runtime libraries which
>> was generated via Sybase's runtime packager.
>>
>> So my question is are there libraries that are missing from
>> the runtime packager that would prevent me from connecting
>> to our SQL Server?
>>
>> Also, just to simulate that it is a sql server driver issue,
>> I changed the password to an invalid password and tried it
>> again. I don't get the "Invalid password" error message, it
>> is also the Transaction Not Connected message. Any ideas on
>> why this is happening?


Chris Keating (Sybase, an SAP Company) Posted on 2012-11-15 17:29:40Z
From: "Chris Keating (Sybase, an SAP Company)" <last_name@sybase.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/20121026 Thunderbird/16.0.2
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.net
Subject: Re: Powerbuilder 12.5.1 .NET SQL Server connection problem
References: <5093f2d2.7f86.1681692777@sybase.com>
In-Reply-To: <5093f2d2.7f86.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <50a52684$1@forums-1-dub>
Date: 15 Nov 2012 09:29:40 -0800
X-Trace: forums-1-dub 1353000580 172.20.134.152 (15 Nov 2012 09:29:40 -0800)
X-Original-Trace: 15 Nov 2012 09:29:40 -0800, vip152.sybase.com
Lines: 48
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.net:4553
Article PK: 705397

Did you resolve this?

Although no one else raised this, the Transaction Not Connected / -1 is
the default values for the transaction object prior to a CONNECT being
called. Are you sure that you are checking the right transaction object?
When I run this simple code,

sqlca.DBMS="SNC"
connect using sqlca;
if (sqlca.SQLCode<> 0 ) then
MessageBox( "Error", "unable to connect:"
+ sqlca.SQLErrText );
end if

the "Transaction not connected" SQLErrText is true at the Connect Using
SQLCA line but not after it is executed. After that line is executed, I
get an error from the DB client software. I would expect a different
error if the client software is not present.

On 02/11/2012 12:20 PM, Thomas Chiu wrote:
> Hi,
> I created simple application in Powerbuilder 12.5.1 Build
> 4595 which connects to a SQL Server 2008 R2 database. I am
> using the SQL Server native client has the connection
> method.
>
> When I try to connect to the database within code, I am
> getting a Transaction Not Connected Error with a sqlcode of
> -1.
>
> The error is coming from a client machine which has Windows
> XP SP3 installed.
>
> I have installed the SQL Server 2008 R2 native client
> drivers along with the PB.NET 12.5 runtime libraries which
> was generated via Sybase's runtime packager.
>
> So my question is are there libraries that are missing from
> the runtime packager that would prevent me from connecting
> to our SQL Server?
>
> Also, just to simulate that it is a sql server driver issue,
> I changed the password to an invalid password and tried it
> again. I don't get the "Invalid password" error message, it
> is also the Transaction Not Connected message. Any ideas on
> why this is happening?
>