Working with Delphi XE6.

When I start my program in the IDE I get an EOleException saying "%1
could not be found".

If I just select Continue when the exception occurs the program
continues and all appears to function correctly.

If I start the program from a desktop icon the exception does not occur
(or at least is not visible) and all appears to function correctly.

If I put a breakpoint in my program at the start of the OnCreate event
of the first data module to be created the exception occurs before
getting to that point.

This did not happen until today when I moved my Output Directory in
project options from where it was in "MySystem\Programs\ThisProgram" to
"MySystem". I also moved the required UDL file, an INI file, and
several image files used by the application.

The folder "MySystem\Programs\ThisProgram" also contains the dcu files,
map file, standard auto-created .res file, .ico file, etc.

My executable is in debug configuration.

Somewhere in the back of my mind there is something telling me that
I've encountered this exception before, and solved it, but it must have
been some time ago, or my memory is failing.

What is missing so that my program will work without throwing that
exception in the IDE ??

--
JF

Jim,

| What is missing so that my program will work without throwing that
| exception in the IDE ??

Did you update the IDE path? 


-- 

   Q  --  XanaNews 1.19.1.372 -  2015-08-08 13:38:56

Jim,

| What is missing so that my program will work without throwing that
| exception in the IDE ??

Did you update the IDE path? 


-- 

   Q  --  XanaNews 1.19.1.372 -  2015-08-08 13:38:56

Quentin Correll wrote:

> Jim,
> 
> >  What is missing so that my program will work without throwing that
> >  exception in the IDE ??
> 
> Did you update the IDE path? 

Quentin,

I just modified the Output Directory under Delphi Compiler in Project
Options.

Tonight, when I returned to tackle another problem, I got the following
exception when loading the project in Delphi:

[5121D817]{adortl200.bpl} Data.Win.ADODB.TADOConnection.DoConnect (Line
1643, "Data.Win.ADODB.pas" + 1) + $41
[50065FE8]{rtl200.bpl  } System.@CheckAutoResult (Line 36533,
"System.pas" + 4) + $6
[5121D817]{adortl200.bpl} Data.Win.ADODB.TADOConnection.DoConnect (Line
1643, "Data.Win.ADODB.pas" + 1) + $41
[50B9AF51]{dbrtl200.bpl} Data.DB.TCustomConnection.SetConnected (Line
3545, "Data.DB.pas" + 8) + $4
[50B9AEA8]{dbrtl200.bpl} Data.DB.TCustomConnection.Loaded (Line 3514,
"Data.DB.pas" + 3) + $10

Plus about 80 more lines similar to above.

Then when I executed the program in the IDE the exception DID NOT OCCUR
!!!!!  Mysteries !!!!!

My database connection is not connected at design time. Just to make
sure it is not accidentally left connected when building, I disconnect
it as the first action in the first data module's OnCreate event.

Then, in the MainForm's OnCreate event I have:

  if (not Flag_Run_Without_Database) then
    begin
      try
        DM.DBConnection.Connected := False;
        DM.DBConnection.ConnectionString := 'FILE NAME=MyFile.UDL';
        DM.DBConnection.Connected := True;
      except
        MyMessageDlg (Msg_Error_Opening_Oracle_Database, mtError,
                                      [mbOK], [Msg_Button_Caption_OK]);
        Database_Connection_Failed := True;
        System.SysUtils.Abort;
      end;
    end;

It appears to have something to do with an ADO connection as the
exception above occurred in DoConnect. However, I don't see why Delphi
IDE was connecting when I was just loading the project, not running it.

Mysteries, mysteries.

--
JF

Quentin Correll wrote:

> Jim,
> 
> >  What is missing so that my program will work without throwing that
> >  exception in the IDE ??
> 
> Did you update the IDE path? 

Quentin,

I just modified the Output Directory under Delphi Compiler in Project
Options.

Tonight, when I returned to tackle another problem, I got the following
exception when loading the project in Delphi:

