Excel Problem again

[Robin Lee <te...@uls.com>]

There doesn't seem to be a lot of requests about this problem that I am
having with Tomcat.  (I've already sent this out once, but received no
response...)

I am running tomcat 4, with jdk1.31_01.

I have an Excel file (called ULSExcel in the odbc source) as a default file.
I was able to change it so that when i copy the default file to a new file
name (LoginID.xls), i can change the file it refers to in the ULSExcel to
the new file (ULSExcel;dbq=LoginID.xls).  This has worked previously with
tomcat 323 as well as JWS.  This is the error I get.

Here's the set of the data source name:
"ULSExcel;dbq=" + excelFile + ";DriverID=22;READONLY=false"

Here's another variation i tried...
"{Microsoft Excel Driver (*.xls)};dbq=" + excelFile +
";DriverID=22;READONLY=false"
And here's the error I get in both cases.

[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified

If I just use "ULSExcel" as my data source name, I get no problems
whatsoever.  It saves it to the default file.  Which is not what I wish to
do.

Considering the fact that this DID work prior to tomcat 4, does anyone have
any idea why this happened, or if there is another way to try and get this
to work?

Thanks to anyone who can help me out.

...Robin Lee
tech_support@uls.com

Re: Excel Problem again

[Robin Lee <te...@uls.com>]

I'm going to send this again in hopes someone will know what to do in this
respect.

Thanks to anyone who CAN help.

...Robin
----- Original Message -----
From: "Robin Lee" <te...@uls.com>
To: <to...@jakarta.apache.org>
Sent: Friday, October 12, 2001 2:24 PM
Subject: Excel Problem again


> There doesn't seem to be a lot of requests about this problem that I am
> having with Tomcat.  (I've already sent this out once, but received no
> response...)
>
> I am running tomcat 4, with jdk1.31_01.
>
> I have an Excel file (called ULSExcel in the odbc source) as a default
file.
> I was able to change it so that when i copy the default file to a new file
> name (LoginID.xls), i can change the file it refers to in the ULSExcel to
> the new file (ULSExcel;dbq=LoginID.xls).  This has worked previously with
> tomcat 323 as well as JWS.  This is the error I get.
>
> Here's the set of the data source name:
> "ULSExcel;dbq=" + excelFile + ";DriverID=22;READONLY=false"
>
> Here's another variation i tried...
> "{Microsoft Excel Driver (*.xls)};dbq=" + excelFile +
> ";DriverID=22;READONLY=false"
> And here's the error I get in both cases.
>
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
>
> If I just use "ULSExcel" as my data source name, I get no problems
> whatsoever.  It saves it to the default file.  Which is not what I wish to
> do.
>
> Considering the fact that this DID work prior to tomcat 4, does anyone
have
> any idea why this happened, or if there is another way to try and get this
> to work?
>
> Thanks to anyone who can help me out.
>
> ...Robin Lee
> tech_support@uls.com