Recent content by Enya

No, it's not a security issue. I can use that ODBC connection in other workbooks. I don't get a sql server prompt because we use Win NT authentication to connect to our servers. Yes, the ODBC connection is set up in the admin tools/data sources.

Sounds like you have a corrupt file on your hands. Have you tried renaming it and then opening it? PS I assume you meant the PC in question is running with 512 MB of memory, not KB?

Hi, I have an Excel workbook that has several MS Queries that retrieve data from a Microsoft SQL server, via ODBC connection. We recently changed the server that my database resides on, so I updated my ODBC connection with the new server name. Fine, no problems there. Now when I try to...

My servlet reads the data (in bytes) from a file....I want to download this data onto the clients browser. How can I do this?? Code so far: ----------- File f = new File(FileName); try { FileInputStream fis = new FileInputStream(f); BufferedInputStream bis = new...

When I click on a link - it should open a new browser window. How can I do this?? Thanx for the help.

I have a url: http://localhost:8080/servlet/myfile.zip I want to rewrite it to get: http://localhost:8080/servlet?filename=myfile.zip I found some url rewriting articles over the web, but nothing clearly explains the process. Could anyone just give me a brief/clear explanation of the concept...

Thanx 'dustyfido'!! I have one more question - very similar to the above one. If I had a URL say: http://www.me.com/download/sw? How would I split the strings between '/ /'?? To get: www.me.com download sw I've been programming in ASP for a while and relatively very new to Java...

How can I split a URL (QueryString) obtained off a browser?? Could anyone please suggest solutions. Thanks in advance.

How would I 'display a message' like Retrieving data, please wait, on an ASP page before looping through a recordset. Thus giving the user some feedback on what is going on in the background, rather than looking at an empty page, till the entire looping finishes?? Thanks in advance.

I have set the content type for excel format. But somehow the https/http is making a big bad difference. The browser ends up listing all the data (comma separated) on itself, instead of excel worksheet.

The ASP page is supposed to download a .csv file (open Excel). But the file ends up being displayed on the browser (literally comma separated and all) - doesnt open excel and put the data in there.

In the first ASP page (https://......) I have a link, which when clicked, initiates download of a file. If the download file is (http://......) - I get a security alert. But if I use (https://.....) as the download file - the downloaded file is not in the correct format. Is there a workaround...

In the first ASP page (https://......) I have a link, which when clicked, initiates download of a file. If the download file is (http://......) - I get a security alert. But if I use (https://.....) as the download file - the downloaded file is not in the correct format. Is there a workaround...

Thanks for all the suggestions.

I have already generated an Excel file from an ASP page. But this file resides on the web server. I dont want this file to reside on the web server. Can anyone help me with any suggestions?? Thanks in advance.