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

Resolved Appeon - Failed to connect database through ODBC

  1. Issue
0
Votes
Undo
  1. Bhagrudin Hajabuhari
    Bhagrudin Hajabuhari
  2. PowerBuilder
  3. Thursday, 14 March 2019 07:00 AM UTC

Hi,

 

We have installed Appeon and and the database is Oracle and it is connected through ODBC. It is working perfectly in 32 bit server.

 

When we moved to 64 bit server. the ODBC is not working correctly when we connect database  in Appeon. it is throwing "Failed to connect database error".

 

Please hep on to connect Appeon through ODBC.

 

Regards,

Badar

TLS versions 1.1 support
.Net Assembly doesn't PBAny, need a solution to de...
Responses (3)
Kai Zhao @Appeon
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Friday, 15 March 2019 00:30 AM UTC
  2. PowerBuilder
  3. # 1

Hi Badar,

Because PowerServer does not connect to Oracle over ODBC drvier, I guess you are talk PowerBuilder. please check it is a 64-bit or 32-bit ODBC data source, if the data source work well? and please make sure you had deploy PB appliation to correct platform(32-bit or 64-bit).

Regards,
ZhaoKai

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 14 March 2019 19:46 PM UTC
  2. PowerBuilder
  3. # 2

Hi Badar;

  Unlike Marco, if I assume that you mean PowerServer when you say "Appeon" (which is a non-product descript ) - then yes, the 32bit ODBC DSN will not work as PS is most likely 64 bit in nature. You will need a 64 bit ODBC driver for your DBMS and then create a 64 bit DSN in order to connect via PS's "Data Source" definition.

HTH

Regards ... Chris

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Friday, 15 March 2019 04:12 AM UTC
Just to clarify on what Chris said, ODBC is not supported connection type when using PowerServer Web or Mobile in combination with Oracle database. It is clearly written in the documentation that Oracle native driver should be used: https://www.appeon.com/support/documents/appeon_online_help/ps2019/installation_guide/ch02s03.html So using ODBC would be completely at your own risk without any tech support from Appeon.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 15 March 2019 14:14 PM UTC
Just to add to Armeen's comment ... you will need the "64bit" native Oracle drivers for PowerServer.
  1. Helpful
There are no comments made yet.
Marco Meoni
Marco Meoni Accepted Answer Pending Moderation
  1. Thursday, 14 March 2019 08:15 AM UTC
  2. PowerBuilder
  3. # 3

Hi Bhagrudin,

> "When we moved to 64 bit server. the ODBC is not working correctly when we connect database  in Appeon"

I assume by "Appeon" you mean the PB IDE, which is a 32bit application and needs 32bit datasources in its "Database profile". So, have 32bit ODBC driver on your dev machine to connect the Oracle server.

You can instead use 64bit Oracle ODBC from 64bit compiled (EXE) applications (flag the "64bit platform" option in the application project).

Best,

.m

P.S.

If, by any chance, by "Appeon" you mean PowerServer, this will need 64bit Native drivers, not ODBC.

Comment
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.