Windows Oracle Data Access Components (MOSC)

MOSC Banner

OLE DB provider “MSDASQL” for linked server returned message “[Microsoft][ODBC driver for Oracle]ora

edited Jun 29, 2010 8:51PM in Windows Oracle Data Access Components (MOSC) 8 commentsAnswered

Hello all,

Our product runs on both SQL Server and Oracle Database. Going forward we want to add new feature, to Migrate data from SQL Server data to Oracle and vice-versa. Our product has around 150 tables. Data migration for Oracle to SQL Server using linked server working well for us, but SQL Server to Oracle on same environment giving error on one point. It migrates few table but  fails to migrate

Machine 1: Source environment

WINDOWS 2003 Server SP2,

SQL Server 2005 SP2 and Oracle 10G Client,

 msorcl32 version is 2.576.3959.00

This is how linked server is being setup on SQL Server:

EXEC sp_addlinkedserver

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center