Solved

DLL Connection ?

Posted on 2001-07-17
15
307 Views
Last Modified: 2013-11-23
Using D5, All update applied, ADO, SQL 2000.
I have an application with a very large complex report in a DLL. I open the dll and run the report just fine. Then close dll just fine. Show Main form and get an access violation.
I tried disconnecting the current ADO connection, then opening the DLL, run report, close dll, then open main connection again. No access violation.
I don't want to open the tables again. It is about a 10 - 15 second delay.

Is there a way that I can tell the DLL ado objects to use the ADOConnection of the main application?

I tried using a connection string int the DLL instead of an ADOConnection but got the access violoation.

Thanks,
Ross
0
Comment
Question by:bozo7
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 7
15 Comments
 

Expert Comment

by:MGOHARA
ID: 6293837
Pass the connection object(Pointer) to the DLL
0
 
LVL 1

Author Comment

by:bozo7
ID: 6293974
How?
And at design time I leave the connection property blank right? and then at runtime how do I tell the ADO object to use the connection object?

Ross
0
 

Expert Comment

by:MGOHARA
ID: 6294454
You don't have to leave it blank but on the create of the form or datamodule that holds the ADO connection object you can assign a connection string then pass the in your dll you pass the connection object you created to it. Or you can pass the connection string as a PChar and to the Dll.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:bozo7
ID: 6294568
I don't think that passing the connection string will work. I used a udl file and had the objects in the dll use the same udl as the connection object in the calling app. Still generated the error.

How do I pass the connection object to the dll? I tried passing it as a TADOConnection parameter, that did not work.

Ross
0
 

Expert Comment

by:MGOHARA
ID: 6294599
Make the dll an comserver that way you would be able to pass the connection object
0
 
LVL 1

Author Comment

by:bozo7
ID: 6294638
I don't mean to sound stupid but I don't know how to make a DLL a comserver.
Thanks for your help.

Ross
0
 
LVL 1

Author Comment

by:bozo7
ID: 6298776
I will give this another try
This is my test dll. I am attempting to pass the ado connection to the dll. It works fine in the dll it runs the query. But when it returns to the calling application it returns a access violation. The code for the calling application is below. You will notice that in that code there is a try except the except portion is not called.

library testing;

uses
  SysUtils,
  Classes,
  adodb,
  dialogs;

procedure AdminReport(DB : TADOConnection);
var Q : TADOQuery;
begin
  Q := TADOQuery.create(nil);
  try
    with q do
    begin
      Connection := DB;
      sql.add('select count(*) S from cells');
      open;
      if fieldbyname('s').value > 0 then
        showmessage('Ha')
      else
        showmessage('crap');
    end;
  finally
    freeandnil(Q);
  end;
end;

Exports
  AdminReport;
end.

Calling Application procedure

procedure TfrmMain.mniAdmitClick(Sender: TObject);
var
  LibHandle   : THandle;
  AdminReport : TAdminReport;
begin
  frmMain.hide;
  LibHandle := LoadLibrary('C:\Projects\Outcomes\Testing\testing.dll';
  try
    try
      if LibHandle = 0 then
        raise EDLLLoadError.Create('Unable to Load Admin Report');
      @AdminReport := GetProcAddress(LibHandle, 'AdminReport');
      if not (@AdminReport = nil) then
        AdminReport(dtmMain.adoMain)
      else
        RaiseLastWin32Error;
    finally
      FreeLibrary(LibHandle); // Unload the DLL.
    end;
  except
    showmessage('Help');
    raise;
  end;
end;//After this end I get an access violation!!!

Thank You
Ross
0
 
LVL 1

Author Comment

by:bozo7
ID: 6299582
I changed the parameter DB to a var parameter so the DLL procedure now looks like
procedure AdminReport(var DB : TADOConnection);

0
 

Expert Comment

by:MGOHARA
ID: 6300134
Try running outside the delphi enviroment and see what happens
0
 
LVL 1

Author Comment

by:bozo7
ID: 6300169
Same thing. I get the 'Ha' message like I should. Then a quick flash of the main form and nothing.
0
 

Expert Comment

by:MGOHARA
ID: 6300185
When I ran your could I got a Win 32 API Error
0
 
LVL 1

Author Comment

by:bozo7
ID: 6309062
I figured it out!
The AdminReport variable I had delclared like so
  TAdminReport = procedure (AHandle: THandle; var DB: TADOConnection); stdcall;

it should have been like this
  TAdminReport = procedure (AHandle: THandle; var DB: TADOConnection);

The 'stdcall' made the difference. So I am not sure what to do with points for this question.

Thanks,
Ross
0
 

Expert Comment

by:MGOHARA
ID: 6309135
Keep them if you want not a big deal
0
 
LVL 1

Author Comment

by:bozo7
ID: 6309145
I will reduce points to 75 and give you the answer for helping me.
Is that ok?
0
 

Accepted Solution

by:
MGOHARA earned 200 total points
ID: 6309147
Fine
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
find a node in VST 2 93
Dev Express grid collapse 2 55
How to renew a Delphi rad-studio licence? 5 95
Tembedded WB animatid gifs not animated on some pcs 2 94
A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question