Hi! I'm creating a VB application using SQL Server. And in our SQL server, we have a linked Oracle Server. Now I'm trying to open records in that linked server (I'm opening a VIEW to be specific). And when I use SQL Server's Query Analyzer to open the table and see the records, I get this error:
Server: Msg 7356, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column. Metadata information was changed at execution time.
OLE DB error trace [Non-interface error: Column 'ORDER_NO' (compile-time ordinal 1) of object '"LIPROD"."ALL_WORK_STEPS"' was reported to have a DBTYPE of 131 at compile time and 130 at run time].
Now I thought that maybe it's just in the Query Analyzer that this pops up so I tried testing in my VB app. and I get the same run-time error. But when I tried creating a sample DB using Access and linked that table, I can open it up. I do understand what this error is trying to say but I don't know how to work around it 'coz I honestly am not well versed in SQL Server for that matter. Can someone please explain to me what's happening and is there any way for me to work around this problem?