0 records loaded with OLEDB CONNECT32 connection string
Hi All,
I am using QV10 SR5, while trying to load the data from Ms Access 2007 .mdb file using OLEDB CONNECT32 connection string, it loads around 109K records on my desktop client, where as server returns 0 records.
Tested the same using QV11 desktop client, to my surprise it loads correctly without 'Force 32 Bit' enabled, and with 'Force 32 Bit' loads 0 records.
I am sure some of you people must have came across such situation, any suggestions guys?
Check the log file of the document on the server. Make sure the oledb driver is also installed on the server and that the access .mdb file is where the document expects it to be and that it is accessible from the server.