I was working on a site an I forgot to open up a connection to my database, but it connected anyway.For example here is the code to create the recordset I am using
connb4b = "DSN=b4b2005" 'i left out the uid and pwd of course for obvious security reasons
set myRecordSet = Server.CreateObject("ADODB.Recordset")
mySQL = "SELECT * FROM inn WHERE inn_code = '" & myInnCode & "'"
myRecordSet.Open mySQL, connB4B, 2, 3
Anyway, the above code created the recordset fine. Do you not have to open a connection to the database, but just pass it the connection string in the open command of the recordset?
I have a site on 1and1. The site has a simple login as well as other asp applications. This site uses an access DB. Last week all the scripts that accessed any database resulted in this error: Code:
I would like to connect to another server and execute my query from my asp page. But how can I initiate the connection string to another server DB? For example Code:
ConnString = "dsn=abc;uid=xyz;pwd=123"
What will be the way to issue the connection string to another server? Using SQL Server 2000.
Basically everytime I need a page to access a database I will create a connection object, and then at the end of the page I will close the connection object.
Would it be more sensible to create all the connections to the database that a user will need when they first visit the site, and then close these connections once they leave the site. (Using something to do with Start Session and End Session).
I have a web form that uploads a file to the server where the file is proccessed and outputs a report, the time lapse between uploading the file and the report being produced varys from a few seconds to a few minutes depending on the number of clients requesting reports.
My question is after the file has been uploaded is it possible to keep the connection open and inform the client when the report is ready for downloading.
I wanted to know wheather DSN is ok for the connection to a database or direct conection is better?
when i started my web project on dreamweaver i had to make a DSN connection as i have followed the books, but as now as i have also asked several questions on this site, i have aslo implemented a direct connection as well on some pages, now i am wondering is this going to have any affects when i uplode the complete site on the server.
i have noticed that on my computer when i am testing the site and uploading new records on sections that have DSN connections you can see the new record but on sections that i have implemented direct connection i cannot see it coz it is linked to the local directory database not on the testing server.
i have also never experienced uploading to a IIS server with DB connection so its my first time with dynamic websites. so am i in trouble or its ok the way i have done my site..
I devolop a webpage using ASP.NET. i want to redirect my page to certiain links stored in the database. the links can be either URL or Word documents sored in the server. here is my problem. when i redirect my page, if it is a document, it opens the MS.Word appilication.
instead, is there any possibility to open those documents in IE itself with out any confirmation ?
I have an application that generates PDF documents (from an ASP page). In some cases, I need to generate a PDF then provide a link to that PDF from the web page - this I can do fine. In other cases, I want to generate the PDF, but then immediately open the PDF in the browser; in this case, once I have generated the PDF, I am simply using 'Response.Write MyPDFPath' to open the document.
However, for some people this doesn't work, but for some it does. And I can't figure out why results are different. In both cases, the browser address changes to match the URL for the PDF document, but in some cases, all you can see is a blank screen. If you click on the Refresh/Reload button, the PDF displays perfectly - so it's not a show-stopper, but it is a bit of an inconvenience.
Has anyone got any ideas why this may be happening? Is there a better way of opening the PDF? I thought of streaming directly to the client, but that would present the user with an Open/Save/Cancel dialog, which although is more intuitive, it's hardly any easier than clicking on Refresh.
When I try to open an Excel file from ASP thro' HREF it works fine. But i give the same file in Response.Redirect it says "page cannot be displayed" even when the file exists. Is this related to server configuration?
I would like to open a new window (Function is called NewWindow and is writtent in VBscript) when a user submits a form. All the samples I found on the web indicate something like the following: Code:
how can i open a new window with a if statment but still getting variables values?
tit=Request("title") if x=1 then something else Response.Redirect("<A href="http://www.test.com/lookup?q="&tit">http://www.test.com/lookup?q="&tit") end if I donīt mind using java, but i donīt know how
I am working on a website and have a couple links that open up a new window. My webpage is .ASP as well as the windows I am opening. Currently the link open into a new window. However, I would like to be able to set the the size of the window that is opened. This is the code I am currently using:
I have problem i want created simple site This site should epitomize table about organizer free or busy room in month the rooms is 6 but people should mark
I have a Word doc already created that I want to open from an asp page. I want it to open in Word and allow the user to modify if necessary. I currently have it opening (using href), but it is opening in IE. I think I should be able to do it with javascript to open word and then call that function on the link to the doc. Can someone give me some pointers?
in the viewdoc.asp i need to check the file type and set the content type accordingly.also the viewdoc.asp must load in a new page and display the document passed. can anybody help me with a piece of code???
In our ASP page, we call XMLHttp to download XML files. When calling our page using localhost (localhost/myWebSite/myPage.htm), it works, but when calling using the IP address of the web server (xx.x.x.xxx/myWebSite/myPage.htm), I got "Permission denied" error in the HTTP.Open statement.
I am looking for an open source, very simple CMS that allows an administrator to add pages, news articles, and maybe a staff directory. We don't need new users to signup, or comment, or anything along those lines. Maybe a wysiwyg editor included. Just for a homepage, a news section (that may include many sub-cats, pages).
I have a website set up that can pull data from Access database tables and display them on the webpage depending on users' selection. Is it possible to have ASP open up Microsoft Excel and dump the data into it, plot graphs, calculate averages, etc.?
I have an .Net project that has an ASP page, that has links. When a user clicks on one of the hyperlinks, it opens an Excel page, in IE. One of the cells in the Excel Workbook contains a link to a PDF document.
If the user clicks on the PDF link, it's opened in the current page. I'd like to know if it's possible to open the PDF in a new page. So it would basically be opening a PDF from the Excel document - that is opened in IE. Code:
i want to open a dbf file in asp which is saved in a directory. The Path of the file is "F:mywebdb". The dbf file is saved in the above path and is called test.dbf. I write the following programm to retreive the records Code:
Is it possible to struture a link in a Web site so that when clicked it will open a particular file on a CD-ROM? I didn't create the CD-ROM and the files are AVI and DCR.
I try to open mht file generated by ASP use the Content-Type = "application/msword".
When the browser show de "dowload dialog" and I click in the Save button the file open perfectly, but if I try to click in the Open button, the browser show the "downloading dialog" and stay perpetual trying to open the file.My problem is, I cant save the file in the local machine, I need the Open only in memory.
I have searched the web and books but so far I am drawing a big fat nada on this one.
I want to open a new window from an ASP page and everything I have found suggests to use JavaScript and not the server side VBScript. The problem is that the server side is what will decide were to send the user. Is there a way to exit or open a new window using JavaScript passing in variables fromVBScript server side then close the ASP page?