Database

Jörgen Andersson8-Jun-20 0:20

Jörgen Andersson

8-Jun-20 0:20

Visual studio is 32bit so you will not be able to debug unless you use a 32-bit client.

If it is a web application it will automatically run as a 64-bit application which is a bit problematic, so you will have to set the application pool to run as a 32-bit application.

Wrong is evil and must be defeated. - Jeff Ello

Member 148339589-Jun-20 5:27

Member 14833958

9-Jun-20 5:27

Bonjour,

what does means this error :

Erreur du serveur dans l'application '/'.
Impossible de charger le fichier ou l'assembly 'Oracle.DataAccess' ou une de ses dépendances. Tentative de chargement d’un programme de format incorrect.
Description : Une exception non gérée s'est produite au moment de l'exécution de la requête Web actuelle. Contrôlez la trace de la pile pour plus d'informations sur l'erreur et son origine dans le code.

Détails de l'exception: System.BadImageFormatException: Impossible de charger le fichier ou l'assembly 'Oracle.DataAccess' ou une de ses dépendances. Tentative de chargement d’un programme de format incorrect.

Erreur source:

Une exception non gérée s'est produite lors de l'exécution de la requête Web actuelle. Les informations relatives à l'origine et l'emplacement de l'exception peuvent être identifiées en utilisant la trace de la pile d'exception ci-dessous.

Suivi du chargement de l'assembly: Les informations suivantes peuvent permettre de déterminer la raison pour laquelle l'assembly 'Oracle.DataAccess' n'a pas pu être chargé.


AVT : la journalisation de liaison d'assembly est désactivée.
Pour activer la journalisation des échecs de liaison d'assembly, attribuez la valeur 1 à la valeur de Registre [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD).
Remarque : une certaine perte de performance est associée à l'enregistrement dans le journal des échecs de liaison d'assembly.
Pour désactiver cette fonctionnalité, supprimez la valeur de Registre [HKLM\Software\Microsoft\Fusion!EnableLog].

Trace de la pile:


[BadImageFormatException: Impossible de charger le fichier ou l'assembly 'Oracle.DataAccess' ou une de ses dépendances. Tentative de chargement d’un programme de format incorrect.]
   System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) +0
   System.Reflection.RuntimeAssembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) +37
   System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) +159
   System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean forIntrospection) +80
   System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +22
   System.Reflection.Assembly.Load(String assemblyString) +29
   System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +39

[ConfigurationErrorsException: Impossible de charger le fichier ou l'assembly 'Oracle.DataAccess' ou une de ses dépendances. Tentative de chargement d’un programme de format incorrect.]
   System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +777
   System.Web.Configuration.CompilationSection.LoadAllAssembliesFromAppDomainBinDirectory() +229
   System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +140
   System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +176
   System.Web.Compilation.BuildManager.GetPreStartInitMethodsFromReferencedAssemblies() +99
   System.Web.Compilation.BuildManager.CallPreStartInitMethods(String preStartInitListPath, Boolean& isRefAssemblyLoaded) +310
   System.Web.Compilation.BuildManager.ExecutePreAppStart() +165
   System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters, PolicyLevel policyLevel, Exception appDomainCreationException) +590

