Read/Write Connection Gone AWOL
I was working on my site yesterday -builiding on laptop -and was able to add/edit data to my database fine.
Today i get "Operation must use an updateable query."
I've checked the lit. and it seems the most likely explanation is that the folder or the DB has read only permission set.
So i checked out this in IIS and it seems everything is OK - i enclose pics of the setup -
I can't see what else is causing this.
I made a cut down page just to test the query and the same problem is occuring. I even rebuilt the database - access - just in case it was a corruption of some kind but nothing seems to work. I can retrieve data no problem just can't write or edit.
I've enclosed the code that i have used as a test just in case i'm missing something. Code:
View Replies
ADVERTISEMENT
Alright im tryin 2 write 2 a text file and then read from tat text file on the same page is this possible this is what i got so far. Code:
View Replies
View Related
How can I use ASP to both read and write to a TXT file?
View Replies
View Related
I need to do something very basic in asp. What I want to do is have one page that has a text box, and a button... the user can type whatever in the text box, and click submit, and it will create a txt file. Every time the button is pushed it overwites the file...
Then on a seperate page, whenever the page is loaded, it reads from the file and posts it on the page..I think this is very basic, but I'm very new.... I need to write it in standard ASP. One other thing that would be helpful is to have a limit on the amount that the text box will hold.
View Replies
View Related
I've just re-installed my PC with IIS (WinXP w/ service pack2) and now when I try to access or write data to any .asp site locally I get this error.
'Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.
View Replies
View Related
im making a proj. that would read ini or txt files.. and would display the content of that file in a combo box..
ex.
aaa
bbb
ccc
im currently using this "<!--#include virtual="//path/filename.ini"-->" but the problem is, it would display all the text on that file..
is it possible to retrieve the content and display it in a combo box per line?
ex.
line 1 : aaa = list.index(0)
line 2 : bbb = list.index(1)
line 3 : ccc = list.index(2)
View Replies
View Related
I have a csv file that has 2 columns - Name and Team. I want to display both of these on a page in seperate dropdown boxes..Ideally I would then like to have an option where the user of the page can click a button to change which team an employee is a part off, in effect overwriting that line of data but not deleting everything else in the file
The code below lets me see each column from the csv file on a page in a separate dropdown box but I don't think I have the logic right to do what I need..I've checked Google and w3schools but I must not be searching for the correct thing as I can't find a way to do this... Code:
View Replies
View Related
Im writing a web interface for a CRM product which has the ability to store files within a database... Now, the problem is, these files are binary files, and VBScript doesn't have support for binary files (as far as i know...)...
To overcome this i wrote a component (ActiveX DLL) in VB6. This component works fine, but as soon as i use it in ASP, my computer beeps and then sits there looking like it's doing something forever...
View Replies
View Related
I've got to learn how to read/write dBase IV files fast. Please provide a good quick start / tutorial and / or some good links here.
View Replies
View Related
I am working on a safetywear deduction system and i need to perform the following functions: write to a text file and read from a test file and wrute to a table in the database. I need code to write and read to a text file in asp please.
View Replies
View Related
I'm converting a VB6/SQL Server application to a web application. I need to
read data to and from Excel and Word. I'm not allowed to install Excel and
Word on the server, only on the client. Is there a way to use client side
scripts to read from and write to Excel/Word files?
View Replies
View Related
how can i read the datas in specific columns and rows from excel(.csv) file and then use that datas to calculate the min(example) and write the results into the same excel(.csv) file.
View Replies
View Related
i need to set read/write persmissions on an Access DB, can access IIS folder permissions -> not alleviating issues can't access explorer security -> why is this? ad infinitum require UPDATE operation on access DB, this erroring out with : Operation must use an updateable query.
View Replies
View Related
How can I use ASP to read data in an Excel file and than write it in the format of XML?
View Replies
View Related
I need to read a SQL Server table into a Web Page and within the Web
Page to permit my users to make changes to the records, delete or add
new records and then save the entire contents back to the SQL Server
table back.
The functionality I am looking is almost the same as In the SQL
Enterprise Manager whereby I can choose a table open the table and
then return all rows and I can maintain the same and save it back to
the SQL Server table. I want almost a similar web interface to such a
functionality.
Even if not a generic functionality as the SQL Enterprise Manager
table maintenance appreciate if somebody can share the code with a
sample how I can do it in ASP pages + T-SQL if need be.
View Replies
View Related
1.
conn.ConnectionTimeout = 60
conn.Open connString
2.
conn.Open connString
conn.ConnectionTimeout = 60
Do both of them give different?
View Replies
View Related
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..
View Replies
View Related
I,ve uploaded an MS Access DB to a web host and find that although I have set the DB permissions to Read and Write the actual tranfer changes these permissions and when I try to write to the DB there is an error to the effect that the DB is read only.
I have downloaded the DB I uploaded with full read/write permissions and find that the DB is read only.
View Replies
View Related
Is it possible to use asp to read from a .tsv file?? If so how do you create the connection??
View Replies
View Related
Is it possible to read PDF File using ASP.
View Replies
View Related
when I retrieve data from the my database if I got the name and description. I want only display the first 20/30 letters of the description but I don't know how to do.
View Replies
View Related
I have an ASP web site that I can read an XML file and process it fine. However, now I am asked to read XML data via (I think) a web service url. I looked at the ADO Stream and it looks like it may be a way to do this, but I'm not sure. I need to read 2 different streams, one with data and one with returned images.
I need to process the data like a recordset and load it (and other) information into a web page and return to the browser. Can anyone point me in a direction to read more about how to do this and/or some samples?
View Replies
View Related
I need to use ASP to read a SQL db for dates. If the date falls within "this (current) month", I need to auto-populate a word document with the corresponding information from the tables... Is this possible.
View Replies
View Related
Is there a way that I can read the current url.
I have an asp page currently such as default.asp?x=1&y=2&z=3
Now I want to keep the existing parameters and attach another parameter
to it and resend to default.asp
As the original parameters are dynamic, and may or may not be
generated, the only way is to read the current url and to simply add my
new parameter such as h=5 to the url.
I don't know how to read the current url.
I tried Request.ServerVariables("SCRIPT_NAME") but that didn't include
the parameters. i.e. it just returned the default.asp
View Replies
View Related
Is there a way to read email messages with ASP without installing components?
And will it work with any email server, or just windows IIS?
Something that will work almost like Webmail. But I just need to read the From, Subject and Body of the email.
View Replies
View Related
I got a database with user and email in it. Now I want when a user logs into my page that it automaticly fills in the email into a email form. How can I do that in Asp.
View Replies
View Related
anyone here got an idea on what codes am i going to use? I got a folder full of images (jpg) and I want my asp page to display those images.
View Replies
View Related
why do I get this error?? Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
/asp/formHandler2.asp, line 68
here's my code:
View Replies
View Related
I am wanting to use ASP to read the IIS log files on our web server. Can anyone help?
View Replies
View Related
how to modify this script to make the connection to the MS Access database read only, so that writing to the database directory is no more necessary (currently, I have to give IUSR write permissions so that the .LDB file can be created... but I don't need that because I want the database to be read only, and I don't want to grant write permission to IUSR).Code:
----
cst = "Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source=" & Server.MapPath("/database/riviste.mdb")
set conn = CreateObject("ADODB.Connection")
conn.Mode = 1
conn.open cst
strSQL="SELECT * FROM riviste ORDER BY Titolo"
set rs=conn.execute(strSQL)
----
View Replies
View Related
i am trying to read a nodes ( i dont know if i am right by
calling it node. see sample) value with asp.
xml page is very simple :
<?xml version="1.0" ?<response success="true" </response>
my code is this
Set xmlhttp = CreateObject("Microsoft.XMLHTTP")
xmlhttp.Open "GET",
"http://xml.my.net/tokencheck.asp?t="&token&"&u="&userid&"", False
xmlhttp.send()
Set xmlhttp=Nothing
how can i add xmldom and parse the result page so i can assign response's
value to a variable?
View Replies
View Related
I am using file system object to read an xls file in the webserver ,
the file is located in the webserver I: ( which is map drive of the webserver ) , when i have tested the script in my local pc , where i kept the file in D: ( local drive in my pc ) it wokred fine , but when i tried in webserver it says path not found ( the web server is Windwos NT based )
this is the path which i am using in a script
"I:" & "" & 123456 & "my folder"
what i found that if i use only I:123456 it is able to reach to that folder , but after that its unable but if i rename "my folder" to "myfolder" it reaches that means not able to read the spaces in folder name
View Replies
View Related
I want to read and write key'ed cookies from both javascript and ASP.
I can't find any javascript that reads and writes cookies with keys,
so that it is compatible with ASP like the following:
<%
Response.Cookies("user")("firstname")="John"
Response.Cookies("user")("lastname")="Smith"
Response.Cookies("user")("country")="Norway"
Response.Cookies("user")("age")="25"
%>
If anyone has the javascript code that can read and write such ASP
keys,
View Replies
View Related
