(incidentally, the more i look at it, the more i feel i should point out that to be totally sure your SQL statement is correct you should write it like:
INSERT INTO table_name (column1, column2,...)
VALUES (value1, value2,....)
so that you know your info is going to the right column on the table
I am trying to open a DB connection in an ASP file (with an HTML interface). I have some idea how to do it, but I am not quite sure. It is linking to an Access DB. It is very simple, I am posting some data to the DB. Only one connection is needed to open.
View Replies View Relatedi have the following error
Microsoft VBScript runtime error '800a01be'
Object doesn't support named arguments: 'ConString'
/asyama/productsBySpecial.asp, line 165
from the following code:
I created connection to the Microsoft Access DB using DSN from my ASP page.
<%
Set vpconn = Server.CreateObject("ADODB.Connection")
vpconn.ConnectionString =
"File Name=c:inetpubwwwrootDBDNAME.dsn"
vpconn.Open
' Close connection immediately after opening for testing
vpconn.Close
Set vpconn=Nothing
%>
The Microsoft Access, for every database opened for shared use, creates an .ldb file to prevent users from writing data to pages that other users have locked. Whenever the last user closes a shared database, the .ldb file should be deleted.
It is working; the .ldb file is deleted immediately after closing connection
but not if you open/close this connection from your ASP page.
What I found, the .ldb file is deleted with about 70 seconds delays after closing connection from an ASP page.
I have my code like this one.asp
<td><a href="callexp.asp?id=<%=rs("ID")%>" target="blank">View</a></td>
so now i call a diff page called callexp.asp ok
so it opens up a new page i want to set properties of the page like we do for pop up window.like i want the new page to be of a specific size with no scroll bars and stuff i have the code for opening a pop up window in javascript
in my database customer name is mike o'lee, i am creating one reason forum by using asp script and call customer name from database by using link syntax. when i trying to open the reason forum it displaying the error message like page is not found.
The problem is in single quotation which is present in customer name.I now how to remove the single quotation ,but use want to see the same customer name. how i can open the page,by using same page.
I have a drop down on a page where user selects a value and then a excel file opens up
it works good in mozilla but in IE it doesnt open up the excel file i see a new page been open but then suddenly it closes the file
i have checked the popus in IE and i dont know what the problem is
Here is the code Code:
<%
Response.ContentType ="application/vnd.ms-excel"
getid=Trim(Request.querystring("id"))
Response.write getid
%>
I see the output written when i use mozilla but it just doesnt work in IE.
From a LINK or BUTTON on a webpage can we invoke the usual OPEN FILE dialog box that come with all the windows application .
In my Application I want to ASK the user the Name of a FILE on the disk ... currently i am asking the user to input the COMPLETE PATH in a TEXTBOX ....
I need to incorporate some emails that are in a csv file, all sorted in one column, into a mySQL database.I dont find the way to open the CSV file in ADO
View Replies View RelatedI have a configuration.txt file and would like to open that file in a browser for editing onclick of a button or hyperlink!! It is more than enough for me, if i just open the file as it is in a notepad itself, by clicking a link from the ASP code.
View Replies View RelatedI'm on a project for a government application. For a given domain object, there is a report that is pre-generated, converted to PDF, and stored in the database.
The client wants to have a list of these domain objects, each one with a print icon at the end (which is already done).
The problem is when they click on the print icon, a postback is acceptable, but basically they want to hit the database, download the PDF, stream it to the browser, and print it, all without any pop-ups.
In short, other than the blink of a page for a post-back, they want Win App functionality of clicking print, and a PDF printing without any other interaction (downloading the PDF, file-> print, etc).
Since its a PDF, I know this isn't possible with Javascript. I have no experience with ActiveX whatsoever, so I was hoping for advice on whether this was completely impossible, and the level of effort involved.
I think its impossible, but I want to at least say I've done my homework before I tell the consultant that who thinks it can be done.
I just made a simple web site using Frontpage 2003 with a simple MS Accesss
database.
IF I try to open the asp page in a browser by typing
http://localhost/mysite/db.asp it opens just fine
However if I try to opeb it by typing c:/mysite/db.asp I get the following
error message:
The Database Results component on this page is unable to display database
content. The page must have a filename ending in '.asp', and the web must be
hosted on a server that supports Active Server Pages.
I have a field in the table that saves pdf file paths:
there are 2 records like this:
/docs/one.pdf
/docs/one&two.pdf
what i do is display the paths on the page and when people click on it the file is opened
this is how i display the paths
<a href="<%=RS("Path")%>"><%=titlename %></a>
the first file one.pdf opens up
the second file one&two.pdf doesnt open up
if i change the name of the path in the table to
/docs/onetwo.pdf it works
so i found out the & is causing the problems
can someone tell me how to fix it.
I want to create a asp page where i can give the user an option of downloading a file or opening a file e.g an excel file.
How do i do this?? Ive already created an asp page which has a button- where the user can click on the button. The excel option of either opening the file or downloading it comes up- but i want this option actually on a asp page. How do I go about this?
I want to open a text file for appending purpose but it gives me the following error..
Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument
/cgi-bin/Anagram_Utils/welcome_letter/generatedoc.asp, line 19
Code: ......
I have a server with a Word document and an Access database on it. I
also have an ASP page running on the server. The Word document
contains a mail merge with the Access database. What I want to do is
open the merged Word document from the ASP page when a button is
clicked.
I have tried several things including some scripting that I
found on the internet. This scripting works, however it opens the
merged document on the server instead of on the user's local machine.
I want the Word document to open on the local machine instead.
I have one combo box and GO button on the click of GO button page
submitted and according to selection of one of the option from combo I
want to redirect my page to some new asp page but at the same time in
new window of browser.
I could have achieved this using window.open() of javascript but then
it will serve as pop up and clients requirement is that not to show as
popup window due to many users blocked popups.
Any suggestions, How can I achieve this using response.redirect or any
coding which is not serve as popup window.
I have a form that assigns to 2 variables. Now I want to have a button that if clicked sends a different asp page the 2 variables and runs the page. I think I need the new asp page to open in its own window as I want the original form to stay open in the background and the new form generates an Excel file to download rather than opening in the browser.
Could I get an example, preferably in vbscript, of how to do this please? The only sample code I've found so far uses a hyperlink instead of a button and doesn't pass any arguements to the new page.
I want to open word file in explorer. I am using hyperlink for this purpose but it doesnt show me the file opened. Though i able to do save as on it.
View Replies View RelatedI have created one dynamic chart creation application using vb dll. If I call this function from vb it is working fine. But If i call this function from ASP i got error while opening the excel file line. I have windows 2000 server. Do i need to give any permission for this? The same coding is working fine in NT server.
View Replies View RelatedI have a page in in ASP which lists static links to PDF files. When
users click on the links, they receive the following message:
right-clicking on the link and selecting "save target as" generates
the following error message from IE7:
"The file could not be written to the cache"
Clicking the link, and selecting "save" from the resultant dialog
generates:
"Internet Explorer was not able to open this Internet site. The
requested site is either unavailable or cannot be found please try
again later"
This page works fine in Mozilla.
I've researched this a bit and have read about the caching issues,
although none of the pages on the site address cache control. Any
thoughts or ideas as to why this isn't working?
I have a document saved to a public network server. The public directory grants change access to all users on the network. To keep my Word doc protected I am using the Security feature "File Sharing Options" in Word to attach a password to the document. This works as expected when users open the file with Windows Explorer.
I also have an ASP web page that has a link to my file on the public drive. When I click this link, the Word document loads without asking me for a password and is not read-only. (Note the link in formatted with an href attribute like this: file://servername/share/filename.doc)
Am I mssing something? Shouldn't the Word security work even if the file is accessed through a hyperlink?
There's an access database on an iisserver and asp makes updates to it. The
database got moved to a newer server. The users used to be able to open the
database and use the asp pages at the same time. Now when the database is
open the asp pages won't update.
I'm working on a document management app that saves scanned docs as PDF files in a local directory, then saves document metadata in an Internet-based SQL server.
The SQL server is then queried to retrieve document info and links are created that point to the files.
The code points to the proper local directory and file, but I can't get the browser to open the document in a target frame. If I open a test doc locally it works fine.
My newly rented 2003 Standard Edition dedicated server allows me to access HTML or picture files but asks for username and password when I try and open an a asp page.
I have set Authenticated User permissions to Read & Execute and Directory properties to Scripts & Executables. What have I missed?
I have a script that opens a file and writes to it using ASP. I've used the script before and it worked fine locally, until recently, after I upgraded my computer to Windows XP Pro SP2. Also, it still works fine when I upload the script to my web host. However, locally on my computer using IIS, I get the error:
Error Type:
Microsoft VBScript runtime (0x800A0046)
Permission denied
This occurs on the line: Set FileTS = FileFSO.OpenTextFile(Server.MapPath(".") & "" & FileName,2,TRUE)
I've searched online for answers and most articles say I have to set read and write access to the containing folder. I have done so for the containing folder and for the entire "wwwroot" folder, but the problem still occurs. I have also allowed anonymous access for my computer IUSR_XXXXX. This doesn't work either.
I have an asp.net page that I would like to open up another asp.net page within the first one. Like a parent - child relationship. I need to display a graph in the child on the parent.
View Replies View Relatedis it possible to open an excel file (used as a template) from server using server-side vbscript; then modify it or add values from client using client-side vbscript?
View Replies View RelatedI am trying to do more than 1 connection in the same file and i am getting some errors...
With 1 connection it works flawless... but when i try to add another i got a error point to "data_sourcea".
Can someone show me some tip (best pratice) on how to do this?
Code following:
<%
Dim rs, data_source, no
no = 0
data_source = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
Server.MapPath("..
I'm using an ASP page to display all our office printers, I want the users to have to possibility to install the network printer with just one click on the page. Is this possible. ?? PS all information is retrieved from SQLServer.
View Replies View RelatedUsing MSDE database & ASP file through IIS, both are in separate systems. Database is not connecting from IIS-ASP file.
Given error as "[DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found", Using Provider=SQLOLEDB.1 But VB code is connecting using same provider
I have actually an asp web site which use the global.asa file to connect to
the database but for security reason, I want to put username and password
information (or the complete connection string) in a seperate file so only a
special user could read these informations.
I use the ASP page to test whether the connection of SQL Server is fine. I use windows authentication. I get fail when I attempt to use hostname of the destination server. Contrary, I get success when I attempt to use IP address of the destination server. Does anyone know how to fix this issue?
View Replies View Related