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.