[HttpException (0x80004005): Impossible de charger le fichier ou l'assembly 'Oracle.DataAccess' ou une de ses dépendances. Tentative de chargement d’un programme de format incorrect.]
   System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +10082160
   System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +99
   System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +263

Informations sur la version : Version Microsoft .NET Framework :4.0.30319; Version ASP.NET :4.8.4110.0

Jörgen Andersson9-Jun-20 5:45

Jörgen Andersson

9-Jun-20 5:45

This means you're trying to run a 64-bit program in a 32-bit environment or the opposite way around.

I'm Assuming you have installed a 32-bit client.

IIS is running all it's processes as 64 bits by default, which means it crashes if the oracle client is 32 bits.
You can change this by creating a new Application Pool for your web application, and open "Advanced settings" and "Enable 32-bit Applications".

Wrong is evil and must be defeated. - Jeff Ello

Failed to connect Mysql shared server database with Workbench 8.0.20 tool.

Member 148339589-Jun-20 5:27

Member 14833958

9-Jun-20 5:27

Bonjour,

what does means this error :

Erreur du serveur dans l'application '/'.
Impossible de charger le fichier ou l'assembly 'Oracle.DataAccess' ou une de ses dépendances. Tentative de chargement d’un programme de format incorrect.
Description : Une exception non gérée s'est produite au moment de l'exécution de la requête Web actuelle. Contrôlez la trace de la pile pour plus d'informations sur l'erreur et son origine dans le code.

Détails de l'exception: System.BadImageFormatException: Impossible de charger le fichier ou l'assembly 'Oracle.DataAccess' ou une de ses dépendances. Tentative de chargement d’un programme de format incorrect.

Erreur source:

Une exception non gérée s'est produite lors de l'exécution de la requête Web actuelle. Les informations relatives à l'origine et l'emplacement de l'exception peuvent être identifiées en utilisant la trace de la pile d'exception ci-dessous.

Suivi du chargement de l'assembly: Les informations suivantes peuvent permettre de déterminer la raison pour laquelle l'assembly 'Oracle.DataAccess' n'a pas pu être chargé.


AVT : la journalisation de liaison d'assembly est désactivée.
Pour activer la journalisation des échecs de liaison d'assembly, attribuez la valeur 1 à la valeur de Registre [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD).
Remarque : une certaine perte de performance est associée à l'enregistrement dans le journal des échecs de liaison d'assembly.
Pour désactiver cette fonctionnalité, supprimez la valeur de Registre [HKLM\Software\Microsoft\Fusion!EnableLog].

Trace de la pile:


[BadImageFormatException: Impossible de charger le fichier ou l'assembly 'Oracle.DataAccess' ou une de ses dépendances. Tentative de chargement d’un programme de format incorrect.]
   System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) +0
   System.Reflection.RuntimeAssembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) +37
   System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) +159
   System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean forIntrospection) +80
   System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +22
   System.Reflection.Assembly.Load(String assemblyString) +29
   System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +39

[ConfigurationErrorsException: Impossible de charger le fichier ou l'assembly 'Oracle.DataAccess' ou une de ses dépendances. Tentative de chargement d’un programme de format incorrect.]
   System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +777
   System.Web.Configuration.CompilationSection.LoadAllAssembliesFromAppDomainBinDirectory() +229
   System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +140
   System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +176
   System.Web.Compilation.BuildManager.GetPreStartInitMethodsFromReferencedAssemblies() +99
   System.Web.Compilation.BuildManager.CallPreStartInitMethods(String preStartInitListPath, Boolean& isRefAssemblyLoaded) +310
   System.Web.Compilation.BuildManager.ExecutePreAppStart() +165
   System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters, PolicyLevel policyLevel, Exception appDomainCreationException) +590

