The other option to review when you receive this error is to view your Application_Pools setting for the app_pool you are using for your application.Check the "Enable 32-Bit Applications". If this is "False", change it to "True". This may resolve your issue.

Oracle

ASP.NET

LPAD and RPAD functions in SQL

15 Mar 2012 by Member 10510822

LPAD and RPAD function works for padding in SQL Server

Create a JMS Configuration on Oracle Weblogic 11g using WSLT

23 Jun 2019 by Octavio Sanchez Huerta

Python Script using WSLT

Python

Linux

Oracle

Setting NLS_LANG Value for Oracle

10 Jan 2016 by WernfriedD

How to set NLS_LANG value for Oracle to support all special characters you need in your language/application.

Always use Binding Variables in SQL queries

28 Apr 2011 by reshi999

Thanks for that. In MS SQL Server, I use the following technique to avoid full compile:DECLARE @sql VARCHAR(100)DECLARE @pk INTSET @pk = 2SET @sql = 'SELECT id, pcname FROM pod WHERE id = ' + CAST(@pk AS VARCHAR)EXEC (@sql)-- or -- EXEC sp_sqlexec @SQL

Oracle ASP.Net membership provider ProviderUserKey endian conflict

30 Aug 2011 by Norman Paterson

Oracle scrambles the first eight characters of the UserID

Oracle

ASP.NET

How to Guarantee a Fixed Amount of Rows in a Table in Oracle

19 May 2012 by Wendelius

This tip describes how to guarantee a fixed amount of rows in a table by using triggers in Oracle.

Web-based Data Access Object

3 Apr 2013 by In the Face of God

Generalize to access data in a database via HTTP

Optimized way to join tables residing across multiple databases in Oracle

1 Apr 2013 by Karthik Narahari

Querying data from tables across multiple databases when we need data from all those tables in a single query.

.NET Reporting Tool Tutorial - 3

23 Apr 2013 by emadns

Using the Chart control in ReportMax

Using JavaServer Faces with Oracle

18 Sep 2013 by Azim Zahir

This article explains creating a JSF application using NetBeans 7.2.1 and Oracle 11G.

Out of memory issue in MyBatis

9 Mar 2014 by Davinder Singla

This tip is for solving out of memory issue for large result sets in MyBatis

Using an Oracle Database Table as a Multithreaded Work Queue

27 May 2014 by Brendan Lester

Use of an Oracle 11g Skip Lock feature to easily implement a scalable, robust work queue

Generating desired amount of rows in Oracle using single statement

31 Aug 2014 by Wendelius

Two ways of generating desired amount of rows in Oracle by using a single SQL statement.

Calculating Average Processing Time in Hours Excluding Weekends

17 Dec 2014 by Mohammed A. Mohiuddin

Calculating Average Processing Time in hours excluding weekends

SQL

Oracle

How to Resolve the "Not a Valid Month" Error with Oracle TO_DATE

3 Jun 2015 by Database Star

The "ORA-01843: not a valid month" error is quite common for Oracle SQL developers, and can be fixed in a few ways.

Attunity Connectors to Transfer Data from Oracle to SQL Server using SSIS

7 Dec 2015 by Divyant Kulshrestha

This tip is useful when we have to move data from Oracle database to SQL Server database or vice-versa using SSIS.

Using Java Codes to Capture PIV4/IPV6 Packages

20 Dec 2015 by JinWenQiang

How to capture and process packages using Java language

Creating Windows Server 2012 R2 VirtualBox VM for SharePoint 2016

18 Jan 2016 by M Faheem Zafar

This tip explains how to install Windows Server 2012 R2 Server on Oracle VirtualBox VM Server.

Connection Pool Implementation

2 Mar 2016 by Mahmoud_Gamal

Connection pool java without ConnectionContext

Java

Oracle

Oracle DB EDMX: Switch Between Prod/Test/Stage Schema Names Dynamically using Entity Framework DB First Approach

5 Jun 2020 by DiponRoy

Use same EDMX file with different Oracle database schemas

entity-framework

Oracle

General function for all DML operations using vb.net and oracle stored procedures

5 Apr 2010 by nan49

'All business logic access to the database can make use of this 'function if one is using a stored procedure.'--------------------------------------------------------------Public class classDbAccess#Region "DML OPERATIONS USING ORACLE STORED PROCEDURE" 'This take the necessary...

Oracle

Check Constraint to validate a Financial Year in Oracle

23 Jul 2010 by Ravi LVS

Check Constraint to validate a Financial Year in Oracle

Oracle

Simple query to get weekdays between two date fields

12 Jul 2011 by GregStevens

How to get weekdays between two date fields without a stored function

SQL

Oracle

LPAD and RPAD Functions in SQL

15 Mar 2012 by PIEBALDconsult

This is an alternative for "LPAD and RPAD functions in SQL"

Adding an http Security Header to Web Reference and Using Oracle CRM Stateless

4 Jun 2012 by Ismael Almonte

Adding an http security header to web reference and using Oracle CRM stateless

.NET

Oracle

Dev

Displaying a Bar Chart using SELECT command in Oracle

4 Aug 2012 by Azim Zahir

This tip demonstrates using the Select command to display a bar chart.

Oracle ADF Faces Cookbook

11 May 2014 by apis3445

This is another book about ADF

Java

Oracle

CRUD

Oracle DB EDMX: Upgrade ASP.NET Project and Entity Framework to use Oracle.ManagedDataAccess.Client

14 Jun 2020 by DiponRoy

Upgrade a legacy ASP.NET project to use managed Oracle.ManagedDataAccess.Client instead of unmanaged Oracle.DataAccess.Client while using Entity Framework DB first or EDMX.

Fetching data in order of commit of database transactions in Oracle

17 Dec 2013 by Davinder Singla

This tip provides soution details for fetching data from an Oracle database in the order in which data was commited when multiple concurrent transactions are executing.

Oracle

Dev

DBA

.NET Reporting Tool Tutorial - 1

28 Apr 2013 by emadns

A basic tutorial for ReportMax tool

How to Change Password in Oracle

26 Jul 2015 by Wendelius

This alternative is created to correct few mistakes in the original tip. Most importantly: Never update system tables.

Oracle

How to Fetch Data from the Previous or Next Rows in the Resultset

26 Jul 2015 by Wendelius

This tip demonstrates the use of LAG and LEAD functions in Oracle.

SQL

Oracle

Concept mapping between SQL Server and Oracle

13 Nov 2012 by SergioAmorim

SQL Server and Oracle terms may match, but they can have a very different meaning. This article will help you match one system to the other.

SQL

Oracle

SQL-Server

Fast and Simple IDataReader Implementation to Read CSV Files

3 Oct 2015 by shijo joseph

A simple and fast CSV reader which you can directly use against Oracle and SQL Server databases or for any direct implementation

Storing JSON Objects in BLOBS in Oracle

20 Jul 2017 by JimS12

Storing Data in Oracle

Oracle

JSON

Select a Default Row in SQL

21 Jul 2019 by DiponRoy

Select a default row for a query that returns no rows

Oracle Home Selector

10 Aug 2015 by hevesir

Oracle Home Selector

A Closer Look at Lookup Tables

20 Oct 2016 by Bryan Kowalchuk

The two most common database lookup table patterns are examined

Enumerate entries in TNSNames.ora using Oracle data provider class and DataSourceEnumerator

12 Jul 2011 by Jana Sattainathan

There is an easier way to get the Oracle data source than custom-code a TNSNames.ora parser.

PHP with Oracle 11g on Windows 7 64-bit

8 Jan 2013 by Zamshed Farhan

It’s a very common problem for those, using Oracle 11g in Windows 7 (64-bit) with PHP applications.

Setting-up Oracle Database for .NET development

8 Aug 2012 by Member 8770718

How to set-up an Oracle database for .NET development.

Fibonacci sequence in Oracle using sinqle SQL statement

5 Sep 2014 by Wendelius

This tip shows two ways of generating Fibonacci numbers in a single SQL statement

SQL

Oracle

Why Do I Have Questions to GO

9 Feb 2023 by Alexey Shtykov

Lot of fancy languages were born and have died since I started working in IT, but a few of them continue their pitiful existance.

Always use Binding Variables in SQL queries

19 Apr 2011 by Amit Kumar Tiwari

Boost application speed and performance

Adding Permissions to Add/Edit Data Models and Add Reports in BI Publisher 12c

20 May 2016 by Khrystyna Popadyuk

Provides steps to add permissions to adding or editing data models or adding reports in Oracle BI Publisher 12c.

Oracle

How to Protect from SQL Injection in PhP based website

20 Jun 2012 by chetan dudhagara

How to Protect from SQL Injection in PhP based website

Updating Database from DataGridView Using a Class Two-Tier Architecture

4 Oct 2018 by Awesh Vishwakarma

By reading this trick, you will be able to update your database from DataGridView through external class instead of writing code on each page.

Top 5 New Features in Oracle 12c for Developers

5 Dec 2016 by Database Star

Oracle 12c has many new features, and these are the five most useful (in my opinion).

SQL

Oracle

How to Convert a text Value into a date in Oracle SQL

4 Nov 2016 by Database Star

Explanation and demonstration of some Oracle SQL functions to convert text to dates

What Are The NVL and NVL2 Functions And When Should I Use Them?

24 Jan 2017 by Database Star

This article explains the difference between the NVL and NVL2 functions in Oracle SQL.

SQL

Oracle

Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed

19 Dec 2010 by Shripad J

ASP.NET website project hosted on IIS 7.5 running on Windows 2008 R2 is unable to connect to ‘Oracle’ database.

Oracle

ASP.NET

How to drop dependency constrations in Oracle for all tables

17 Nov 2009 by Slava Khristich

BackgroundI had to write a script to do some tables alternation and datamodification. I run into the problems where I had disable existingconstraints and re enable them at the end of the process. I wassearching the web for automated script to do that but whatever I foundwas not exactly w

SQL

Oracle

Auto Increment Column Options in Different Databases

4 Jul 2022 by DiponRoy

How to auto increment column options in databases

UniDAC - database's direct connection

29 Sep 2015 by Thiago Gaidzinski

UniDAC allows you to connect your cross-platform application directly with many database's types.

How to Use COALESCE with Different Data Types

7 Nov 2016 by Database Star

Use the COALESCE function with different data types correctly

SQL

Oracle

How to Implement a Custom Oracle Session Provider

27 Jun 2008 by Rob_Smith_MN

Oracle session provider

XML

Oracle

Check the input Query syntax from VB.NET

25 Dec 2011 by bluesathish

If you build the Query executer tool in a VB.NET, you need to check the input query syntax before getting the results. This tip gives you a small idea of how to get the syntactic errors from the VB.NET front end screen by calling already created stored procedure.

Oracle

syntax

How To Use Oracle's TRIM, LTRIM and RTRIM Functions

27 Dec 2016 by Database Star

How to use these three functions and what the differences are between them

SQL

Oracle

database