topic OLEDB Connection not recognizing new fields added to a table in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/OLEDB-Connection-not-recognizing-new-fields-added-to-a-table/m-p/1429133#M3192 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have an OLEDB Conneciton to an Oracle DB</P><P>We added a few new fields to one of the tables over the weekend,</P><P>but when i attempt to view those tables in the data connection they do not appear.</P><P>I also tried to just query them right in the data load editor with a SQL Select * Query below and the fields were still not recognized.</P><P></P><P>Is there a way to "Refresh" a data connection so that it recognizes these new fields?</P><P></P><P></P><P>Thanks in advance</P><P></P><P>Dylan Mackintosh</P></BODY></HTML> Mon, 20 Nov 2017 17:01:04 GMT dmackint 2017-11-20T17:01:04Z OLEDB Connection not recognizing new fields added to a table https://community.qlik.com/t5/Connectivity-Data-Prep/OLEDB-Connection-not-recognizing-new-fields-added-to-a-table/m-p/1429133#M3192 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have an OLEDB Conneciton to an Oracle DB</P><P>We added a few new fields to one of the tables over the weekend,</P><P>but when i attempt to view those tables in the data connection they do not appear.</P><P>I also tried to just query them right in the data load editor with a SQL Select * Query below and the fields were still not recognized.</P><P></P><P>Is there a way to "Refresh" a data connection so that it recognizes these new fields?</P><P></P><P></P><P>Thanks in advance</P><P></P><P>Dylan Mackintosh</P></BODY></HTML> Mon, 20 Nov 2017 17:01:04 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/OLEDB-Connection-not-recognizing-new-fields-added-to-a-table/m-p/1429133#M3192 dmackint 2017-11-20T17:01:04Z Re: OLEDB Connection not recognizing new fields added to a table https://community.qlik.com/t5/Connectivity-Data-Prep/OLEDB-Connection-not-recognizing-new-fields-added-to-a-table/m-p/1429134#M3193 <HTML><HEAD></HEAD><BODY><P>Are you sure that the changes was the right table and the assumed database (not any dump or a dev-environment or something similar)? Further there might be some options in Oracle about the visibility or access rights to these new fields and these flags aren't set.</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 20 Nov 2017 17:40:47 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/OLEDB-Connection-not-recognizing-new-fields-added-to-a-table/m-p/1429134#M3193 marcus_sommer 2017-11-20T17:40:47Z