No announcements
Found 2879144 threads
-
2 Votes
Setting Up An Oracle Linked Server
*EDIT* I installed Oracle Data Access Components and now I get this error Cannot ...Answered | 5 Replies | 17632 Views | Created by jameslester78 - Thursday, September 15, 2011 3:02 PM | Last reply by André du Plessis - Wednesday, June 3, 2015 1:13 PM -
2 Votes
Serious problem with linked server to Oracle
Not all of the data types in Oracle are supported by SQL Server.Answered | 6 Replies | 29477 Views | Created by beroetz - Monday, May 15, 2006 2:48 PM | Last reply by Mikes2nd - Friday, March 4, 2011 3:34 PM -
1 Votes
Linked server to Oracle - permissions
Everybody on your SQL Server will use the Oracle using this account on your Oracle.Answered | 10 Replies | 1166 Views | Created by Miha.A - Friday, June 13, 2014 1:23 PM | Last reply by Miha.A - Monday, June 16, 2014 10:40 AM -
1 Votes
Linked server to oracle
Hi RoyalM, Here is a reference about setting up linked server to ...Answered | 2 Replies | 2728 Views | Created by RoyalM - Thursday, December 20, 2012 12:10 PM | Last reply by Iric Wen - Tuesday, December 25, 2012 8:29 AM -
1 Votes
Linked to Oracle servers
Oracle has an OLE-DB provider for oracle that Microsoft provides to add it as linked server to SQL Server group.Answered | 3 Replies | 3629 Views | Created by Caladiya - Wednesday, June 24, 2015 5:49 AM | Last reply by Ahsan Kabir - Wednesday, June 24, 2015 4:53 PM -
2 Votes
Linked server to Oracle
After adding the linked Server and trying to browse it the following error occurs: *** Failed to retrieve data for this request.Answered | 3 Replies | 15424 Views | Created by Miha.A - Tuesday, June 10, 2014 8:37 AM | Last reply by Miha.A - Wednesday, June 11, 2014 10:27 AM -
0 Votes
Provider to link to Oracle server
You need the 64bit Oracle Client including the OleDB Provider.Answered | 1 Replies | 1217 Views | Created by w85 - Wednesday, March 5, 2014 9:11 PM | Last reply by davidbaxterbrowne - Wednesday, March 5, 2014 9:17 PM -
0 Votes
Linked server oracle to SQL server
This is also a known bug on Oracle Server.Answered | 2 Replies | 1136 Views | Created by Khushi N - Tuesday, March 3, 2015 1:13 PM | Last reply by Prashanth Jayaram - Tuesday, March 3, 2015 3:17 PM -
0 Votes
Linked server connection to oracle
Is the Oracle client setup correctly, especially the Tnsnames.ora file?Answered | 3 Replies | 2376 Views | Created by CSharp Enthusiast - Tuesday, July 28, 2015 2:10 AM | Last reply by Lydia Zhang - Wednesday, July 29, 2015 7:34 AM -
0 Votes
SQL Server linked to Oracle
Or is that reserved for SQL Server DBs only?Answered | 3 Replies | 5396 Views | Created by bobk544 - Friday, November 20, 2009 4:00 PM | Last reply by Brian Tkatch - Monday, November 23, 2009 2:42 PM -
1 Votes
immortal query with Oracle linked server
I have this issue too, but for AS400 linked server.Answered | 7 Replies | 4213 Views | Created by pateykin - Thursday, April 2, 2015 7:07 AM | Last reply by MaxRem - Friday, August 11, 2017 6:36 AM -
0 Votes
Linked Server Set-Up and Access
I assume that you had a deeper meaning with setting up the linked server?Answered | 3 Replies | 1451 Views | Created by ITBobbyP - Friday, May 29, 2020 11:23 PM | Last reply by Cathy Ji - Tuesday, June 2, 2020 1:42 AM -
0 Votes
SQL Server 2008 64bit Linked Server Connectivity to Oracle
We were able to run openqueries through a linked server to the same Oracle server in an SQL 2005 32bit environment.Answered | 3 Replies | 5949 Views | Created by Ted.Stillwell - Wednesday, May 27, 2009 7:01 PM | Last reply by Raj Kasi - MSFT - Wednesday, May 27, 2009 9:03 PM -
0 Votes
oracle linked server from sql server 2008R2
Hello, Install Oracle Client 11.2 or later.Answered | 1 Replies | 21822 Views | Created by sh226 - Wednesday, May 23, 2012 9:05 PM | Last reply by Alberto Morillo - Thursday, May 24, 2012 2:10 AM -
0 Votes
Oracle linked server column type
Hi Diegocnt The following example returns the data type of the JobTitle column of the HumanResources.Employee table in the AdventureWorks2012 database on the ...Answered | 2 Replies | 692 Views | Created by DIEGOCTN - Friday, September 9, 2016 1:27 PM | Last reply by Ricardo Lacerda - Friday, September 9, 2016 1:56 PM -
0 Votes
Db link between SQL Server 2008(64bit) and Oracle 11g(64bit)
Hi Yong’s, Regarding to your description, seems you want to create a linked server to an Oracle database in SQL Server.Answered | 2 Replies | 15925 Views | Created by Yong's - Friday, January 6, 2012 8:45 AM | Last reply by amber zhang - Tuesday, January 10, 2012 2:03 AM -
0 Votes
Linked Server to Oracle using Windows Authentication
Can I use a dedicated windows AD user to connect to Oracle via linked server?Answered | 8 Replies | 2052 Views | Created by sqlstar - Wednesday, January 25, 2017 6:38 PM | Last reply by sqlstar - Tuesday, January 31, 2017 7:27 PM -
0 Votes
Linked server config shows no Oracle provider
Then restart the SQL server services and go to linked server and then you can able to view the oracle driver in it.Answered | 6 Replies | 10465 Views | Created by nemohm - Thursday, December 2, 2010 5:47 PM | Last reply by Thirunavukkarasu RM - Wednesday, December 15, 2010 8:35 AM -
0 Votes
Link SQL to Oracle
If you want CDC for Oracle, SQL Server 2012 EE has it in the box SQL Server 2012 Change Data Capture for Oracle .Answered | 5 Replies | 2343 Views | Created by msloy - Monday, May 6, 2013 8:22 PM | Last reply by davidbaxterbrowne - Thursday, May 9, 2013 2:01 PM -
0 Votes
LINKED SERVER, Slow performace for SQL Server to Oracle data migration
I have not worked with migration to Oracle, but linked servers does not sound like the right thing, not with those volumes.Answered | 4 Replies | 11726 Views | Created by bharanikrishna - Tuesday, August 17, 2010 12:03 PM | Last reply by Kalman Toth - Wednesday, August 25, 2010 5:51 PM - Items 1 to 20 of 2879144 Next ›
No announcements