November 19, 2003 at 4:09 am
I am trying to set up a linked server to Oracle using Oracle Provider for OLE DB. In EM this shows me the tables but I can't get any data from them in QA. Depending on the table I get
Server: Msg 7320, Level 16, State 2, Line 1
Could not execute query against OLE DB provider 'OraOLEDB.Oracle'.
or
Server: Msg 7356, Level 16, State 1, Line 1
OLE DB provider 'OraOLEDB.Oracle' supplied inconsistent metadata for a column. Metadata information was changed at execution time.
Although I've had success with the MS Oracle driver I am having trouble with particular tables and want to be able to test with both drivers.
Can anyone advise me why the Oracle driver might not work or have I just set it up incorrectly - and if so how does it see the tables in EM?
Slowly going mad here...
November 24, 2003 at 5:11 am
Hi,
Have you had any luck yet? Sometimes changing the query to openquery helps.
If it aint broke don't fix it!
Andy.
November 24, 2003 at 5:27 am
I did try openquery but the results were the same. Unless I have some major suggestions I think I have to give up.
November 24, 2003 at 6:31 am
Hi,
Can you describe the Oracle Table or send me the data types of the columns.
If it aint broke don't fix it!
Andy.
January 24, 2004 at 9:17 am
Did you solve your problem? Is so how? I'm having almost the same.
Thanks, John
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply