1. Willian Padilha
  2. PowerServer Web
  3. Monday, 23 October 2017

I have set the datasource​

and my PowerScript is this

CONNECT USING SQLCA;

Retrieve is working fine, but Update, Insert and Delete not

 

my Datawindow Sql Code

 

anyone have any idea what may be wrong?

Very grateful for any response

 

Sorry for my bad English.
Greetings from Paraguay

Accepted Answer
Willian Padilha Accepted Answer Pending Moderation
0
Votes
Undo

[SOLVED]

The problem is in MySQL config

my.ini/cnf

sql_mode =ANSI_QUOTES

SET GLOBAL SQL_MODE=ANSI_QUOTES;

 

Thanks Marcos for your time and help

 

 

Comment
There are no comments made yet.
  1. Monday, 23 October 2017
  2. PowerServer Web
  3. # Permalink
Marco Meoni Accepted Answer Pending Moderation
0
Votes
Undo

Hi,

Google for "OPTION=135168" to include in the transaction object's DBParm property, for example:

SQLCA.DBParm = "ConnectString='DSN=mydb;UID=;PWD=;OPTION=135168'

That should fix your problem.

Cheers,

Marco

Comment
Hello Marco, but I am not using DBPARM, because APPEON already caches it automatically



 



See HELP (I'm use Static Option)



https://www.appeon.com/support/documents/appeon_online_help/1.5/server_configuration_guide_for_net/ch04s04s02.html#Transaction_Objects

  1. Willian Padilha
  2. Monday, 23 October 2017
Yes sure, I just pointed you to the syntax. In Appeon you may wanna try to specify any extended DBParm attribute in the data source -> Extended Options.



See Appeon help: "Specify the connection parameters that are not listed above. The value should be in this format: "parameter_name=###" where "parameter_name" is the name of the connection parameter, for example, TextSize=64000, this sets the maximum size of text or binary data sent or received from ASE to 64 KB. If there are more than one parameter, separate them by semicolon (";")."



Cheers,



Marco



P.S.



I assume you're using MySQL native driver, not ODBC.

  1. Marco Meoni
  2. Monday, 23 October 2017
I already tried to use the extended options, but there was no change Marco.



would you know to indicate which parameter name might indicate in the extended options?



Mysql Native Driver (as you can see in the first image)

  1. Willian Padilha
  2. Monday, 23 October 2017
There are no comments made yet.
  1. Monday, 23 October 2017
  2. PowerServer Web
  3. # 1
  • Page :
  • 1


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