I tried this and I receive an error that say I have the wrong number of paramters.  It wants a paramter for the Ref Cursor that is being returned. 

Any...

I receive the same error indicated above when I enclose in parens.  Thanks for the suggestion though.

Has anyone gotten this to work in the past?  If so, maybe I have...

I tried that and recevied this error:

[Microsoft][ ODBC Driver for Oracle]Invalid Parameter Number

I am passing the correct number of parameters (3), but still receive this error.

Any other thoughts?

Couldn't you send the transaction logs to the other server and apply them there. 

My tables all have primary keys, as well as other indexes.

I think the issue is the the Primary Key is a data type of Bigint in which case Access does not...

The tables I am trying to view each have a clustered index as well as several non-clustered indexes so I do not think that this is my specific issue. 

I...

Thank you.  I'm not sure why I didn't think of that.  It works great

How would I reference the Jet Replication Objects library from within VBScript (DTS ActiveX Script Task)?

We have had some issue when passing dates to Oracle.  We now include something like the following which helps aliviate any issue in date conversion on the Oracle side. 

=====

WHERE...

Thanks Frank, that article has some great ideas!

We are required to access the database through stored procedures.  So the client couldn't just select against a view in our situation.  Thanks for the idea though

How would a view help? 

My DBA doesn't want me to use it because of  performance and security concerns.

Actually what I am trying now is to use an Environmental variables (COMPUTERNAME which equates to the @@servername in our environments) to change the Data Source property of my SQL Server...

But don't you need to already have a connection with the server to then query the serve for the @@servername? 

Yeah, this didn't work when I switched environments because the...