#1  
Old 20th June 2016, 09:13 PM
boman boman is offline
Member
 
Join Date: Aug 2012
Posts: 43
Default AV in ADOProvider 242

I am migrating an application from Delphi 7 to Delphi 10 Seattle for my customer. This works nice without problems.

But when I create a REST Web Service (wcf) using Visual Studio Pack I have problems.

I get random AccessViolation exception :
System.AccessViolationException in NexusDB.ADOProvider.dll with the followin additional information (translated from english to Swedish):
There is a try to read or write to protected memory.

The error occurs randomly without any connection to certain methods or classes in my application.

Here is the configuration:

Windows Server 2012
Visual Studio 2013
NexusDB Server 400.15 64 bit.
Using 32 bit AdoServerConnectionv4.dll located in the same director as the dll of the program.

Connection string :
<add name="ffServManCS" connectionString="Server=127.0.0.1;Database=ffServ Man;Port=16000;Native=True;Embedded=False;Username =;Password=;Timeout=10000;BlockReadSize=0;NativeTr ansportType=TCP/IPV4;SecureTransportKey=" providerName="NexusDB.ADOProvider" />

Is there a newer version of the AdoServerCon... DLL? Any known problems with the current?

Thank you

Kjell-Ake Boberg
Sweden.
  #2  
Old 20th June 2016, 10:12 PM
Thorsten Engler [NDA]
 
Posts: n/a
Default Re: AV in ADOProvider 242

The current versions are NexusDB 4.10 and ADO.NET Provider Build 280

boman wrote:

>
> I am migrating an application from Delphi 7 to Delphi 10 Seattle for my
> customer. This works nice without problems.
>
> But when I create a REST Web Service (wcf) using Visual Studio Pack I
> have problems.
>
> I get random AccessViolation exception :
> System.AccessViolationException in NexusDB.ADOProvider.dll with the
> followin additional information (translated from english to Swedish):
> There is a try to read or write to protected memory.
>
> The error occurs randomly without any connection to certain methods or
> classes in my application.
>
> Here is the configuration:
>
> Windows Server 2012
> Visual Studio 2013
> NexusDB Server 400.15 64 bit.
> Using 32 bit AdoServerConnectionv4.dll located in the same director as
> the dll of the program.
>
> Connection string :
> <add name="ffServManCS"
> connectionString="Server=127.0.0.1;Database=ffServ Man;Port=16000;Native=True;E
> mbedded=False;Username=;Password=;Timeout=10000;Bl ockReadSize=0;NativeTranspor
> tType=TCP/IPV4;SecureTransportKey=" providerName="NexusDB.ADOProvider" />
>
> Is there a newer version of the AdoServerCon... DLL? Any known problems
> with the current?
>
> Thank you
>
> Kjell-Ake Boberg
> Sweden.


  #3  
Old 20th June 2016, 11:19 PM
boman boman is offline
Member
 
Join Date: Aug 2012
Posts: 43
Default Beta version?

Quote:
Originally Posted by Thorsten Engler [NDA] View Post
The current versions are NexusDB 4.10 and ADO.NET Provider Build 280

[/color]
Thanks for your answer.
However I can see that build 280 is still a Beta. Since the customer is going
live on wednesday this week this seems a little bit scary to me.

Is there a stable version "round the corner"?

Kind Regards

Kjell-Ake
  #4  
Old 20th June 2016, 11:30 PM
Thorsten Engler [NDA]
 
Posts: n/a
Default Re: AV in ADOProvider 242

boman wrote:

> However I can see that build 280 is still a Beta.


As is the build 242 that you are using.
Build 280 is definitely preferable over 242.
  #5  
Old 21st June 2016, 12:02 PM
boman boman is offline
Member
 
Join Date: Aug 2012
Posts: 43
Default More problems

