If the driver needed is not found on the ODBC Drivers tab, contact the software supplier to obtain the correct driver. Go to the ODBC Drivers tab to find out what drivers are installed. (For 32-bit ODBC on a 64-bit operating system start odbcad32.exe). There should be an ODBC Data Source Administrator installed on the system. On a 32-bit operating system the configuration is very straightforward since all files and drivers are 32-bit. If there is also a 32-bit version of the file, it resides in the syswow64 folder. When using the 32-bit versions of ODBC and QlikView, you must start the 32-bit administrator via the executable file, odbcad32.exe that is located in the SysWOW64 folder, usually c:\windows\SysWOW64.Īccording to Microsoft, in the 64-bit versions of the operating systems, the system32 folder, usually c:\windows\system32, contains only 64-bit files. When using the 64-bit versions of ODBC and QlikView, the ODBC Data Source Administrator is found in the Control Panel, Administrative Tools. It is also possible to run both 32-bit and 64-bit ODBC drivers. On a 64-bit platform it is possible to use both 32-bit and 64-bit applications. QlikView works with 32-bit and 64-bit ODBC drivers. Contact the DBMS supplier for more information on the software needed. If the plan is to use ODBC to access a multi-user relational database on a network server, additional DBMS software that allows a client to access the database on the server might be needed. The ODBC interface described here is the interface on the client computer. Additional drivers can be bought from software retailers, found on the Internet or delivered from the DBMS manufacturer. Normally some ODBC drivers are installed with the operating system. The alternative is to export data from the database into a file that is readable to QlikView. To access a general database, it is necessary to have the ODBC (Open DataBase Connectivity) interface installed. Otherwise you will receiveĪn error message indicating that a connection cannot be made, in whichĬase you will need to install it. When you select File, Edit Script, Connect to OLE DB you will arrive at the Data Link Properties page, if the OLE DB provider is correctly installed. Is the Correct OLE DB Provider Installed? A great number of external databases can be accessed via the Microsoft OLE DB Provider for ODBC Drivers. QlikView supports the OLE DB interface for connection to external data sources.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |