.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

I can't link a Oracle 10 with a SQL Server 2008 R2

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :WPF

Hello, I am trying to migrate from a "SQL Server 2005" to a "SQL Server 2008 R2" on 64 bits. In my old SQL 2005, I have a link to a Oracle Server via MSDAORA "Microsoft OLE DB Provider for Oracle", but this option does not come in the new SQL Server 2008. I tried with the Oracle's provider, but does not work, and in this forums I read that I should use the "Microsoft OLE DB Provider for Oracle", How can I get "Microsoft OLE DB Provider for Oracle" for a "SQL Server 2008 R2" on 64 bits?

Thank you


View Complete Post

More Related Resource Links

SQL server 2008 to oracle replication

Hi, I am trying to replicate data from a sqlserver to an oracle 11 subscriber(push subscription). I recently moved to SQL server 2008 from 2005. The replication in 2005 worked ok, and now in 2008 - it does not. The problem: It tries to make some fields as an interval data type in Oracle. For example, nvarchar(3) are turned into interval and numeric(38,8) fields are turned into nvarchar2(40). Anyone has any idea why is this happening and how can I change it?

Transforing the Data from Oracle to SQL Server 2008

Hi all I have to create a SSIS package which can Transfer the Data from Oracle to SQL Server 2008. Every time when packages run it will suppose to create tables in SQL Server Database. I guess it is possible with export and Import, but the privies tables suppose be deleting before or after dumping.   Suggest me best method to do this.     Thanks in advance     SNIVAS

Server 2008 R2 64 bit, SSRS 2008 64 bit with Report Builder 3.0 issues with Oracle OLE Driver

Folks, ran out of idea on this issues. Setup as shown at the Title. I can connect via VS 2010  but report builder cannot run properly when setup with connection string. I use a 32 bit Oracle Driver and VS 2010 works well with it, however, Report Builder on SSRS report a bad image issues while attempting to use the same driver. What have been tried: 1-Already attempted to try to download Oracle ODP drivers 64 bit, but current driver 11g and minor version above 11g does not install, installation failed. So far all chats indicated that Server 2008 R2 does not have a Oracle 64 bit driver provided y Oracle. Any help is appreciated ....    

ASPNETDB.mdb and SQL Server 2008 R2 Express link

Hello I am new to ASP.NET - still learning! I have SQL Server 2008 R2 Express and Visual Web Developer 2010 Express installed on my PC.   I want users to login to my site and add listings that must be linked to their username.  ASP.NET generates the ASPNETDB.mdb file when using login / membership function. How do I access this database from SQL server 2008 R2 Express ? How do I link this database to my own SQL express database? Please help!!!

Sync Oracle and SQL Server 2008


Does anyone know of a way that I could sync a few contact info views from an OracleDB to SQL Server without spending thousands on syncing software?

Best Regards

Sql Server 2008 (64bit) on Windows Server 2008 with a connection to Oracle 10g (64bit)



I know there are similar questions posed but none that provided a solution to my particular problem.

I am upgrading a SSIS package from Sql Server 2005 (32bit) to Sql Server 2008 (64bit) on Windows Server 2008 R2. It worked on the Sql Server 2005 machine. This package connects to an Oracle 10g (64bit) database.

The Oracle 11g client and networking tools are installed (by the Oracle DBA). I tested my connection on the sql server 2008 machine using SqlPlus and doing a tnsping. I can also create a Windows ODBC datasource connection to the Oracle 10g database.

The package executes properly on my local computer XP (32bit) running bids 2008.

The package fails on the server in SSIS. I need to be able to schedule the package in a job so it must run in SSIS.

I have also tired to create a connection manager to the Windows ODBC oracle connection without success. It is blank and does not allow me to select or refresh to view the Windows ODBC datasources.

Any assistance would be greatly appreciated. I have seen other forums where installing the Oracle 11g ODAC and Oracle Developer Tools for Visual Studio might assist in creating the package. But I need assistance in running the package from SSIS and not BIDS.






Clustered SQL 2008 R2 x64, Oracle linked server works on one node, fails on the other


Juicy bits:

- SQL Server 2008 R2 x64

- Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)   Apr  2 2010 15:48:46   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) 

- Active/passive cluster

- Oracle client 11gR1

- "Allow Inprocess" provider option is enabled


I'm stumped.  Our development, QA and UAT environments are all running the same versions of Windows, SQL, and Oracle client.  Linked server between SQL and Oracle works just fine.


Production is clustered.  The linked server works just fine on one node of the cluster, but if we failover to the other node, attempts to use the linked server in any way, OPENQUERY, GUI, etc..., cause the following error:

OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLE" returned message "ORA-12634: Memory allocation failed".

Msg 7303, Level 16, State 1, Line 1

Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLE".


What am I missing?  I've reinstalled the Oracle client on the defective node, verified that the SQL Server service account has full rights to the Oracle client dir

Error on mapping oracle varchar2 to sql server 2008 using import facility, defaults to type 129 in m



I am trying to use the import wizard to import an oracle 10g table into an sql server 2008 (10.0.2531) database, it comes up with the error 'data types of source columns were not mapped correctly to those available on the destination provider'. When I go into 'edit mappings' it shows all the varchar2 oracle columns mapping to type 129 ? all the other columns have normal mapping types. If i go through and change 129 to varchar the import will work ok.

