Error message when add a dbexpress connection

Add-in Express™ Support Service
That's what is more important than anything else

Error message when add a dbexpress connection
 
Mauro Ferreira




Posts: 2
Joined: 2011-07-28
I have one app app that ran flawless until a dbexpress and/or ZeosDBO connection was inserted (in the _IMPL.pas, as inserting a DataModule just stop the app with a error msg) otherwise give the message:

coSGVF error: the add-in fired an exception.
Access violation at address 0B2C65B1 in module 'SGVF.dll'. Read of address 00000464

but works afterward. To test it i did:

procedure TAddInModule.adxOlExplorerCommandBarControls0Click(Sender: TObject);
begin

ShowMessage('Click Ok to open the dbexpress connection');
if not SGVF.Connected then SGVF.Open;
if SGVF.Connected then begin
ShowMessage('dbexpress Connected :)');
end else begin
ShowMessage('dbexpress Not connected :(');
end;

ShowMessage('Click Ok to open the ZeosDBO connection');
if not ZSGVF.Connected then ZSGVF.Connect;
if ZSGVF.Connected then begin
ShowMessage('ZeosDBO Connected :)');
end else begin
ShowMessage('ZeosDBO Not connected :(');
end;
end;

and after the error message both connections worked.

How can i get rid of that error message ?

I can send the app with drivers by email.

Add-in Express 2010 for Microsoft Office and CodeGear VCL, Standard
Registration Name: Lindolfo L. Martin Filho
Windows XP / Office 2010 / Delphi7

dbexpress:
driver : http://www.justsoftwaresolutions.co.uk/files/dbxopenmysql5_dll.zip

dbxdriver.ini:
[Installed Drivers]
...
OpenMySQL50=1
...

[OpenMySQL50]
LibraryName=dbxopenmysql50.dll
GetDriverFunc=getSQLDriverMYSQL50
VendorLib=libmysql.dll

dbxconnections.ini:
[OpenMySQL50]
DriverName=OpenMySQL50
HostName=HOST_IP_OR_URL
Database=DATABASE_NAME
User_Name=USER_NAME
Password=PASSWORD
BlobSize=-1
...

ZeosDBO: http://sourceforge.net/projects/zeoslib/

driver: MySQL5
Posted 28 Jul, 2011 12:19:00 Top
Andrei Smolin


Add-in Express team


Posts: 18793
Joined: 2006-05-11
Hi Mauro,

Can you tell me what code line produces the exception?


Andrei Smolin
Add-in Express Team Leader
Posted 29 Jul, 2011 06:09:33 Top
Mauro Ferreira




Posts: 2
Joined: 2011-07-28
Please desconsider my post, i found the error in adxCOMAddInModuleOLExplorerSelectionChange: a Selection exists, have one member but its form type is zero, what did happen when the addin initialized.

This got me because i coud never guess that this event is triggered in the addin initialization, _before_ any valid selection form ever exists.

Probably Outlook create the explorer in initialization and create a selection with no form, or with a form with type 0 (zero), and then change it to a a valid one when show the explorer. Or something like this.

An "if (Assigned(IDispatcher)) and (IFormType > 0) then begin" solved the problem.

Thanks for your attention, and my apologies for ask before do a good check in the problem.
Posted 29 Jul, 2011 08:38:10 Top
Andrei Smolin


Add-in Express team


Posts: 18793
Joined: 2006-05-11
Hi Mauro,

Congratulations and good luck!


Andrei Smolin
Add-in Express Team Leader
Posted 29 Jul, 2011 09:12:44 Top