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




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 

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


  1. Helpful 1
  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
  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.