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