Skip to Content
Former Member
Nov 15, 2013 at 09:20 PM

How i can Change my report's connection to ODBC.


Hi There,

I have so many reports was created in CR 2011 using OLE Database connection and now i am responsible to modify all these reports based on the new requirements, requirements are very simple, i am done with changes, But my Problem is the Old Connection was on OLE and now i want to change it to ODBC, i created the ODBC connection with the same Database and Data source and i am trying to change the Connection from Report Level using Set Data Source Location...

But as soon as i click on Update Button after choose the ODBC Connection at the bottom , i am getting Data Object cannot be Opned/Accessed, after i clicked on OK on the Error Message, it pops up one more message Unknown Database Connection Error...

Please some one let me know How can i Change my report's Data source Connection to OLE DB to ODBC.