Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey Team -
We have a package which returns a very specific date based on today's date. So, suppose I enter today's date, the package correctly returns 4/21/2017 (Friday). But the same package returns 4/18/2017 (Tuesday) in QlikView. If I adjust the date by 1 or 2 months, I see the same issue where it always gives Friday within TOAD, but Tuesday in QlikView.
What could be an issue here? Any ideas?
mrkachhiaimp, pcammaert, hic, marcus_sommer
To check the drivers see odbcad32.exe as the first place. Note that you have two files with that name one for 32 bit connections in C:\Windows\SysWOW64 and another for 64 bit connections in C:\Windows\System32
How the query looks like? In QlikView, does it happen when you LOAD or when you SELECT? Both Toad and QlikView use the same driver and account to query the database?
There is no preceding load, just the direct query using SELECT
TableName:
SQL SELECT PACKAGE_NAME(SYSDATE) VALUE
FROM DUAL;
How can I check the drivers? Account is the same and same environment (prod)
To check the drivers see odbcad32.exe as the first place. Note that you have two files with that name one for 32 bit connections in C:\Windows\SysWOW64 and another for 64 bit connections in C:\Windows\System32
We are using OLEDB connection, does that make any difference?
It works with ODBC Connection... Why would it not work with OLEDB connection? I am not sure I understand the difference?
ODBC and OLE DB are two different interfaces to communicate with databases.
Long story short: ODBC historically allowed only relational databases, now this has changed and it is open (the O in the name stays for Open), while OLE DB was broader, it can be used to read from other systems mail servers, for example, but only works on Microsoft Windows systems.
Let's say both are a different set of APIs for the same purpose: consuming data from sources. Different APIs, different methods, sometimes different results.
I guess there is no way to get the correct output using OLE DB Connection then?
There is an OLE DB to ODBC bridge, see this for example: OpenLink Single-Tier (Lite Edition) OLE DB to ODBC Bridge or 64bit to 32bit ODBC and OLE DB Bridge or Sequelink .NET Bridge for JDBC & ODBC Databases | Progress DataDirect
Thanks mbaeyens I will check this out.