1. Andres Slachevsky
  2. PowerServer Web
  3. Thursday, 19 April 2018

using AppeonServer 2016 Under .net

i must use ODBC cause is a INGRES database and the only way we found to do it.

if we can not succed all our project will fail.

When i define a DataSource in the AEM the results are 

 

Testing Data Source sicaj_ingress succeeded.

 

 

When i do connect using ; from the pb application i get this error in the sqlerrtext

Keyword not supported: 'dsn'.

in the PowerServer Logs i found this:

2018-04-19 09:34:45.336 : [Application name=sicaj_planilla,conn cache=sicaj_ingress]Keyword not supported: 'dsn'.

   at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)

   at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)

   at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)

   at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)

   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)

   at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key)

   at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)

   at System.Data.SqlClient.SqlConnection..ctor(String connectionString, SqlCredential credential)

   at Appeon.Server.Services.DataService.DataServiceFactory.CreateDBConnection(PBTransactionProperties pbTrans, String connCache)

   at Appeon.Server.Commands.ConnectDBCommand.AttempToConnectDatabase()

   at Appeon.Server.Commands.ConnectDBCommand.Execute()

Appeon Support Team Accepted Answer Pending Moderation
0
Votes
Undo

Hi Andres,

PowerServer does not support the INGRES database. To understand the Database drivers supported by Appeon on .Net version you can refer to the Appeon online help with the link below.

https://www.appeon.com/support/documents/appeon_online_help/2017/server_configuration_guide_for_net/supported_database_drivers.html

Regards,
ZhaoKai

Comment
Bingo!



Thanks for the link- lead me to this- which would be super helpful if there was a note about it in the PB 2017 help file!



https://www.appeon.com/support/documents/appeon_online_help/2017/server_configuration_guide_for_net/setting_up_transaction_object_to_connection_cache_mapping.html

  1. Richard Bianco
  2. Monday, 6 August 2018
Well still encountering problems, AEM freezes when trying to test the SQL connection, not entirely frozen but unresponsive. SQL Server shows no connection and AEM will not function until it dies many minutes later. Something must be set wrong w/ my server or IIS settings. Probably should make a new thread for this instead of hijacking this one even though I get same message from the PB side after deploy & test.
  1. Richard Bianco
  2. Monday, 6 August 2018
Hi,



What's the detail error, the default timeout of trying to connect to database is 120 seconds, please wait a moment t see the error.

And please refer to article below to solve the connect to SQL Server issue.

https://support.appeon.com/index.php?/Knowledgebase/Article/View/48/11/cannot-connect-to-the-sql-server



Regards,

ZhaoKai
  1. Appeon Support Team
  2. Tuesday, 7 August 2018
There are no comments made yet.
  1. Monday, 23 April 2018
  2. PowerServer Web
  3. # 1
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

HI Andres;

       At this time, neither PowerBuilder or PowerServer are officially support the Ingres DBMS. However, you might be able to use ODBC drivers from Ingres for this. Make sure though that you have the 32bit Ingres ODBC driver in use for the PB IDE as it is only 32bit as well. For PowerServer, if you have installed the 64bit version of PS - make sure that you use the 64bit Ingres ODBC driver.

      In the case of the PB IDE and its generated EXE applications - you may also need to add an entry into the PBODBC170.INI file for the Ingress connection profile.

      Please create a Support Ticket as an enhancement request for this DBMS to be officially supported.

Regards ... Chris

Comment
Hello Chris.



i did that i set the Data Source as a ODBC and when i test it it works.



the problem is running the application from Appeon Server i get the error 



2018-04-19 09:34:45.336 : [Application name=sicaj_planilla,conn cache=sicaj]Keyword not supported: 'dsn'.

  1. Andres Slachevsky
  2. Friday, 20 April 2018
Hi Andres;



   Were you able to create a Data Source for Ingres in PowerServer and test it OK via the AEM console utility?



Regards ... Chris

  1. Chris Pollach
  2. Friday, 20 April 2018
There are no comments made yet.
  1. Thursday, 19 April 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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies. Learn More