Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

johnhhtp2
Contributor II

ODBC string Error

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

1 Solution

Accepted Solutions
buzzy996
Honored Contributor II

Re: ODBC string Error

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

3 Replies
buzzy996
Honored Contributor II

Re: ODBC string Error

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

Re: ODBC string Error

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
Valued Contributor

Re: ODBC string Error

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!