How to handle excel - multiple sheets integration with ODBC Driver connection in C# - C# Discussion Boards

simpledeveloper12-Jun-20 9:05

12-Jun-20 9:05

Yeah making that property value null is fine - can you please help me in this regards please? Or can you please help me with the Regex please? Thank you.

Re: Removing a field from jSon String

OriginalGriff12-Jun-20 9:06

OriginalGriff

12-Jun-20 9:06

You don't know how to set a property?

Why are you playing with JSON if you don't know the (very, very) basics?

"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!

Re: Removing a field from jSon String

James Curran17-Jun-20 20:23

James Curran

17-Jun-20 20:23

To answer this we need to know the type of SP_GlobalSearch.JsonObject. If it's something like a InspectionResult class or even a dynamic, then it's simple:

var response = t==null? null : t.Select(r=>{r.InspectionItems.Violations = null; return r;}).ToList();
 //                   purists will hate this ^^^^

If JsonObject is a System.Object, then things get messy. Best to change than to one of the options given above.

Truth,

James

Is there any good C# desktop library to implement Card liked UI dashboard?

yccheok11-Jun-20 6:31

yccheok

11-Jun-20 6:31

I have been away from Windows desktop development environment (Using C++ MFC) for many years.

Recently, I plan to port an Android app to Windows desktop environment.

I plan to use C# as my tech stack.

However, I have 0 clue on how to develop a

- Card liked UI dashboard
- Achieve drag-n-move animation

Our Android app looks like - Drag and move animation - YouTube[^]

Do you have any suggestion library, which can help me to implement so?

Thank you.

Re: Is there any good C# desktop library to implement Card liked UI dashboard?

Richard MacCutchan11-Jun-20 21:36

Richard MacCutchan

11-Jun-20 21:36

I am not sure what you mean by "Card liked UI dashboard", but drag and drop is fully supported in .NET: Walkthrough: Perform a drag-and-drop operation - Windows Forms | Microsoft Docs[^].

Re: Is there any good C# desktop library to implement Card liked UI dashboard?

yccheok12-Jun-20 6:13

yccheok

12-Jun-20 6:13

In the video, it shows how "Card liked UI dashboard" look like.

Also, this is a JavaScript implementation of "Card liked UI dashboard" - Column grid demo[^]

As you can see, the JavaScript example supports drag-n-move, and resizing.

Any idea on where I can get an equivalent C# desktop library to implement such?

Thanks.

Re: Is there any good C# desktop library to implement Card liked UI dashboard?

Richard MacCutchan12-Jun-20 6:43

Richard MacCutchan

12-Jun-20 6:43

yccheok wrote:
where I can get an equivalent C# desktop library to implement such?

If you want a ready made lbrary then Google is the place to search. Or you could just write your own code to move things around on a form.

How to handle excel - multiple sheets integration with ODBC Driver connection in C#

Member 1485915110-Jun-20 3:10

Member 14859151

10-Jun-20 3:10

Hello Everyone,

I'm currently trying to fetch data from 1 excel workbook, which is having multiple sheets

Please find my excel sheet: here

Please find my code to get the excel data

<pre>public static T GetAllTestData<T>(string keyName)
        {
            using (var connection = new
                          OdbcConnection(TestDataFileConnection()))
            {
                connection.Open();
                System.Data.DataTable dt = null;
                dt = connection.GetSchema(OdbcMetaDataCollectionNames.Tables, null);
                String[] excelSheets = new String[dt.Rows.Count];
                var i = 0;
                // Add the sheet name to the string array.
                foreach (DataRow row in dt.Rows)
                {
                    excelSheets[i] = row["TABLE_NAME"].ToString();
                    i++;
                }
                T value = default(T);
                // Loop through all of the sheets if you want to...
                for (int j = 0; j < excelSheets.Length; j++)
                {
                    // Query each excel sheet.
                    var query = string.Format("select * from [{0}] where TestName = '{1}'", excelSheets[j], keyName);
                    value = connection.Query<T>(query).FirstOrDefault();
                }
                //Console.Write(list1);
                connection.Close();
                return value;
            }
        }

