Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved PowerServer Error connecting using ODBC

  1. Issue
0
Votes
Undo
  1. Andres Slachevsky
    Andres Slachevsky
  2. PowerServer 2020 or older (Obsolete)
  3. Thursday, 19 April 2018 14:41 PM UTC

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()

  1. PowerServer
  2. ODBC
MS SQL Server 2016 Timestamp and PowerServer Web
Installable Web App - 3rd Party OLE, OCXs, DLLS an...
Responses (2)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 19 April 2018 15:28 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

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
Andres Slachevsky
  1. Andres Slachevsky
  2. Friday, 20 April 2018 11:59 AM UTC
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. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 20 April 2018 13:26 PM UTC
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. Helpful
There are no comments made yet.
Appeon Support Team
Appeon Support Team Accepted Answer Pending Moderation
  1. Monday, 23 April 2018 00:44 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

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
Load more comments
Richard Bianco
  1. Richard Bianco
  2. Monday, 6 August 2018 19:58 PM UTC
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. Helpful
Richard Bianco
  1. Richard Bianco
  2. Monday, 6 August 2018 20:12 PM UTC
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. Helpful
Appeon Support Team
  1. Appeon Support Team
  2. Tuesday, 7 August 2018 00:38 AM UTC
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. 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.