Discussion Board for collaboration on QlikView Scripting.
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,
Go to Solution.
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
Are you using 32bit or 64bit?
I'm using 64bit
Thank you and sorry for the late reply. I can now connect.
You're welcome .