Error while Connecting to Excel Sheet & MS Access DB in WebDynpro

[Former Member]

Hi All:

I've TWO issues to be clear as soon as possible. I've 2 databases, 1 is Excel File & 2 is Access DB(mdb) File.

I'm using JdbcOdbc driver to connect these two files:

For Excel: "jdbc:odbc:Driver={Microsoft Excel Driver {*.xls}};DBQ=filename&path";

Select Qry: "Select * from [Sheet1$]"

For Access:"jdbc:odbc:TestDB", where TestDB is System DSN using 'Data Sources (ODBC)'

These 2 works fine when i run them in a Standalone Java Class.

But when i run the SAME code in WebDynpro the following errors i'm getting:

For Excel: The Microsoft Jet Database Engine could not find the object 'Sheet1$'. Make sure the object exist that you spell its name and the path name correctly.

I've used tested with diff options, but always get the same error.

For Access: Data source name not found and default no driver specified.

What could be the problem with WebDynpro??

Do we need to configure anything else to use the DSN or Driver in the above said manner?? I've searched a lot in net, could not found the solution. I wud appreciate if any one solves the problem?

Thanks in advance,

Munna SAP

[Former Member]

I've fixed the problem for the above query. It was fixed by creating the same DNS in my WAS Server machine(remote).

~ Munna SAP

[Former Member]

Hi All:

I've fixed the problem for the above query. It was fixed by creating the same DNS in my WAS Server machine(remote).

Cheers,

Munna SAP