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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy