On my Windows 7 Desktop I can see all of the tables etc
On the server,, I am able to create and ODBC DSN using Windows that successfully connects, that is how I was checking to see if the drivers were correct. I don't know how to recreate this for OLEDB.
However, When I tried to load the Qlikview document from the QV instalation on the Server, the "View Script" selection is not there and the "Reload" is disabled. This means I can't test whether the connection string within this document actually works when it is on the server.
Thanks for the reply,
I have figured out why I couldn't reload from the Qlikview App. The user I had logged onto on the server did not have a named license, only the normal access license.
I can now reload from the Qlikview application without any problems, but when I try to apply the schedule the reload still fails without any other information