This content has been marked as final. Show 2 replies
I'm assuming that your terminal server in this case is also your QVS.
- It is possible to use ODBC to connect to an Access database. When you create a new ODBC connection, one of the options under "Select a driver" should be Microsoft Access Database. After you have set up the ODBC, you can use it within your QlikView application. For ease of development, you might want to install QlikView Desktop on your server to make use of automatically created connection strings.
- I'm guessing the reason that your JET driver does not show up on the server is that your server and OS are 64-bit. JET does not work with applications running in 64-bit. Microsoft has announced that Office 2010 will add this functionality. So there is nothing you can install on the server to fix the problem. However, you could install QlikView Desktop 32-bit on your server, and then reload your file using command line automation set up as a Supporting Task in Publisher. Note that if your server is actually 32-bit and you don't see JET installed, you can install the JET OleDB driver here: http://support.microsoft.com/kb/239114