OLEDB conn mgr change is not detected in BIDS/vs.net

I have changed the database name in an ole db connection manager. (The server name is identical)

When I run the package, it is still using the old db name.

I have tried restarting VS but it makes no difference.

How can I get it to stop caching the original name/update it to get the new name?restarting did fix the issue, but still it is ridiculous that you should have to take such an action

OLE DB for ODBC connections in BIDS/AS project

Hi,

I try to configure a new data source in my Analysis Services Project in BIDS and I would like to test the OLE DB for ODBC Provider, but I cannot find it, although it is definitely installed on the box.

Is this kind of connection not allowed or not supported for AS?

Norbert

I'm pretty certain that it's not supported for AS2005.

Sorry,

Chris

|||

Indeed the OLEDB for ODBC provider is not supported by Analysis Services 2005.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.