[HttpException (0x80004005): Impossible de charger le fichier ou l'assembly 'Oracle.DataAccess' ou une de ses dépendances. Tentative de chargement d’un programme de format incorrect.]
   System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +10082160
   System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +99
   System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +263

Informations sur la version : Version Microsoft .NET Framework :4.0.30319; Version ASP.NET :4.8.4110.0

Member 1167692314-May-20 23:49

Member 11676923

14-May-20 23:49

I am new in Mysql database. Please guide me how to connect shared server database with remote database details.

Port 3306 also open on server. when i try to connect with workbench tool . i got error failed to connect.

Re: Failed to connect Mysql shared server database with Workbench 8.0.20 tool.

Bohdan Stupak29-Jun-20 5:26

Bohdan Stupak

29-Jun-20 5:26

It could be virtually anything. Any luck connecting to the same server with the same credentials but with a different Mysql IDE?

atabase constraints must follow relvar constraints

Tara1112-May-20 15:15

Tara11

12-May-20 15:15

The text below is from "Introduction to Database Systems, J. Date". I can't the bolded part. why since Relvar constraints must obviously be checked immediately, must database constraints be checked immediately too? Why database constraints must follow relvar constraints, please?

The previous edition of this book stated that relvar constraints were checked immediately but database constraints were checked at end-of-transaction (a position that many writers concur with, though they usually use different terminology). But The Principle of Interchangeability (of base and derived relvars--see Chapter 9) implies that the very same real-world constraint might be a relvar constraint with one design for the database and a database constraint with another! Since relvar constraints must obviously be checked immediately, it follows that database constraints must be checked immediately too. .

Convert raw byte[8192] of SQL Server XML datatype into a C# string?

arnold_w1-May-20 3:32

Re: Convert raw byte[8192] of SQL Server XML datatype into a C# string?

1-May-20 3:32

I'm trying to get the project GitHub - improvedk/OrcaMDF: A C# parser for MDF files. Allows you to read tables, metadata and indexes from MDF files without it being attached to a running SQL Server instance.[^] to work with the XML SQL Server data type. When I step in the debugger, I can see that I receive an array byte[8192] with XML-data (each ASCII character seems to occupy 2 bytes) in the file \OrcaMDF\src\OrcaMDF.Core\Engine\Records\TextRecord.cs:line 35. Does anybody know how I can retrieve the proper XML-string? I guess the start index and length of the string must be baked into the array somehow.

phil.o1-May-20 4:06

phil.o

1-May-20 4:06

You could try

string xml = System.Text.UnicodeEncoding.GetString(theByteArray);

If this does not produce proper result, you could also try one of other encodings provided by the framework: Encoding Class (System.Text) | Microsoft Docs[^].

"Five fruits and vegetables a day? What a joke!
Personally, after the third watermelon, I'm full."

Read data from Azure database with C#-application, without installing a lot of applications?

arnold_w25-Apr-20 8:24

Re: Read data from Azure database with C#-application, without installing a lot of applications?

25-Apr-20 8:24

I am writing a C# application in Visual Studio 2005 and I need to read, but NOT write, data inside an Azure database and I would like to install as few applications on my computer as possible. It would also be nice if I could simply spend a couple of minutes copying the whole database file to my computer upon startup and from then on access the data completely locally. There is no requirement that I should access the data I want through SQL-queries, if it's feasible to iterate through the database file with while-loops, if-statements, etc that would be perfectly fine with me. Is this feasible or what's the minimum I can get away with?

modified 25-Apr-20 13:31pm.

Richard MacCutchan25-Apr-20 8:42

Re: Read data from Azure database with C#-application, without installing a lot of applications?

25-Apr-20 8:42

At the very least you will need to install a Database client to read the database. Which client you need will depend on what database it is that you wish to access.

arnold_w25-Apr-20 8:45

Re: Read data from Azure database with C#-application, without installing a lot of applications?

25-Apr-20 8:45

It is a relational database I wish to access.

Mycroft Holmes25-Apr-20 13:42

Mycroft Holmes

25-Apr-20 13:42

What you are asking for makes no sense, relational databases are not simplistic text files and are generally made up of multiple tables with defined relationships which you will need to understand. You cannot scroll through the records without a client (this may be something like Excel/Access/MSSQL) but it is still a client application.

If there is a specific VIEW that has been created for you then you need to query the database to get all the records, these can be queried into a text file which you could scroll through.

You still need something to query the database. Do check the size of the download before progressing along this path OMG | :OMG:

Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

Re: Read data from Azure database with C#-application, without installing a lot of applications?

arnold_w25-Apr-20 13:58

Re: Read data from Azure database with C#-application, without installing a lot of applications?

25-Apr-20 13:58

There is only one table in the database. If it's not feasible to get the data by using a home-made function (or method), what is the minimum database client I need to install? Are there any lightweight (perhaps even open source?) clients available or do I need to install several Gbytes of SQL Server/Oracle/something else?

Mycroft Holmes25-Apr-20 14:02

Mycroft Holmes

25-Apr-20 14:02

What do you expect to "browse" the data with?

You could write a simple windows service or client which would connect and download the table. It would be very small.

Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

Re: Read data from Azure database with C#-application, without installing a lot of applications?

arnold_w25-Apr-20 21:55

Re: Read data from Azure database with C#-application, without installing a lot of applications?

25-Apr-20 21:55

Mycroft Holmes wrote:
What do you expect to "browse" the data with?

That's a good question, see below.

Mycroft Holmes wrote:
You could write a simple windows service or client which would connect and download the table. It would be very small.

So, you're basically saying I don't need a database client to get the table? What format will the table then be in when I get it locally on my computer? Will the format be something simple like tab/comma separated or XML or something so complicated (perhaps even encrypted) that I practically would need a database client to make sense out of the table?

Richard MacCutchan25-Apr-20 22:09

Re: Read data from Azure database with C#-application, without installing a lot of applications?

25-Apr-20 22:09

See my post below.

Richard MacCutchan25-Apr-20 22:08

Re: Read data from Azure database with C#-application, without installing a lot of applications?

25-Apr-20 22:08

The majority of databases are relational types. What you need to find out is what software product is used to create it: Oracle, SQLServer, MySQL, SQLite etc.

arnold_w26-Apr-20 0:31

Re: Read data from Azure database with C#-application, without installing a lot of applications?

26-Apr-20 0:31

Ok, so Azure supports a wide range of databases.

Richard MacCutchan26-Apr-20 0:35

Re: Read data from Azure database with C#-application, without installing a lot of applications?

26-Apr-20 0:35

This has nothing to do with Azure. If you want to access a database then, as I already suggested, you need to know what type of database (i.e. which product is used to manage it). And the quickest way to find that answer is to talk to the people who own it.

arnold_w27-Apr-20 0:10

Re: Read data from Azure database with C#-application, without installing a lot of applications?

27-Apr-20 0:10

It is SQL Server.

Richard MacCutchan27-Apr-20 0:23