[5121D817]{adortl200.bpl} Data.Win.ADODB.TADOConnection.DoConnect (Line
1643, "Data.Win.ADODB.pas" + 1) + $41
[50065FE8]{rtl200.bpl  } System.@CheckAutoResult (Line 36533,
"System.pas" + 4) + $6
[5121D817]{adortl200.bpl} Data.Win.ADODB.TADOConnection.DoConnect (Line
1643, "Data.Win.ADODB.pas" + 1) + $41
[50B9AF51]{dbrtl200.bpl} Data.DB.TCustomConnection.SetConnected (Line
3545, "Data.DB.pas" + 8) + $4
[50B9AEA8]{dbrtl200.bpl} Data.DB.TCustomConnection.Loaded (Line 3514,
"Data.DB.pas" + 3) + $10

Plus about 80 more lines similar to above.

Then when I executed the program in the IDE the exception DID NOT OCCUR
!!!!!  Mysteries !!!!!

My database connection is not connected at design time. Just to make
sure it is not accidentally left connected when building, I disconnect
it as the first action in the first data module's OnCreate event.

Then, in the MainForm's OnCreate event I have:

  if (not Flag_Run_Without_Database) then
    begin
      try
        DM.DBConnection.Connected := False;
        DM.DBConnection.ConnectionString := 'FILE NAME=MyFile.UDL';
        DM.DBConnection.Connected := True;
      except
        MyMessageDlg (Msg_Error_Opening_Oracle_Database, mtError,
                                      [mbOK], [Msg_Button_Caption_OK]);
        Database_Connection_Failed := True;
        System.SysUtils.Abort;
      end;
    end;

It appears to have something to do with an ADO connection as the
exception above occurred in DoConnect. However, I don't see why Delphi
IDE was connecting when I was just loading the project, not running it.

Mysteries, mysteries.

--
JF

Jim Fleming wrote:

> Quentin Correll wrote:
> 
> > Jim,
> > 
> > >  What is missing so that my program will work without throwing
> > > that  exception in the IDE ??
> > 
> > Did you update the IDE path? 
> 
> Quentin,
> 
> I just modified the Output Directory under Delphi Compiler in Project
> Options.
> 
> Tonight, when I returned to tackle another problem, I got the
> following exception when loading the project in Delphi:
> 
> [5121D817]{adortl200.bpl} Data.Win.ADODB.TADOConnection.DoConnect
> (Line 1643, "Data.Win.ADODB.pas" + 1) + $41
> [50065FE8]{rtl200.bpl  } System.@CheckAutoResult (Line 36533,
> "System.pas" + 4) + $6
> [5121D817]{adortl200.bpl} Data.Win.ADODB.TADOConnection.DoConnect
> (Line 1643, "Data.Win.ADODB.pas" + 1) + $41
> [50B9AF51]{dbrtl200.bpl} Data.DB.TCustomConnection.SetConnected (Line
> 3545, "Data.DB.pas" + 8) + $4
> [50B9AEA8]{dbrtl200.bpl} Data.DB.TCustomConnection.Loaded (Line 3514,
> "Data.DB.pas" + 3) + $10
> 
> Plus about 80 more lines similar to above.
> 
> Then when I executed the program in the IDE the exception DID NOT
> OCCUR !!!!!  Mysteries !!!!!
> 
> My database connection is not connected at design time. Just to make
> sure it is not accidentally left connected when building, I disconnect
> it as the first action in the first data module's OnCreate event.
> 
> Then, in the MainForm's OnCreate event I have:
> 
>   if (not Flag_Run_Without_Database) then
>     begin
>       try
>         DM.DBConnection.Connected := False;
>         DM.DBConnection.ConnectionString := 'FILE NAME=MyFile.UDL';
>         DM.DBConnection.Connected := True;
>       except
>         MyMessageDlg (Msg_Error_Opening_Oracle_Database, mtError,
>                                       [mbOK],
> [Msg_Button_Caption_OK]);         Database_Connection_Failed := True;
>         System.SysUtils.Abort;
>       end;
>     end;
> 
> It appears to have something to do with an ADO connection as the
> exception above occurred in DoConnect. However, I don't see why Delphi
> IDE was connecting when I was just loading the project, not running
> it.
> 
> Mysteries, mysteries.


Mysteries have evaporated !!!   The penny finally dropped !!!

