ODBC string Error

[Anonymous]

Hi

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 · Accepted solution]

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

[avinashelite]

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]

Hi.

Make test of connection in server.

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

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

Hope this helps!