1. Joshua Woon
  2. PowerBuilder
  3. Tuesday, 17 April 2018 08:31 AM

I was trying to setup the ODBC database profile in PB2017 for Postgresql but gotten the error:

SQLSTATE: IM014

The specified DSN contains an architecture mismatch between the Driver and Application.

Pls advise how to resolve this error.

p/s I could connect to the db successfully from the ODBC Administrator.

Miguel Leeuwee Accepted Answer Pending Moderation
  1. Sunday, 22 April 2018 08:37 AM
  2. PowerBuilder
  3. # 1
0
Votes
Undo

In addition:

If you are on a 64 bit machine, your 32 bit odbcad32.exe is located in "C:\WINDOWS\syswow64" and the one that you find in "C:\WINDOWS\system32" is the 64 bit odbc administrator (even though stupidly enough it's also called "odbcad32.exe")

 

Comment
There are no comments made yet.
Govinda Lopez @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 18 April 2018 23:01 PM
  2. PowerBuilder
  3. # 2
0
Votes
Undo

Hi Joshua,

 

As Roland said, you would need the 32 bit driver for that. But also create the 32 bit ODBC for it.

 

 

Regards,

Comment
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Tuesday, 17 April 2018 12:55 PM
  2. PowerBuilder
  3. # 3
0
Votes
Undo

The PowerBuilder IDE is a 32bit application so you need to use 32bit database drivers.

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.