-
Re: Issue with ODBC and OLEDB connectors while connecting to SQL DB..??
Peter Cammaert Mar 13, 2017 5:12 AM (in response to dhasharadh goud)Of course your deployment platform needs to have the exact same OLEDB driver. Your Direct Discovery script code contains a CONNECT statement that asks to be connected to a SQL Server database using a specific driver. If your original (dysfunctional) driver uses the same interface but shows no data, the exact same situation occurs on your deployment platform. The problem will probably go away if you install the Qlik driver package on your deployment server as well.
-
Re: Issue with ODBC and OLEDB connectors while connecting to SQL DB..??
Peter Cammaert Mar 13, 2017 5:15 AM (in response to Peter Cammaert )Did you ever figure out why the original OLEDB driver refused to show any objects or data? Wrong Schema?
Some fixes may look like they solve a problem but they actually circumvent a situation that still causes problems further downstream...
-
Re: Issue with ODBC and OLEDB connectors while connecting to SQL DB..??
dhasharadh goud Mar 13, 2017 6:00 AM (in response to Peter Cammaert )thanks peter ,
Yes your words are correct , at that time i just want to overcome that Problem by installing the QvODBCConnection package but it creates another problem like this to me.
I installed personal edition in my Machine, and in my Data sources (ODBC) - in the user DSNs all the drivers are installed.
Please let me know where to check for the needed drivers for ODBC and OLEDB in my machine. and if i not found those where to download them.
And the one who is deploying definitely have all these drivers installed right ?
now i want to change the connection to OLEDB or i need to send this QvODBCConnectorpackage also to install on his machine...
-
Re: Issue with ODBC and OLEDB connectors while connecting to SQL DB..??
Peter Cammaert Mar 13, 2017 6:41 AM (in response to dhasharadh goud)This is getting a bit confusing for me. You keep talking about OLEDB and ODBC as if they are interchangeable. They're not, they are different solutions to connect to the same database.
QlikODBCConnectorPackage only contains custom ODBC drivers (no OLEDB) with a special feature: they don't need separate definitions in your Windows configuration. They more-or-less act like OLEDB but they are still different If you want to use OLEDB, then you can download the appropriate drivers from the Microsoft Download site.
As soon as you select a suitable driver package (OLEDB or QlikODBC) and it proves to be working in your development environment, make sure that the same package is also installed on the deployment QlikView server, or your document reloads will fail.
If the driver installations are in sync, you don't need to change anything in your document to make it work on both platforms.
-
-
Re: Issue with ODBC and OLEDB connectors while connecting to SQL DB..??
Peter Cammaert Mar 14, 2017 3:50 AM (in response to dhasharadh goud)You do not need to define a DSN in your Server. If you still do, this is apparently considered "improper use" and you need to purchase a license.
The advantage of the Qlik ODBC package is that you do not need to define a DSN; all connection properties are stored in the script conneciton string using the wizard. Just as with an OLE DB connection.
-
-
-
-
-