Hi,
Some strange behaviour within OLE DB....
I'm using a reporting tool and within this tool we have a metadata model defined. The model uses a OLE DB connection to a SQLsrv2005 env.
Refreshing of the metrics defined an error occurs ('object was open'). However when changing the connection into ODBC all is just fine (after deletion of all the metrics and the re-importing them). Some of the metrics could be refreshed using OLE DB and some not and vice versa....
could it be a conflicting MDAC version (2.82) or setting up rights for ODBC (read and write)?
Is something on the server not installed properly (or installed at all)
some research ended up with the error code -2147217915 (0x80040e05) this didn't make any sense and i felt more and more lost.... :confused:
I do not have any access to Ispy for tracing the OLE DB...
any help is much appreciated
thanks
E10
Some strange behaviour within OLE DB....
I'm using a reporting tool and within this tool we have a metadata model defined. The model uses a OLE DB connection to a SQLsrv2005 env.
Refreshing of the metrics defined an error occurs ('object was open'). However when changing the connection into ODBC all is just fine (after deletion of all the metrics and the re-importing them). Some of the metrics could be refreshed using OLE DB and some not and vice versa....
could it be a conflicting MDAC version (2.82) or setting up rights for ODBC (read and write)?
Is something on the server not installed properly (or installed at all)
some research ended up with the error code -2147217915 (0x80040e05) this didn't make any sense and i felt more and more lost.... :confused:
I do not have any access to Ispy for tracing the OLE DB...
any help is much appreciated
thanks
E10