- I am unable to preview data when using OLEDB Provider with oracle DB TNS name. oracle 12c 64 bit client and VS 2022(recently updated to version 17.8.6)
when i execute task it can fetch records, but preview data doesn’t work, I didn’t change any values for property “DefaultCodePage”
your text
Oracle Connection Manager
Preview failes
Same component can fetch data when i Execute it, i don’t see error but i have warning without any error
warnings from previous execution
- OLE DB Command task doesn’t show available parameters from Update script so that i can map input values to update parameters.
when i refresh component after adding update script
Available parameters from update script are not showing up and unable to map parameters
I have updated VS 2022 and reinstalled SSDT for vs 2022, then installed VS 2017 and SSDT to see if it works in other visual studio version but error is same in both visual studios. I am stuck unbale to make progress with OLDB component with oracle DB.
please let me know if i am missing anything.
kboard 56 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.