1. intouch intouch
  2. PowerBuilder
  3. Wednesday, 10 January 2018

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

Govinda Lopez Accepted Answer Pending Moderation
0
Votes
Undo

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








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. intouch intouch
  2. Thursday, 11 January 2018
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. Govinda Lopez
  2. Thursday, 11 January 2018
There are no comments made yet.
  1. Wednesday, 10 January 2018
  2. PowerBuilder
  3. # 1
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

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
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. intouch intouch
  2. Thursday, 11 January 2018
There are no comments made yet.
  1. Wednesday, 10 January 2018
  2. PowerBuilder
  3. # 2
  • Page :
  • 1


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