Hi Andrew,

Also have the same issue where on server A you can run a query...

Hi Jenny,

             Have you solved this ? Have the same need (to email a report ONLY when there is data).

Thanks, Steve.

If you have not done an openquery update with multiple tables then you do not know what were talking about. This has nothing to do with a standard join, or...

Do you have the correct syntax ? Have not been able to get this to run without error.

In sql talk the query did not run until......

SQL> SELECT ID FROM PART WHERE ID = 'SJ3463';

ID

------------------------------

SJ3463

so then it was just a matter of playing with it until......

Hi Jerry,

          Am trying to connect to an Oracle 8i server using openquery but can not get around

........

An error occurred while preparing a query for execution against OLE DB...

Thanks for the reply Jerry ! Need to do this in a stored procedure. Will test it out shortly and get back to you. This would be a HUGE benefit...

Done. Just a matter of using the security properties tab and modifying group priviledges.

Ok,

     Have an update. Created an Oracle view which now contains no nulls in the date field we are interested in selecting. Query analyzer returns and converts the data from...

Ahaaa ! Thanks Neil, this is becoming clearer now. No problem, now have a nice oracle stored procedure that is expecting two data parameters. Only need to figure out how...

Hi Neil,

          Many, many thanks for your reply. Had seen another post on openquery and have been successfull in returning all the data from oracle using SQL QUERY ANALYZER. The...

Thanks for the reply Bob,

                                   Sticky situation here with having nulls in some of the date fields. Ultimately need to write a sql server stored procedure to access the...