Call to the function:

var param1 = AccessExcelData.GetAllTestData<TestDataModel>("Test1");

Issue:

I want to get all the values from all the sheets in excel which has TestName as "Test1" but in my method, variable value keep getting override which makes it tough for me to get all the values

Can someone look into this, or If I can have another approach for handling excel data test in c#

Re: How to handle excel - multiple sheets integration with ODBC Driver connection in C#

jsc423-Jul-20 6:43

jsc42

3-Jul-20 6:43

Your problem is in the following loop ...

for (int j = 0; j < excelSheets.Length; j++)
{
    // Query each excel sheet.
    var query = string.Format("select * from [{0}] where TestName = '{1}'", excelSheets[j], keyName);
    value = connection.Query<T>(query).FirstOrDefault();
}

As soon as you have got a value in the value field, you move on to the next sheet. You need to either do something with the value before going round the next iteration of the loop or store the values (one per sheet) e.g. in an array, and then process them all together after completing the loop.

System.Timers.Timer() called method doesn't run all code

jsmjsm10-Jun-20 1:09

jsmjsm

10-Jun-20 1:09

Not all code within the called method "displayTimeEvent" runs every 2 seconds.

var awaitExit = new System.Timers.Timer();
    awaitExit.Interval = 2000;
    awaitExit.Elapsed += displayTimeEvent;
    awaitExit.Start();


void displayTimeEvent(object source, ElapsedEventArgs e)
{	

// This code runs	
int s = DateTime.Now.Second;
displayMessage("Second: " + s.ToString());

// This code doesn't	
label1.Text += ".";				
progressBar1.Increment(20);		
}

Re: System.Timers.Timer() called method doesn't run all code

Richard Deeming10-Jun-20 1:30

Richard Deeming

10-Jun-20 1:30

The timer's Elapsed event will fire on a background thread. You can't update UI controls from a non-UI thread.

If this is a Windows Forms application, use the Windows Forms timer:
Timer Class (System.Windows.Forms) | Microsoft Docs[^]

