1. intouch intouch
  2. PowerBuilder
  3. Wednesday, 10 January 2018 10:40 AM UTC

my connection in aem native mssql

 

when i update datawindow  from android mobile i got that

Conversion failed when converting date and/or time from character string

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 10 January 2018 14:53 PM UTC
  2. PowerBuilder
  3. # 1

Hi;

  I would suggest checking your AWS and PowerServer logs for more information into the failure. Check the PB & help for using AWS logging .

Regards ... Chris

Comment
  1. intouch intouch
  2. Thursday, 11 January 2018 06:07 AM UTC
where can i found it in windows application i put that in sqlca.DBParm = "DateTimeFormat='#dd/mm/yyyy#'"



how can i put it in aem setting .

  1. Helpful
There are no comments made yet.
Govinda Lopez @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 10 January 2018 17:48 PM UTC
  2. PowerBuilder
  3. # 2

Hi intouch,

 

I would also recommend you to check the Connection properties and Data Source for that specific MS SQL connection. This is done in AEM too.

 

 

Regards,

Comment
  1. intouch intouch
  2. Thursday, 11 January 2018 14:37 PM UTC








where can i found it in windows application i put that in sqlca.DBParm = "DateTimeFormat='#dd/mm/yyyy#'"



how can i put it in aem setting .











 



 







  1. Helpful
  1. Govinda Lopez @Appeon
  2. Thursday, 11 January 2018 17:50 PM UTC
Hi intouch,



 



Only some DBParm parameters are supported by PowerServer. You can find out which ones here: https://www.appeon.com/support/documents/appeon_online_help/2017/features_help_for_appeon_mobile/ch09.html



 



I recommend you to place this parameter at the database level. Configuring MS SQL server properties for that database. You can find more info here: https://docs.microsoft.com/en-us/sql/t-sql/statements/set-dateformat-transact-sql







I hope this helps.



 



Regards,

  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.