I'm probably asking the obvious but is the OLE DB properly configured for the server? Meaning whether they have the same architecture (x64, 32 bits forced) or not, and wheter the OLE DB driver actually exists on the server or not. Besides, if you are using a computer name instead of an IP address, is this address reachable from the server? Does its configure DNS resolve the name?
Hope that helps.
Thanks Miquel for your quick reply.
I tried connecting on ip, OLEDB is installed (both 32 bit as 64 bit), but that seems all okay. I must sy that when I use 'force 32 bit', I get the error: 'unknown command'.
So still the situation is that when I open the qvw from my laptop client and reload, it's okay, but when on the server, reloading the very same qvw, it doesn't connect to the database.
All new suggestions are welcome :-)