Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Honored Contributor

Re: Connecting to pgAdminIII

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

6 Replies
Not applicable

Re: Connecting to pgAdminIII

bump

Sokkorn
Honored Contributor

Re: Connecting to pgAdminIII

Hi Donna,

Are you using 32bit or 64bit?

Regards,

Sokkorn

Not applicable

Re: Connecting to pgAdminIII

Hi!

I'm using 64bit

Thanks!

Sokkorn
Honored Contributor

Re: Connecting to pgAdminIII

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

Re: Connecting to pgAdminIII

Hi Sokkorn,

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

Thanks,

Yddona

Sokkorn
Honored Contributor

Re: Connecting to pgAdminIII

Hi Yddona,

You're welcome .

Regards,

Sokkorn

Community Browser