Re: Linking Oracle DB to SQL DB

anonymous_at_discussions.microsoft.com
Date: 02/27/04 

Date: Thu, 26 Feb 2004 15:03:01 -0800

Thanks for all the info
I was able to install the client with connection success..
but now I still get the error 7399 ole db
provider 'MSDAORA' reported an error. I will go through
the support links you provided. If I can't connect by
tomorrow I'll post again..

Thanks again
Susan
>-----Original Message-----
>Hi Susan,
>Try the following article for steps on how to set up a
>linked server to Oracle:
>HOW TO: Set Up and Troubleshoot a Linked Server to Oracle
in
>SQL Server
>http://support.microsoft.com/?id=280106
>
>-Sue
>
>On Tue, 24 Feb 2004 11:29:34 -0800, "Susan"
><anonymous@discussions.microsoft.com> wrote:
>
>>Hello
>>
>>Where can I find information on how to link an Oracle
>>database to a SQL Server. Recently I wrote a small
>>database in Access linking the tables I need from the an
>>Oracle database using ODBC drivers but had alot of
>>connectivity and locking problems. I was advised to
link
>>the Oracle server to SQL Server using Access as
frontend.
>>I am familiar with SQL Server, .net and Access but not
>>familiar with Oracle. I played with the Linked Server
in
>>SQL an was able to link other SQL servers but not Oracle
>>giving an MSDAORA error.
>>
>>I have read articles that you can't just link the Oracle
>>server using OLEDB or other connectivity sources you
must
>>install a client from Oracle. I downloaded an
OUIRelease
>>after reading the release notes I don't really know what
>>to do....
>>
>>Any information is greatly appreciated
>>
>>Frustrated
>>Susan
>>
>>Susan
>
>.
>

Relevant Pages

  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)
  • Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
    ... "Writers block readers and readers block writers in SQLServer. ... getting around this fundamental issue and because of it SQL Server ... admitted they can happen in Oracle, I guess Oracle should never been used ... isolation level but you will always disagree because you follow doctorine ...
    (comp.databases.oracle.server)
  • Problem in Accessing SQL Server Views from Oracle Using TG4MSQL(Transparent gateway Connectivity)
    ... I am using the oracle transparent gateway connectivity with sql server ... settings are concerned those were set and Connectivity is working Fine, ... sqlserver view is given below: ... Now,I made a table in oracle adjacent to sqlserver View and Inserted ...
    (comp.databases.ms-sqlserver)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... If it was the update statement that references ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... There are however differences how both products deal with concurrency; in Oracle readers don't get blocked while this may happen in SQL Server. ...
    (comp.databases.oracle.misc)
  • Re: Import problems on Windows Server
    ... XP is fine, so is Vista, like you I use them day in day out, around 12 hours ... a day myself too - laptops and the desktop i'm writing this on. ... I use SQL Server on XP and Vista for writing and demo'ing stuff, ... those are the same problems in the Oracle world. ...
    (comp.databases.oracle.server)