topic Re: Connecting to pgAdminIII in QlikView

Connecting to pgAdminIII

Mon, 11 Nov 2013 05:40:35 GMT

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

Re: Connecting to pgAdminIII

Mon, 11 Nov 2013 08:14:24 GMT

bump

Re: Connecting to pgAdminIII

Sokkorn — Mon, 11 Nov 2013 08:16:40 GMT

Hi Donna,

Are you using 32bit or 64bit?

Regards,

Sokkorn

Re: Connecting to pgAdminIII

Mon, 11 Nov 2013 08:35:08 GMT

Hi!

I'm using 64bit

Thanks!

Re: Connecting to pgAdminIII

Sokkorn — Mon, 11 Nov 2013 08:40:50 GMT

Hi Donna,

Let do this:

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

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

Regards,

Sokkorn

Re: Connecting to pgAdminIII

Thu, 14 Nov 2013 05:17:27 GMT

Hi Sokkorn,

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

Thanks,

Yddona

Re: Connecting to pgAdminIII

Sokkorn — Thu, 14 Nov 2013 06:15:08 GMT

Hi Yddona,

You're welcome .

Regards,

Sokkorn