1. Sylvain .
  2. PowerServer Web
  3. Monday, 10 December 2018
I have an application written in PB2017R3 that run perfectly on a desktop (exe),
 
When that application need to read or update it always goes thru the same logic.
 
  Connect to database.
  Call a special stored procedure that will set some database session variables that are required
  by our functions and procedures within the database session.
   :
     do what we need to do...
   :
  Disconnect from database.
 
When I run that exact same app on Powerserver Web (Or Mobile), it do not work in certain area
 specially when a datawindow access a store procedure. I found out that the variables set by the
 special store procedure mention earlier are now NULL for some reason. The only thing I can think 
 of is that even if I connect to the database on my own Powerserver seem to disconnect and re-connect
 within my transaction and because of this the session variable are lost and my functions and
 procedures within the database now collapse.
 
I made sure that the following was configure:
 
 PowerServer toolkit configuration
   Application profile (configuration)
     DB Settings
        The check box for 'Start transaction when executing stored procedures' is OFF/Disabled
 
I tried to find something else in the documentation that would explain this behavior without success.
 
Because of this situation I simply cannot run under Powerserver Web and/or Mobile.

Can anybody point me in the right direction/documentation...
 
Any help will be greatly appreciated.
TIA
Sylvain
 
Sylvain . Accepted Answer Pending Moderation
0
Votes
Undo

Hi Chris,

Once again thank you for your help, here is the info requested:

 

What version & build of PowerServer are you running?

     PowerBuilder Universal Edition 2017R3  Build 1858

     Is there a specific version for PS, if so where do I find it?

 

What DBMS and version are you using?

     MySQL   Server 5.6.26

 

What DB Client are you using to connect?

     PB Exe -  MySQL ODBC 5.3.4 ANSI

     Web/Mobile   Native Driver,  I do not know the version it is the only option in the 'Data Source Profiles'

 

 

 

Comment
Hi Chris,



the SQLCA.DBMS = "ODB-MYS" do not work either, same error:

Keyword not supported. Parameter name: dsn



Like I said in the documentation they say that only the following are supported by ODBC:

SAP SQL Anywhere 8.0.2/9.0/10.0.1

SAP ASE 12.5.x/15.x

SAP HANA 1.00.36



Do you of any documentation that would explain in deep how they work with the connection to the database under PowerServer, if not I think I will open a ticket because this is killing us right now...



TIA

Sylvain
  1. Sylvain .
  2. Wednesday, 12 December 2018
From what I can see in the PS Documentation ... looks like the "CacheName" feature for MySQL is only supported when using ODBC and not when the "native" driver is being used to access MySQL in the Data Source definition.

  1. Chris Pollach
  2. Wednesday, 12 December 2018
You probably refer to 'Dynamic transaction object to data source mapping'

For native nothing is in that column, and it look that it work with "ODBC"

or "ODB-MYS" I tried both and it connect.



I really think that I will open a ticket because I have to find a solution to this

and it is really killing us it has to work...



TIA

Sylvain

  1. Sylvain .
  2. Wednesday, 12 December 2018
There are no comments made yet.
  1. Monday, 10 December 2018
  2. PowerServer Web
  3. # 1
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

Hi Sylvain;

  Can you tell us ...

  1. What version & build of PowerServer are you running?
  2. What DBMS and version are you using?
  3. What DB Client are you using to connect?

Regards ... Chris

Comment
There are no comments made yet.
  1. Monday, 10 December 2018
  2. PowerServer Web
  3. # 2
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.