Quote:
Originally Posted by Thorsten Engler [NDA] View Post
As is the build 242 that you are using.
Build 280 is definitely preferable over 242.
I uninstalled version 242, installed Build 280. Rebuilt the code. Ran runtime installer in Visual Studio Pack.
When using the development server provided with VS 2013 it works fine
but when deploying to the "real" IIS i get the following error each time
there is a database call.

The same error message occurs both when using Native true or false in config file.

And we have the same problem in the production server :

An unhandled exception of type 'System.ServiceModel.FaultException' occurred in mscorlib.dll

Additional information: The server was unable to process the request due to an internal error. For more information about the error, either turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the <serviceDebug> configuration behavior) on the server in order to send the exception information back to the client, or turn on tracing as per the Microsoft .NET Framework SDK documentation and inspect the server trace logs.


Any ideas
  #6  
Old 21st June 2016, 01:19 PM
Rodrigo Gomez [NDX]
 
Posts: n/a
Default Re: AV in ADOProvider 242

Make sure the correct version of the DLLs are being deployed with your app. I have had
problems like this because old versions get deployed.

You also need to copy the ADOServerConnectorV4[_64].dll somewhere where your app can load
it (I keep mine with all the other DLLs of the components and so on). This needs to be
done by hand, as those DLLs don't "exist" for the IDE itself, so it wont automagically
copy them like the others (NexusDB.ADOProvider.dll, etC).

--
Rodrigo Gómez [NDX]
México, GMT-6
  #7  
Old 21st June 2016, 02:31 PM
Thorsten Engler [NDA]
 
Posts: n/a
Default Re: AV in ADOProvider 242

In addition to what Rodrigo said,

make sure there isn't the old build of the provider still present in the GAC
and your application referencing it with an explicit build number.

gacutil /u NexusDB.ADOProvider
gacutil /u NexusDB.ADOProvider.Linq

(run from an elevated administrator command line) will uninstall all builds of
these assemblies from the GAC.

Rodrigo Gomez [NDX] wrote:

> Make sure the correct version of the DLLs are being deployed with your app. I
> have had problems like this because old versions get deployed.
>
> You also need to copy the ADOServerConnectorV4[_64].dll somewhere where your
> app can load it (I keep mine with all the other DLLs of the components and so
> on). This needs to be done by hand, as those DLLs don't "exist" for the IDE
> itself, so it wont automagically copy them like the others
> (NexusDB.ADOProvider.dll, etC).


  #8  
Old 21st June 2016, 02:32 PM
Thorsten Engler [NDA]
 
Posts: n/a
Default Re: AV in ADOProvider 242

Also:

> Additional information: The server was unable to process the request due
> to an internal error. For more information about the error, either turn
> on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute
> or from the <serviceDebug> configuration behavior) on the server in
> order to send the exception information back to the client, or turn on
> tracing as per the Microsoft .NET Framework SDK documentation and
> inspect the server trace logs.


Do that to actually see what the exception is...
  #9  
Old 22nd June 2016, 01:31 AM
boman boman is offline
Member
 
Join Date: Aug 2012
Posts: 43
Default Problem solved

I unistalled the 242 ADOProvider using the normal Windows uninstall.
For some reasons the .net framework still looked for version 242 of the NexusADO provider.

The solution I made was to select "copy locally" on the Nexus.ADO provider when building the program. Then I inluced the copied Nexus.ADO dll together with the program dll:s in the bin directory of the web service.

Maybe there is a better solution...

However, thanks for Word-Class support from this newsgroup.

--Kjell-Ake
  #10  
Old 22nd June 2016, 09:06 PM
David Guest
 
Posts: n/a
Default Re: AV in ADOProvider 242

Try running your application from a browser on the actual server ... It
should reply with an error page which will show you what the actual
error is...


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ADOProvider V2 w/VS2005 support Ole Willy Tuv nexusdb.public.support.adoprovider 25 11th April 2007 03:30 AM
Unable to load DLL (NexusDB.ADOProvider.NexusDBV1.dll) G. Campbell nexusdb.public.support 5 20th May 2005 02:19 PM


All times are GMT +11. The time now is 06:52 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.