For WPF, use the DispatcherTimer:
DispatcherTimer Class (System.Windows.Threading) | Microsoft Docs[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: System.Timers.Timer() called method doesn't run all code

Luc Pattyn10-Jun-20 1:31

Luc Pattyn

10-Jun-20 1:31

Hi,

use a System.Windows.Forms.Timer or read up on cross-thread issues e.g. here[^]

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

Unable to load file or assembly 'Oracle.DataAccess'

Member 1483395810-Jun-20 0:30

Member 14833958

10-Jun-20 0:30

753/5000
Hello,

I wanted to recover data from an oracle 9i database. I work on 64 bit systems.

I downloaded the driver ODAC112040Xcopy_64bit in which I found .dlls (among which there is Oracle.DataAccess.dll) that I added them to a windows console application under visual studio 2012 and I added Oracle. DataAccess.dll as a reference in the application. So it works for recovery.

Now, I wanted to create a web service to do this recovery.

So, I created a project of type "ASP.NET Empty Web Application" for I added an element of type web service just that displays by default "Hello Wrold". When I compile and run the application then I get the following message:

Bonjour,

Je voulais récupérer des données à partir d'une base des données oracle 9i. Je travail sur des systèmes de 64 bit.

J'ai téléchargé le driver ODAC112040Xcopy_64bit dans lequel j'ai trouvé des .dll (parmi lequel il y a Oracle.DataAccess.dll) que j'ai les ajouté à une application windows console sous visual studio 2012 et j'ai ajouté Oracle.DataAccess.dll comme référence dans l'application. Alors ça marche pour la récupération.

Maintenant, je voulais créer un web service pour faire cette récupération.

Alors, j'ai crée un projet de type "ASP.NET Empty Web Application" pour j'ai ajouté un élément de type web service juste que affiche par défaut "Hello Wrold". Lorsque je compile et j’exécute l'application alors j'ai le message suivant :

Server error in application '/'.
Unable to load file or assembly 'Oracle.DataAccess' or one of its dependencies. An attempt was made to load an incorrect format program.
Description: An unhandled exception occurred during the execution of the current web request. Check the stack trace for more information on the error and its origin in the code.

Exception details: System.BadImageFormatException: Unable to load file or assembly 'Oracle.DataAccess' or one of its dependencies. An attempt was made to load an incorrect format program.

Source error:

An unhandled exception occurred while running the current web request. Information about the origin and location of the exception can be identified using the exception stack trace below.

Assembly load tracking: The following information can help determine why the assembly 'Oracle.DataAccess' could not be loaded.

=== Prior link status information ===
JRN: DisplayName = Oracle.DataAccess
(Partial)
AVT: partial link information has been provided for an assembly:
AVT: Assembly name: Oracle.DataAccess | Domain ID: 2
AVT: Partial binding occurs when only part of the full assembly name is provided.
AVT: This can cause the workbook to load an incorrect assembly.
AVT: it is recommended to provide a fully specified text identity for the assembly,
AVT: which includes the simple name, version, culture and public key token.
AVT: For more information and solutions to this problem, see the white paper at http://go.microsoft.com/fwlink/?LinkId=109270.
JRN: Appbase = file: /// D: / Development / Projects / WebApplicationWS / WebApplicationWS /
JRN: Initial PrivatePath = D: \ Development \ Projects \ WebApplicationWS \ WebApplicationWS \ bin
Assembly calling: (Unknown).
===
JRN: this link starts in the context of loading default.
JRN: use of the application configuration file: D: \ Development \ Projects \ WebApplicationWS \ WebApplicationWS \ web.config
JRN: use of the host configuration file:
JRN: use of the computer configuration file from C: \ Windows \ Microsoft.NET \ Framework \ v4.0.30319 \ config \ machine.config.
JRN: strategy not applied to the reference at this stage (private, custom, partial or location-based assembly binding).
JRN: attempt to download the new URL file: /// C: /Windows/Microsoft.NET/Framework/v4.0.30319/Temporary ASP.NET Files / vs / b3838e6a / facd81ed / Oracle.DataAccess.DLL.
JRN: attempt to download the new URL file: /// C: /Windows/Microsoft.NET/Framework/v4.0.30319/Temporary ASP.NET Files / vs / b3838e6a / facd81ed / Oracle.DataAccess / Oracle.DataAccess.DLL .
JRN: attempt to download the new URL file: /// D: /Developpement/Projets/WebApplicationWS/WebApplicationWS/bin/Oracle.DataAccess.DLL.
ERR: unable to complete the installation of the assembly (hr = 0x8007000b). Detection completed.

Battery trace:

[BadImageFormatException: Unable to load file or assembly 'Oracle.DataAccess' or one of its dependencies. An attempt was made to load an incorrect format program.]
System.Reflection.RuntimeAssembly._nLoad (AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark & stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurity0
System.Reflection.RuntimeAssembly.nLoad (AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark & stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Booleansressressecurity)
System.Reflection.RuntimeAssembly.InternalLoadAssemblyName (AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark & stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection + BooleanSuppress15
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: Unable to load file or assembly 'Oracle.DataAccess' or one of its dependencies. An attempt was made to load an incorrect format program.]
System.Web.Configuration.CompilationSection.LoadAssembly

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é.


=== Informations d'état de liaison préalable ===
JRN : DisplayName = Oracle.DataAccess
 (Partial)
AVT : des informations de liaison partielle ont été fournies pour un assembly :
AVT : Nom d'assembly : Oracle.DataAccess | ID de domaine : 2
AVT : une liaison partielle se produit lorsqu'une partie seulement du nom complet de l'assembly est fournie.
AVT : cela peut entraîner le chargement d'un assembly erroné par le classeur.
AVT : il est recommandé de fournir une identité textuelle complètement spécifiée pour l'assembly,
AVT : qui comprend le nom simple, la version, la culture et le jeton de clé publique.
AVT : pour plus d'informations et pour obtenir des solutions à ce problème, consultez le livre blanc à l'adresse suivante http://go.microsoft.com/fwlink/?LinkId=109270.
JRN : Appbase = file:///D:/Developpement/Projets/WebApplicationWS/WebApplicationWS/
JRN : PrivatePath initial = D:\Developpement\Projets\WebApplicationWS\WebApplicationWS\bin
Assembly appelant : (Unknown).
===
JRN : cette liaison démarre dans le contexte de chargement de default.
JRN : utilisation du fichier de configuration de l'application : D:\Developpement\Projets\WebApplicationWS\WebApplicationWS\web.config
JRN : utilisation du fichier de configuration d'hôte : 
JRN : utilisation du fichier de configuration de l'ordinateur à partir de C:\Windows\Microsoft.NET\Framework\v4.0.30319\config\machine.config.
JRN : stratégie non appliquée à la référence à ce stade (liaison d'assembly privée, personnalisée, partielle ou basée sur l'emplacement).
JRN : tentative de téléchargement de la nouvelle URL file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/Temporary ASP.NET Files/vs/b3838e6a/facd81ed/Oracle.DataAccess.DLL.
JRN : tentative de téléchargement de la nouvelle URL file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/Temporary ASP.NET Files/vs/b3838e6a/facd81ed/Oracle.DataAccess/Oracle.DataAccess.DLL.
JRN : tentative de téléchargement de la nouvelle URL file:///D:/Developpement/Projets/WebApplicationWS/WebApplicationWS/bin/Oracle.DataAccess.DLL.
ERR : impossible de terminer l'installation de l'assembly (hr = 0x8007000b). Détection terminée.

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.ProcessRequestInternal(HttpWorkerRequest wr) +464

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

Re: Unable to load file or assembly 'Oracle.DataAccess'

OriginalGriff10-Jun-20 0:40

OriginalGriff

10-Jun-20 0:40

This is an English language site, and we can only answer questions posted in that language. Please use Google Translate to convert your message before posting in future.

But the error message is pretty clear:

Unable to load file or assembly 'Oracle.DataAccess' or one of its dependencies. An attempt was made to load an incorrect format program.

At a guess, the Oracle DB engine is missing (or at least partially missing), configured for 32 bit when the system is 64, or vice versa, etc. Eitehr way, this isn;t somethign we can really help you with.

Start by contacting your hosting service and ask them if they have had this problem before - they may be able to shortcut the process of working out exactly what you have done.

Il s'agit d'un site en anglais et nous ne pouvons répondre qu'aux questions publiées dans cette langue. Veuillez utiliser Google Translate pour convertir votre message avant de poster à l'avenir.

Mais le message d'erreur est assez clair:

Impossible de charger le fichier ou l'assembly 'Oracle.DataAccess' ou l'une de ses dépendances. Une tentative de chargement d'un programme au format incorrect a été effectuée.

À une supposition, le moteur Oracle DB est manquant (ou au moins partiellement manquant), configuré pour 32 bits lorsque le système est à 64, ou vice versa, etc. De toute façon, ce n'est pas le cas, nous pouvons vraiment vous aider.

Commencez par contacter votre service d'hébergement et demandez-leur s'ils ont déjà rencontré ce problème - ils pourront peut-être raccourcir le processus d'élaboration de ce que vous avez fait.

"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!

Re: Unable to load file or assembly 'Oracle.DataAccess'

Dave Kreskowiak10-Jun-20 2:14

Dave Kreskowiak

10-Jun-20 2:14

When you get a BadImageFormat exception, it usually means you're trying to mix 32 and 64-bit code in the same process.

From your description, you are probably trying to use a 64-bit .DLL in a 32-bit app, or your code is running as 32-bit instead of 64.

Asking questions is a skill
CodeProject Forum Guidelines
Google: C# How to debug code
Seriously, go read these articles.

Dave Kreskowiak

Re: Unable to load file or assembly 'Oracle.DataAccess'

Member 1483395810-Jun-20 5:33

Member 14833958

10-Jun-20 5:33

the same error !!!

Re: Unable to load file or assembly 'Oracle.DataAccess'

Dave Kreskowiak10-Jun-20 19:17

Dave Kreskowiak

10-Jun-20 19:17

Considering you never said what change you made and what the IIS app and app pool settings currently are, there's nothing anyone can tell you.

Asking questions is a skill
CodeProject Forum Guidelines
Google: C# How to debug code
Seriously, go read these articles.

Dave Kreskowiak

Re: Unable to load file or assembly 'Oracle.DataAccess'

Member 1483395811-Jun-20 3:00

Member 14833958

11-Jun-20 3:00

Bonjour,

le driver Oracle Data Access de version 64 bits

Lorsque je crée un application console çà marche pour le driver.
Lorsque je crée une application web asp.net alors le driver ne fonctionne. Les propriétés de cette application :
- target framework 4.0
- Platform target : any CPU
J'ai changé "any cpu" par "X86" mais le même problème puis avec "X64" aussi le même problème

- le web : J'ai coché l'option "use Visual Studio Development Server"
au lieu de "use Local IIS Web Serve"

Re: Unable to load file or assembly 'Oracle.DataAccess'

Dave Kreskowiak11-Jun-20 3:21

Dave Kreskowiak

11-Jun-20 3:21

Translated:

Quote:
Hello

Oracle Data Access driver of 64-bit version

When I create a console app it works for the driver.
When I create a web application asp.net then the driver does work. The properties of this application:
- target framework 4.0
- Platform target: any CPU
I changed 'any cpu' to 'X86' but the same problem then with 'X64' also the same problem

- the web: I checked the option "use Visual Studio Development Server"
instead of "use Local IIS Web Serve"

A console app is not an ASP.NET app. They work in completely different ways.

A platform target of "AnyCPU" runs, by default either as the CPU architecture on older versions of .NET or as a 32-bit app.

Changing the platform target to "X86" forces the app to run as 32-bit only, even on a 64-bit machine.

Change the target to x64 to match the architecture of the .DLL's you're using. In IIS, in the Application Pool you are running your code under, under Advanced Options, there is an option to run the app as a 32-bit app instead of 64-bit. If that setting is turned on, your code will run as 32-bit instead of 64-bit.

Also, you MUST install the Oracle Client on the IIS server in order for Oracle database access to work.

Asking questions is a skill
CodeProject Forum Guidelines
Google: C# How to debug code
Seriously, go read these articles.

Dave Kreskowiak

modified 11-Jun-20 12:16pm.

Re: Unable to load file or assembly 'Oracle.DataAccess'

Member 1483395811-Jun-20 3:47

Member 14833958

11-Jun-20 3:47

Je vous informe que dans les paramètres avancés de pool application que l'option " activer les applications 32 bits" est déja comme valeur "false"
j'ai changé "Platform target" à X86
mais le même message d'erreur.

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.

Re: Unable to load file or assembly 'Oracle.DataAccess'

Dave Kreskowiak11-Jun-20 3:50

Dave Kreskowiak

11-Jun-20 3:50

Translated:

Quote:
I inform you that in the advanced application pool settings that the option "activate 32-bit apps" is already as "false"
I changed "Platform target" to X86
but the same error message.

Can't load the 'Oracle.DataAccess' file or assembly or any of its dependencies. Attempting to load an incorrectly format program.

Uhhh... I just got done telling you that x86 means "32-bit" and running 32-bit code in the App Pool is turned OFF. Change the platform target back to x64.

Now, if you're deploying just a single Oracle .DLL with your app, you're definitely doing it wrong. Oracle requires and entire Client installation in order to work. Just deploying one of two .DLL's with Oracle in the name will NOT WORK.

Asking questions is a skill
CodeProject Forum Guidelines
Google: C# How to debug code
Seriously, go read these articles.

Dave Kreskowiak

modified 11-Jun-20 12:17pm.

Re: Unable to load file or assembly 'Oracle.DataAccess'

Member 1483395811-Jun-20 6:31

Member 14833958

11-Jun-20 6:31

Bonjour,

J'ai téléchargé le dossier .zip ODAC112040Xcopy_32bit et ODAC112040Xcopy_64bit
Est ce que je dois utiliser ODAC 32bit ou bien ODAC 64bit ?

Ce dossier contient plusieurs types de dll
alors quel(s) .dll à ajouter dans mon projet ?

Re: Unable to load file or assembly 'Oracle.DataAccess'

Dave Kreskowiak11-Jun-20 7:55

Dave Kreskowiak

11-Jun-20 7:55

Translated:

Quote:
Hello

I downloaded the .zip folder ODAC112040Xcopy_32bit and ODAC112040Xcopy_64bit
Do I have to use ODAC 32bit or ODAC 64bit?

This folder contains several types of dll
so what .dll to add to my project?

You're doing this all wrong. You don't just add a .DLL to your project. Oracle does not work that way. Forget what you downloaded.

You have to install the Oracle Client and add ODP.NET to your project through the Nuget Package Manager under the Tools menu in Visual Studio. In NPM, search for "ODP.NET4" and add that to your project.

When deploying your application to a server, that server must also have the Oracle Client installed else your application will not work.

Asking questions is a skill
CodeProject Forum Guidelines
Google: C# How to debug code
Seriously, go read these articles.

Dave Kreskowiak

Re: Unable to load file or assembly 'Oracle.DataAccess'

Jörgen Andersson11-Jun-20 8:34

Jörgen Andersson

11-Jun-20 8:34

Actually, the XCopy installation of Oracle client should work if you add all the files to the bin folder.
But only if you don't have another installation with another bitness.

Wrong is evil and must be defeated. - Jeff Ello

Re: Unable to load file or assembly 'Oracle.DataAccess'

Member 1483395811-Jun-20 21:24

Member 14833958

11-Jun-20 21:24

Bonjour,

J'ai téléchargé "ODAC112040Xcopy_32bit" et j'ai copié les .dll necessaires dans mon projet et j'ai ajouté le driver "Oracle.DataAccess.dll" dans la partie reference de mon projet. J'ai target platform avec 32 bit.
Après compilation et exécution, alors le driver a été bien chargé mais je ne peux pas connecter au base oracle sachant que de version 9i et lire le contenu d'une table.
J'ai le message suivant :

System.TypeInitializationException: Une exception a été levée par l'initialiseur de type pour 'Oracle.DataAccess.Client.OracleConnection'. ---> Oracle.DataAccess.Client.OracleException: The provider is not compatible with the version of Oracle client
   à Oracle.DataAccess.Client.OracleInit.Initialize()
   à Oracle.DataAccess.Client.OracleConnection..cctor()
   --- Fin de la trace de la pile d'exception interne ---
   à Oracle.DataAccess.Client.OracleConnection..ctor(String connectionString)
   à WebServiceToBD.Service1.view_data() dans d:\Developpement\SiteVs2012\WebServiceToBD\Service1.asmx.cs:ligne 48

Voici le code de méthode :

  public DataTable view_data()
        {
            OracleConnection conn = new OracleConnection("Data Source=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = *.*.*.*)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = ***)));User ID=***;Password=***");
            conn.Open();
            OracleDataAdapter dr = new OracleDataAdapter("select * from Personne", conn);
            DataSet ds = new DataSet();
            ds.Tables.Add("Personne");
            dr.Fill(ds,"Personne");
            DataTable tt = ds.Tables[0];
            return tt;
        }
<pre lang="c#">

La ligne 48 correspond au code suivant :

<pre lang="c#">OracleConnection conn = new OracleConnection("Data Source=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = *.*.*.*)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = ***)));User ID=***;Password=***");

Cette chaîne de connexion existe dans le programme et pas dans le fichier "Web.config".

modified 12-Jun-20 3:54am.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.