Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Connecting to pgAdminIII

Hi All,

I'm having trouble connecting to pgAdminIII. I have already installed the driver and was able to connect successfully to the database.(on the Data Source)

But when I connect to qlikview I get this error:

Connection Test Failed

SQL##f - SqlState: IM014, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

Can anyone indicate what is this problem? And have you tried connecting to pgAdminIII and what are your drivers installed.

Thank you in advance,

Donna

1 Solution

Accepted Solutions
Sokkorn
Master
Master

Hi Donna,

Let do this:

1. Create ODBC using 32bit version via C:\Windows\SysWOW64

1.png

2. Check on "Force 32 Bit" -> Click on "Connect..." -> Select ODBC you just create above

2.png

Regards,

Sokkorn

View solution in original post

6 Replies
Not applicable
Author

bump

Sokkorn
Master
Master

Hi Donna,

Are you using 32bit or 64bit?

Regards,

Sokkorn

Not applicable
Author

Hi!

I'm using 64bit

Thanks!

Sokkorn
Master
Master

Hi Donna,

Let do this:

1. Create ODBC using 32bit version via C:\Windows\SysWOW64

1.png

2. Check on "Force 32 Bit" -> Click on "Connect..." -> Select ODBC you just create above

2.png

Regards,

Sokkorn

Not applicable
Author

Hi Sokkorn,

Thank you and sorry for the late reply. I can now connect.

Thanks,

Yddona

Sokkorn
Master
Master

Hi Yddona,

You're welcome .

Regards,

Sokkorn