Re: Issue Select statement from SQL Server 2000 to obtain data fro

No, that is not possible. Each storage engine and data source requires
different authentication and security credentials. Why do you want to
use a single connection?

--Mary

On Mon, 16 Jun 2008 15:13:01 -0700, rmcompute
<rmcompute@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Thank you for your reply. What I was wondering is if I could write a select
query in SQL Server which connects to Oracle using the same connection as I
did within Access.

"Mary Chipman [MSFT]" wrote:

If you are using Access, then you can create a second ODBC connection
and pass-through query to select data from SQL Server. If you want to
join the results, then create an Access query based on the 2
pass-through queries. HTH,

Mary

On Sat, 14 Jun 2008 05:57:01 -0700, rmcompute
<rmcompute@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I created an ODBC connection with the Microsoft ODBC for Oracle driver and
successfully connected to Oracle from Microsoft Access by creating a pass
through query. Can I use this connection from within SQL Server 2000 to
issue a Select statement and pull data from an Oracle table? i.e. Select *
from Oracle.dbo.<table Name>

.

Relevant Pages

  • Re: ADO.NET the fastest? My foot!
    ... variety of data providers, but they're all ADO.Net Data Providers. ... The Microsoft provider for Oracle ... You're not factoring in database connection times (are you using pooled ... are as follows - it is an average of five executions of the same query. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Query from ms sql server question
    ... For example, in my worksheet, there a cell which user will enter the production number and macro will perform an automatic connection to sql server and query the table base on the production number and retrieve the data base on the production alone and place it on the excel sheet. ...
    (microsoft.public.excel.programming)
  • Re: ANSI_WARNINGS error in Stored Procedure
    ... The error says to set these options for your _connection_ not for the query. ... > I have a linked Server on my regular SQL server, and when I try to create ... a stored procedure that reads from the linked server, ...
    (microsoft.public.sqlserver.security)
  • Re: Pivot Table Timeout
    ... If the query takes a long time and times-out, it can be adjusted with properties in the SQL connection string. ... 'Open Connection to remote SQL Server ...
    (microsoft.public.office.developer.web.components)
  • Re: Pivot Table Timeout
    ... If the query takes a long time and times-out, it can be adjusted with properties in the SQL connection string. ... 'Open Connection to remote SQL Server ...
    (microsoft.public.office.developer.web.components)
Loading