July 11, 2012 at 8:21 am
I get a warning as soon as I add an Oracle OLE DB Connection.
Cannot retrieve the column code page info from the OLE DB Provider If the component supports the "DefaultCodePage" property
Warning at {7A689B65-AC**-4BC2-93AA-12FADCF1E696} [OLE DB Source [45]]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.
Does anyone know what this is about?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 12, 2012 at 8:57 am
I realize what the warning is about.
It is the default code page property for the OLE DB Source which is Oracle which is set to 1252.
There is another property "AlwaysUseDefaultPageCode".
You change the value from False to True and you no longer get a warning.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 12, 2012 at 9:06 am
I had that warning the other day but didn't get round to investigating..
Thanks for posting the solution 🙂
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply