Tag: oracle

Cancel Oracle procedure from SQL Server procedure when cancelled

I’m executing a stored procedure on the SQL Server side. In some part of this procedure, a remote Oracle procedure is called using execute (‘ begin oraprocname(procparams); end;’) at remotedb. Today, I needed to stop executing this procedure so I have used cancel query on SQL Server side. The problem is that SQL Server was […]

ARCGIS – ST_GEOMETRY from ORACLE to SQL Server

I have an ESRI Geodatabase stored on an Oracle System. This is where the data is generated and is considered the source system. I need to be able to run a job that extracts and imports the data into a SQL Server database (also leveraging ESRI sde). I know will have an issue with bringing […]

Issue connecting Oracle 11g to SQL Server 2012 — ORA-12523: TNS:listener could not find instance appropriate for the client connection

I have Oracle 11g and SQL Server 2012 installed on the same virtual machine. OS is Windows Server 2012. I want to access SQL Server 2012 from Oracle. I created the machine a few days back to test the connection process before applying it on server. I had come through several issues but now I […]

SSIS Oracle 32 bit error “Invalid access to memory location.”

My SSIS extracts data from Oracle DB and loads into the excel file. I am running this package via SQL Job. Now to use Excel providers I have to use 32 bit environment. So I’ve changed the SQL JOB execution to “Use 32bit runtime”. But now my oracle task is failing with error “Invalid access […]

Oracle to SQL Server database migration for an ASP.NET project

I have to perform an Oracle to SQL Server database migration on an ASP.NET project so I’m basically working on the C# code to modify the db related classes/methods to fit the new database. In particular, there is a use in the code of the line DbProviderFactory myFactory = DbProviderFactories.GetFactory(“Oracle.DataAccess.Client”); I don’t know how to […]

Query is Perfectly running in SQL Server Management Studion but not running through my Windows form Application (C#)

I am working on an application which will transfer the data from SQL SERVER to ORACLE. I have a linked object of oracle in sql server, I am inserting the data directly from sql server to oracle (as it is the requirement). The problem is that, my INSERT statement is giving me error when i […]

Entity Framework with Oracle AND SQL (switch automatically)

I maintain an asp.net MVC application which uses Entity Framework (database first) and connects to an oracle database. My question: How can I switch between oracle and SQL server using entity framework? The meaning has the ability to get data from both oracle and SQL server. Also, the switch from oracle to SQL server (if […]

Equivalent of Index options (using index) in Oracle to SQL Server 2014

I need to move the data from Oracle database to MS SQL Server 2014. But I got the problem with this “USING INDEX” statement which help me in oracle to add some constraint. I would like to know if someone could provide me and equivalence of “USING INDEX” in Sql Server. CONSTRAINT “MESSAGE_LOG_RECORD_PK” PRIMARY KEY […]

Pulling data from multiple databases on different db connections with a common target table

think of this scenario.. We have a web service that communicates with and pulls data from multiple, say 5, 6 or even 10K, databases. Each database has its very own design, tables and columns but they all implement a “Users” table. Our web service must look in each of those “Users” tables and access their […]

Data from Oracle to SQL Server

I have SQL Server 2012 and I need get into it data from Oracle. I go true manual: https://www.sqlshack.com/link-sql-server–oracle-database/ and I stack with files: sqlnet.ora and tnsnames.ora I read and saw youtube manuals how to make values into sqlnet.ora and tnsnames.ora but it does not work. Files sqlnet.ora and tnsnames.ora I try created new but […]

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.