I understand that in c:\Program files\microsoft sql server\100\dts\mappingfiles there is a series of files that map datatypes to/from different sources, there are 3 files

oracleclienttomssql , oracleclienttomssql10 , oracleclienttossis10 which have a varchar2 to nvarchar mapping

and 2 other files  oracletomssql ,  oracletomssql10 which map varchar2 to varchar and one other file, oracletossis10 which maps varchar2 to dt_str

I running the import on a server with an Oracle client installed with sql server 2008 (10.0.2531).

I am not sure which mapping file is being used ? and whichever one is being used it should provide a mapping rather than type 129 (whatever that is).

I would like to get this mapping resolved as I have many tables to import and over time the structure of the Oracle tables will change so I want to use import as the easiest optio

2008 server Access database connecting win7 workstation with ODBC link works extremely slowly


I have an Access database on a 2008 server (64 bit), and notebooks with 32 bit win7. The program using the mdb is written in delphy, and running on my notebook, and working on data extremely slow. What can be the problem?

The database connector is an ODBC linked network drive.

On that same configured PC with XP it works normally.


Microsoft OLE DB Provider for Oracle 64-Bit, SQL Server 2008: Does it exist?



Does anyone know if the "Microsoft OLE DB Provider for Oracle" in 64-Bit Windows exists in SQL Server 2008 64-bit?  It only existed in 32-bit SQL 2005,  which was a big problem.    Needed for Linked Server creation.  We do not want to use OPENQUERY calls with the native Oracle 10G driver,  too many coding changes.


Thank You

How to link a SQL Server 2008 to a SQL Server 2005?



is it possible to have a SQL Server 2005 (CONFIGMGRSRV) linked to a SQL Server 2008 (VOSSQL

EXEC sp_addlinkedserver @server= 'CONFIGMGRSRV', 
@srvproduct ='', 
@provider = 'SQLNCLI10', 
@datasrc = 'OperationsManager',
@provstr ='DRIVER={SQL Server};SERVER=VOSSQl1;UID=AD\dominiqued PWD=xxxxxxx;'

1)? What is(are) the requirements?





System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager

How to Use SQL Server to Link to a Table in Oracle?


How to Use SQL Server to Link to a Table in Oracle?

I have an Access DB that links to Oracle in pulls in the data I need.  I know Access quite well.  I am now trying to learn how to use SQL Server.  As a self-motivated training exercise, I am trying to get SQL Server to do exactly the same thing that my Access DB does.  I googled around for a solution on the web, and amazingly I didn’t find anything useful.  I thought there would be dozens of tutorials out there about this knid of thing.  Can someone please send me a link to a nice step-by-step tutorial for using SQL Server to link to Oracle?  Or, can someone give me step-by-step instructions about what to do?

I am using SQL Server Management Studio Express.

Thanks so much!!!

Loading XML from Ora(Link Server) to SQL 2008


All, I have a linked Server to Oracle DB. There is a table which has XML Documents, EID, Created_Date. It has some 100,000 XML Documents I already manually loaded in to SQL.

Now, I have to create a procedure that runs weekly to update SQL DB. Every week the ORA(Link Server) is refreshed. Now I do not want to reload the whole table again and again. So i though using OpenQuery and say where EID not in SQL then take only those records. (Average New XML Documents every week 10,000). When I run thie EID not in SQL DB its taking so much time for only 10,000 records. Any suggestions are welcome to load on a regular basis in lesser time. Thanks

Linked Server using Oracle OLEDB 64-bits Win 2008 R2



I have 2 boxes running SQL Server 2008 and using linked Oracle OLEDB that behaves different for same query.

On 1st machine, using win 2003 , SQL Server 2008 SP1 on a 64-bit server I  I created a linked server to Oracle database using Oracle OLEDB provider. When I submit query to a Oracle database using Oracle OLEBD using WHERE clause, this WHERE clause is sent to Oracle, then it uses an index to resolve query and send result already filttered to SQL Server.

I have a 2nd box running Windows 2008 R2, SQL 2008 SP2 on a 64-bit server and queries are working fine, but when I filter some column of a linked server table using WHERE clause, SQL Server sends to Oracle SELECT without where clause, Oracle performs a table scan on that table and then sends results to SQL Server, that applies filter to the result. 

The problem is that some Oracle tables are huge and sending a SELECT without where clause causes table scans on Oracle, what should be avoided.

I already tried to change OLEDB properties and also tried to change linked server properties, but none of them solved the problem.

Does anyone knows what I should change on 2nd server to make it works like 1st server?

Se a resposta resolveu sua questão ou problema, classifique-a para manter a qualidade do forum e a confiabilidade dos p

Sql Server 2008 Tutorials

This Link Provides total Sql Server 2008 Tutorials

Seven reasons to care about SQL Server 2008 R2

Microsoft begins to fully realize its vision of SQL Server as an information platform and not "just" a database. Hence the main theme for this release -- at least according to Microsoft -- is self-service BI. The PowerPivot plug-ins for Excel 2010 and SharePoint 2010 are easily going to make the biggest splash of all the new features, not least because they're the most complete. But then, SQL Server 2008 R2 isn't strictly necessary for PowerPivot for Excel, which works with plenty of other data sources.

Error upgrading SQL Server 2008


i was normally using VS2005 and SQL server 2005...

i upgraded to SQL Server 2008... and then...

i could not build my project anymore... because of this error:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
Exception Details: System.IO.FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Source Error: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend