March 23, 2009 at 1:19 pm
Here's one of the error messages we get when we select ANY field within certain tables on the Linked Server:
Msg 7356, Level 16, State 1, Line 1
The OLE DB provider "Ifxoledbc" for linked server "PROD_UAT" supplied inconsistent metadata for a column. The column "t_ae_dear" (compile-time ordinal 6) of object ""prod_data":"facre"."acctexec"" was reported to have a "LENGTH" of 266 at compile time and 10 at run time.
Some tables we don't get this error, and others we do. It just appears to be certain tables, but I'm not sure how many are affected. I'm wondering if there's some simple solution to make SQL Server not care about anything but run-time, or if perhaps we need to create views or stored procedures on the Informix side?
Any/all assistance appreciated.
Steve
(aka smunson)
:-):-):-)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 24, 2009 at 6:07 am
UPDATE:
We found that we stop getting the error above and instead get an error relating to date string format that is being a real pain. It doesn't like the format of the date string we supplied to the Informix TO_DATE() function. Anyone have any ideas on workarounds or other methods?
Steve
(aka smunson)
:-):-):-)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply