topic 0 records loaded with OLEDB CONNECT32 connection string in QlikView https://community.qlik.com/t5/QlikView/0-records-loaded-with-OLEDB-CONNECT32-connection-string/m-p/558476#M208476 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>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. </P><P>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.</P><P>I am sure some of you people must have came across such situation, any suggestions guys?</P><P></P><P>Thanks</P><P>Raj</P></BODY></HTML> Fri, 01 Nov 2013 09:56:12 GMT 2013-11-01T09:56:12Z 0 records loaded with OLEDB CONNECT32 connection string https://community.qlik.com/t5/QlikView/0-records-loaded-with-OLEDB-CONNECT32-connection-string/m-p/558476#M208476 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>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. </P><P>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.</P><P>I am sure some of you people must have came across such situation, any suggestions guys?</P><P></P><P>Thanks</P><P>Raj</P></BODY></HTML> Fri, 01 Nov 2013 09:56:12 GMT https://community.qlik.com/t5/QlikView/0-records-loaded-with-OLEDB-CONNECT32-connection-string/m-p/558476#M208476 2013-11-01T09:56:12Z Re: 0 records loaded with OLEDB CONNECT32 connection string https://community.qlik.com/t5/QlikView/0-records-loaded-with-OLEDB-CONNECT32-connection-string/m-p/558477#M208477 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Fri, 01 Nov 2013 14:33:50 GMT https://community.qlik.com/t5/QlikView/0-records-loaded-with-OLEDB-CONNECT32-connection-string/m-p/558477#M208477 Gysbert_Wassenaar 2013-11-01T14:33:50Z