Issue with Excel OLEDB Connector

[Former Member]

Hi

I have configured OLDE DB connector for Excel . The data server starts fine and no errors are available in the log files

But when I use a query data from xMII that queries excel dataserver, it throws the following exception in the log file

I compared the configuration file generated by UDS to another xMII server's configuration file that has similar Excel configuration and both look good.

Appreciate your help in fixing this error that is not letting us move with development

Thanks

Deepa

• Start of Exception Stack Trace **********

1) [04/03/2008-08:54:56.785] dsIPC_Pegylation [P:5216, T:4544, UDS, ERROR] 0x0 Error found. Unspecified error. Error was spawned by -- File:c:\perforce\xmii\lhds_oledb\dev\src\dataserver\BaseOleDbMode.h Line:346 Function:BaseOleDbMode<class COleDbQuery>::ProviderConnect. [BaseOleDbMode.h @ 413, BaseOleDbMode<class COleDbQuery>::CheckOleDbResult]

2) [04/03/2008-08:54:56.785] dsIPC_Pegylation [P:5216, T:4544, UDS, RETHROW] 0x0 Rethrowing exception. [BaseOleDbMode.h @ 417, BaseOleDbMode<class COleDbQuery>::CheckOleDbResult]

3) [04/03/2008-08:54:56.785] dsIPC_Pegylation [P:5216, T:4544, UDS, RETHROW] 0x0 Rethrowing exception. [BaseOleDbMode.h @ 367, BaseOleDbMode<class COleDbQuery>::ProviderConnect]

4) [04/03/2008-08:54:56.785] dsIPC_Pegylation [P:5216, T:4544, UDS, RETHROW] 0x0 Rethrowing exception. [Query.cpp @ 107, COleDbQuery::ExecuteOleDbMode]

5) [04/03/2008-08:54:56.785] dsIPC_Pegylation [P:5216, T:4544, UDS, RETHROW] 0x0 Rethrowing exception. [BaseOleDbMode.h @ 391, BaseOleDbMode<class COleDbQuery>::ExecuteMode]

6) [04/03/2008-08:54:56.785] dsIPC_Pegylation [P:5216, T:4544, UDS, RETHROW] 0x0 Rethrowing exception over COM. [LHDSUtil.h @ 1091, lhds::LHDSModeImpl<class COleDbQuery,struct ILHDSMode>::Execute]

7) [04/03/2008-08:54:56.785] dsIPC_Pegylation [P:5216, T:4544, UDS, RETHROW] 0x0 Rethrowing exception. [LHDSUtil.h @ 1129, lhds::LHDSModeImpl<class COleDbQuery,struct ILHDSMode>::Execute]

8) [04/03/2008-08:54:56.785] dsIPC_Pegylation [P:5216, T:4544, Framework, RETHROW] 0x0 Rethrowing exception over COM. [LHDSDispatcher.cpp @ 135, CLHDSDispatcher::CallMode]

9) [04/03/2008-08:54:56.785] dsIPC_Pegylation [P:5216, T:4544, UDS, RETHROW] 0x0 Rethrowing exception over COM. [LHDSUtil.h @ 897, lhds::LHDataServerImpl<class CLHOleDbDataServer>::Execute]

10) [04/03/2008-08:54:56.785] dsIPC_Pegylation [P:5216, T:4544, Framework, ] 0x0 Caught exception over a COM boundry. [LHDSChannelHandler.cpp @ 571, CLHDSChannelHandler::OnExecute]

11) [04/03/2008-08:54:56.785] dsIPC_Pegylation [P:5216, T:4544, Framework, RETHROW] 0x0 Rethrowing exception. [LHDSChannelHandler.cpp @ 579, CLHDSChannelHandler::OnExecute]

12) [04/03/2008-08:54:56.785] dsIPC_Pegylation [P:5216, T:4544, Framework, RETHROW] 0x0 Rethrowing exception. [LHDSChannelHandler.cpp @ 507, CLHDSChannelHandler::ExecuteIOCP]

13) [04/03/2008-08:54:56.785] dsIPC_Pegylation [P:5216, T:4544, Framework, RETHROW] 0x0 Rethrowing exception over COM. [LHDSChannelHandler.cpp @ 191, CLHDSChannelHandler::Execute]

14) [04/03/2008-08:54:56.785] dsIPC_Pegylation [P:5216, T:4544, Host, HANDLED] 0x0 Handled exception. [ThreadPool.cpp @ 430, ThreadPool::ThreadProc]

• End of Exception Trace **************

[Former Member]

The issue was with the Date prefix being used in datasource. It should be #