Search results for query: *

Denny, Thank you very much for your reply. I spoke to my ISP and they claim 1433 is open. I am not sure what else to do now. Regards, Satish

KB, While the ASP code will help to better understand, the best I can think of now is that there is a loop running where the HTML-BODY tags are within the loop and hence generating the whole page multiple times instead of just a table with multiple rows. Hope this helps. Regards, Satish

Hello All, My problem seems quite odd [ponder]. I have three internet connections. One is a DSL connection through a wireless router and another a PCMCIA data-card. The third one which is also a broadband connection with static IP direct (no router) to my laptop. Now I am able to connect to...

Yes. My webhost provides the Office Word Components v11 but I could not find any examples featuring word using them. If I can use that it would solve the problem. Thanks and Regards, Satish

Yes not a link to an external image which would show when the doc is opened. The image should be contained(as you rightly said) in the doc file. Regards, Satish

Hello Everybody, I have to create a word document where I need to add a user selected image and then present the doc for download. Till now only text was being added on-the-fly and it was quite a simple thing. But now am not sure how to add images? How can I do that with FSO? Any...

Hello I would like to include an Outlook Calendar in my application. Can anyone please suggest ways to going about it? Should I use Outlook Interop or the Outlook Add-in? Thanks and Regards Satish Kumar

Hello Catadmin Thanks for your reply. I am a little confused by a couple of your points. Could you please explain as my SQL Server knowledge is hazy at best: "Never host SQL Server on a Web machine if at all possible." We don't host our SQL Server. It is with a web-host and they have confirmed...

Hello Everybody This is my scenario; I have developed an ERP system that runs on ASP-SQL for a multi-location business. Now, we have taken a web-hosting plan and they host the IIS and the SQL Servers. However, while we have two locations(Live and Back-up) from where to access the ASP...

You are doing a Request.QueryString("ID") while your form is doing a POST. Try Request.Form("ID") or instead Request("ID"). Maybe what you see when you do a Response.Write is because the page prior to this passing the ID in the QueryString. Also you might want to rename "OrderNo" as "ID"...

Tarwn, thanks for those great suggestions. I am using disconnected recordsets and that brought down the processing time down a hell lot(Imagine I screwed up the code so much it was taking more than 3 mins to load!!). I will look at GetRows(). DNG, thanks for your suggestions. Yes I have not...

Thanks for your reply. Yes I figured out too that ASP might not be the best way to do it and that could in fact be the problem with the speed. I will look into the SQL script and see if I can do something from it. ~Satish

Hello Everybody I am creating a report(using ASP only) of products and their quantities. There are 1200-odd products to be displayed. As of now the report takes around 15-20 seconds to load. I also need to calculate the quantities on Customer Orders(ordered but not yet delivered). The SQL...

Thanks Boris. This has been greatly helpful. Not knowing what to do I finally was toying with the idea of creating two SP: one with ID as parameter and another without. But you have saved me so much time. Thanks again. ~Satish

Hello Everybody, Recently I moved an ASP-Access system to ASP-SQL2k5 database. I am also now using Stored Procedures. My problem is: I have a table called tblLocations with LocationID(PKey int) and LocationName(nvarchar(100)). Now when using a stored procedure I send a parameter LocationID to...

Tarwn I will post the queries shortly. But I am using the MoveFirst. Even then I get different resultset in ASP. The resultset is ASP is a subset of what I get in Access. Thanks and Regards Satish Kumar

Hello Everybody, I have a POS system developed in ASP with an Access database(the migration to MS-SQL on too). It has around 60 tables and 300 ASP pages. Now I have seen that a query when executed in ASP at times returns different number of records as opposed to when I run the query directly...

Maybe have the code on your page goes into an unending loop. It would be good if you can post the code. ~Satish

I really don't know but from I've been advised not to store images in the database. Store them in a folder and the name in the database.

OK then if the words are separated by a space, replace(like you are doing for the double quotes in your example) the spaces with %. So it you have "ASP Forums" use the replace function to make it "ASP%Forums". That should do it.