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

Resolved Can Not Connect to Database when I try to run the application via the PB IDE

  1. Advice
0
Votes
Undo
  1. Clarence Chamorro
    Clarence Chamorro
  2. PowerServer 2020 or older (Obsolete)
  3. Saturday, 17 June 2023 16:35 PM UTC

I just installed PB 2019 R3 build 2797 (latest). Everything looks and it is working good. The only issue I am having is when I try to run the application via the IDE we get this Connection Failed (999 SQLState = IM002: [Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified. message.

I check and the Data Source name is in the ODBC User Data Sources list. We tested the connectivity and it work perfect.

Could you please give me an advice or direction to take with this minor issue that I am having.

Regards,

 

Clarence.

  1. PowerBuilder (Appeon)
请问下，我在win11最新系统里面打开应用，好像控件是安装了，但一闪就没了，打不开网页
Change icono Appeon Workspace
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Saturday, 17 June 2023 17:51 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hi Clarence;

   Make sure that the DSN matches the bitness of your App's EXE. Otherwise, that type of error would occur. HTH

Regards... Chris 

Comment
Clarence Chamorro
  1. Clarence Chamorro
  2. Sunday, 9 July 2023 16:14 PM UTC
Dr. Pollach Thank you for replaying to my question; I appreciate it.



The issue was that the odbc data source was created in 64Bits. I created in 32Bits and everything works perfect..



Regards,



Clarence
  1. Helpful 1
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Sunday, 9 July 2023 17:08 PM UTC
Hi Clarence;

Thank you for the feedback & great news!

Regards ... Chris
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Sunday, 9 July 2023 19:00 PM UTC
Tip: If you see a profile in the ODBC admin tool 32 bit and when the 'config' button of a profile is disabled, then you know that that profile is a 64 bit profile.
  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.