Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Microsoft OLE DB Driver for SQL Server Disconnect

  1. Issue
0
Votes
Undo
  1. Roland Smith
    Roland Smith
  2. PowerBuilder
  3. Thursday, 2 March 2023 22:02 PM UTC

PowerBuilder 2022 Build 1892, SQL Server 2017

I am connecting with the new MSO driver in a small test app run from the IDE. The purpose of the app is to make sure I have the correct connection properties before I modify the main application.

I ran sp_who to make sure the AppName and Host values are showing. I discovered that when my app does a disconnect, the process continues about a minute before ending. If I exit PowerBuilder IDE, it ends immediately.

Here are my connection properties:

sqlca.DBMS = "MSO"
sqlca.LogId = "######"
sqlca.LogPass = "######"
sqlca.ServerName = "######"
sqlca.DBParm = "Provider='MSOLEDBSQL19',Database='######',AppName='ex_app'," + &
               "BindSPInput=1,DisableBind=1,Encrypt=0,Host='######',TrimSpaces=1"
sqlca.AutoCommit = False

Is this a bug or expected behavior? Is there a way to have the process end when disconnect is called?

Problem with editable columns in datawindows with ...
Uso de las BAPI de SAP ?
Responses (2)
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Friday, 3 March 2023 16:27 PM UTC
  2. PowerBuilder
  3. # 1

Hi Roland, Since you have small test case, can you please open a support ticket and also provide your test case so our engineers can look at this?  https://www.appeon.com/standardsupport/newbug

 

Comment
Load more comments
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Friday, 3 March 2023 18:00 PM UTC
Our team will look at it, but chances are if both do it it is not a PB bug. The MSOLEDBSQL driver we supported was new implementation has different runtime DLL: PBMSOLEDBSQL.DLL vs. the old PBSNC.DLL
  1. Helpful
Roland Smith
  1. Roland Smith
  2. Monday, 6 March 2023 14:11 PM UTC
The person looking at the bug determined it has to do with connection pooling.
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Monday, 6 March 2023 17:05 PM UTC
Thank for the feedback!
  1. Helpful
There are no comments made yet.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Thursday, 2 March 2023 22:05 PM UTC
  2. PowerBuilder
  3. # 2

I also created an EXE and it has the same behavior. The process ends when the exe does.

Comment
Load more comments
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 3 March 2023 18:52 PM UTC
Hi Roland / John;

Just curious ... In your PB App's "Application Object" was the "FREEDBLibraries" property set to ON?

Regards ... Chris
  1. Helpful
Roland Smith
  1. Roland Smith
  2. Friday, 3 March 2023 19:08 PM UTC
No, I've never turned that on. I just tried it and it had no effect.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 3 March 2023 19:53 PM UTC
Thanks for trying that Roland. It was just a guess that this might affect your issue.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.