5 Replies Latest reply: May 12, 2011 1:20 PM by Jonathan Dienst RSS

    Oracle OLEDB connection hangs

    Jonathan Dienst

      Hi

       

      I have a strange situation with an Oracle based model. When I reload the document the reload hangs on the Oracle connect statement:

       

      OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=xxxx;Data Source=xxxx;Extended Properties=""]....

       

      I can load the model by entering debug mode and clicking Run. When I do that, the connection works perfectly, but not if I reload by clicking reload or with CTRL-R.

       

      I can also open the SELECT dialog and browse the database without a problem - but we won't be able to deploy this model until this has been resolved.

       

      Tested on 10SSR1 and 10SR2 and after re-installing QV. The computer is running 64bit WIindows Server 2008. We do not have the problem on small models, or on the problem model if it is no-data loaded.

       

      Any ideas?

       

      Jonathan