Although my connection has the bit Connected false, the IDE needs to
connect to my DB so as to be able to set up queries, etc. So, it needs
a valid connection string in the DB Connection object, or a reference
to a valid UDL file. I had moved the UDL file to the folder where the
executable is now created but had not modified the Connection string (a
UDL reference) to point to that new location.

Mea culpa, mea maxima culpa.

--
JF

Jim,

| What is missing so that my program will work without throwing that
| exception in the IDE ??

Did you update the IDE path? 


-- 

   Q  --  XanaNews 1.19.1.372 -  2015-08-08 13:38:56

Jim,

| What is missing so that my program will work without throwing that
| exception in the IDE ??

Did you update the IDE path? 


-- 

   Q  --  XanaNews 1.19.1.372 -  2015-08-08 13:38:56

Jim,

| What is missing so that my program will work without throwing that
| exception in the IDE ??

Did you update the IDE path? 


-- 

   Q  --  XanaNews 1.19.1.372 -  2015-08-08 13:38:56

Jim,

| What is missing so that my program will work without throwing that
| exception in the IDE ??

Did you update the IDE path? 


-- 

   Q  --  XanaNews 1.19.1.372 -  2015-08-08 13:38:56

Jim Fleming wrote:

> Quentin Correll wrote:
> 
> > Jim,
> > 
> > >  What is missing so that my program will work without throwing
> > > that  exception in the IDE ??
> > 
> > Did you update the IDE path? 
> 
> Quentin,
> 
> I just modified the Output Directory under Delphi Compiler in Project
> Options.
> 
> Tonight, when I returned to tackle another problem, I got the
> following exception when loading the project in Delphi:
> 
> [5121D817]{adortl200.bpl} Data.Win.ADODB.TADOConnection.DoConnect
> (Line 1643, "Data.Win.ADODB.pas" + 1) + $41
> [50065FE8]{rtl200.bpl  } System.@CheckAutoResult (Line 36533,
> "System.pas" + 4) + $6
> [5121D817]{adortl200.bpl} Data.Win.ADODB.TADOConnection.DoConnect
> (Line 1643, "Data.Win.ADODB.pas" + 1) + $41
> [50B9AF51]{dbrtl200.bpl} Data.DB.TCustomConnection.SetConnected (Line
> 3545, "Data.DB.pas" + 8) + $4
> [50B9AEA8]{dbrtl200.bpl} Data.DB.TCustomConnection.Loaded (Line 3514,
> "Data.DB.pas" + 3) + $10
> 
> Plus about 80 more lines similar to above.
> 
> Then when I executed the program in the IDE the exception DID NOT
> OCCUR !!!!!  Mysteries !!!!!
> 
> My database connection is not connected at design time. Just to make
> sure it is not accidentally left connected when building, I disconnect
> it as the first action in the first data module's OnCreate event.
> 
> Then, in the MainForm's OnCreate event I have:
> 
>   if (not Flag_Run_Without_Database) then
>     begin
>       try
>         DM.DBConnection.Connected := False;
>         DM.DBConnection.ConnectionString := 'FILE NAME=MyFile.UDL';
>         DM.DBConnection.Connected := True;
>       except
>         MyMessageDlg (Msg_Error_Opening_Oracle_Database, mtError,
>                                       [mbOK],
> [Msg_Button_Caption_OK]);         Database_Connection_Failed := True;
>         System.SysUtils.Abort;
>       end;
>     end;
> 
> It appears to have something to do with an ADO connection as the
> exception above occurred in DoConnect. However, I don't see why Delphi
> IDE was connecting when I was just loading the project, not running
> it.
> 
> Mysteries, mysteries.


Mysteries have evaporated !!!   The penny finally dropped !!!

Although my connection has the bit Connected false, the IDE needs to
connect to my DB so as to be able to set up queries, etc. So, it needs
a valid connection string in the DB Connection object, or a reference
to a valid UDL file. I had moved the UDL file to the folder where the
executable is now created but had not modified the Connection string (a
UDL reference) to point to that new location.

Mea culpa, mea maxima culpa.

--
JF

Jim,

| What is missing so that my program will work without throwing that
| exception in the IDE ??

Did you update the IDE path? 


-- 

   Q  --  XanaNews 1.19.1.372 -  2015-08-08 13:38:56