topic ODBC string Error in QlikView

ODBC string Error

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

I have couple ODBC connections in my qlikview file. they are running when reloading manually

when I'm doing the same through QMC its throwing error.. connection string error

I have tried force 32 bit option too and also OLEDB for Oracle but still no luck....Any suggestions...pls

John

buzzy996 — Wed, 10 Jun 2015 12:52:14 GMT

may be,ur odbc connection was created on USER DSN tab,u supposed to be create dsn connection SYSTEM DSN tab.

avinashelite — Wed, 10 Jun 2015 12:57:53 GMT

If your using ODBC connection then please add the SYSTEM DSN connection in the server if your using OLEDB then its not needed

jonas_rezende — Wed, 10 Jun 2015 17:56:37 GMT

Hi.

Make test of connection in server.

Create one file of extension udl in server;
Choice in Provider tab, the driver Oracle Provider for OLE DB, click Next;
In connection tab, insert her data connection: datasource, name user and password;
After, click in button Test Connection.

So, you find the cause problem: Driver, tnsnames, firewall, etc.

Hope this helps!