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

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

Advice

Votes

Undo

Clarence Chamorro
PowerServer 2020 or older (Obsolete)
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.

PowerBuilder (Appeon)

Responses (1)

Chris Pollach @Appeon Accepted Answer Pending Moderation

Saturday, 17 June 2023 17:51 PM UTC
PowerServer 2020 or older (Obsolete)
# 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
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

Helpful 1

Chris Pollach @Appeon
Sunday, 9 July 2023 17:08 PM UTC

Hi Clarence;

Thank you for the feedback & great news!

Regards ... Chris

Helpful 0

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

Helpful 0

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.

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Forgot Password?

We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.