I have a database that was originally in Excel. After modifying it, I have saved it with .txt and another one with .csv format. DB.txt (Text (Tabl delimited)(*.txt)
DB.csv (Text Comma Separated Value) (*.csv). What is the command/statement in oppening database record for these formats?
I had made a form name 'dform.html' which asks idno, name and phone from the user and after the user clicks on button "save data" sdata.asp is executed. sdata.asp is written to save the values entered for idno,name and phone in dform.html into table "myfriends" in the mydata.mdb (access database). but when i am clicking on save data button i am getting error saying
"Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/SDATA.ASP, line 9"
can please anyone tell me why i am getting this error.
Error Type:
Microsoft JET Database Engine (0x80040E21)
Cannot update. Database or object is read-only.
/q_maker/aero_admin/delete.asp, line 12
what is wrong! i checked the db and its not readonly.
I'm write an asp to include part of a text file into my asp output html, I use FileSystemObject to get the content of the text file, but the asp just hang when it runs, the source code is listed below if anyone could help: Code:
I want to read textfiles with ASP. But I want to do this in a special way.
I want to set a variable, for each line.
So for example:
Dim line1, line2, line3, line4, line5
line1 = Line 1 of the text file
line2 = Line 2 of the text file
line3 = Line 3 of the text file
line4 = Line 4 of the text file
line5 = Line 5 of the text file
How do I have to do this? .....
Is there anyway I can read a text document (Notepad) with ASP? I have a small database of emails in a text document, which I want to use for a newsletter. By using ASPMail I can make this an easy task for me to do weekly.
View Replies View RelatedCan I use FileSystemObjects to Read Text Files on my server rather than just on my local drive?
View Replies View RelatedI tried to read a text file from my local com, but it keep on loading and loading, after tat, i'll need to restart my IIS... im sure tat the directory of the txt file is correct... The code is running very well in another com, is there any kind of permission/ something i missed?
View Replies View RelatedI would like to allow my customers to upload their log files so that I can analyze them. Using ASP, I've found ways to:
1) upload files using the standard form elements and save it to my server using:
Code:
<input type= file>
2) from the file on my server, i can parse the text file and return results to the user
However, I would prefer not saving hundreds of random text files on my server. Is there a way that I can see the contents of the uploaded text file using ASP without saving it to the server? Is there something using the filesystemobject that allows me to do this?
Anyone know the best way of Read tab delimited text file, its old but I have to use it, I only know how to read csv.
View Replies View RelatedI am trying to create an ASP page that processes a large block of text that is posted to the page. The data block is approximately 500K. The only was I can figure to get the posted text into a string is using BinaryToString. Is there another way to just get the body of text that is posted?
View Replies View RelatedI 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 RelatedI'm using the ASPEmail component to send HTML email newsletters:
Mail.Host = "mail.myserver.co.uk"
Mail.From = strFrom
Mail.FromName = strFromName
Mail.AddAddress strTo, strName_In
Mail.Subject = strSubject
Mail.Body = strMessage
Mail.AltBody = "PLAIN TEXT VERSION"
Mail.isHTML = True
Mail.SendToQueue
The emails are coming through fine, though in Outlook the option to 'View as Plain Text' is greyed-out. This should let the user see the plain text version as defined in the code above, but it is inactive.
I have a log file from my email software program. Each entry is on a line and the values are seperated by tabs. How can I read through this text file such that I insert its contents into a database? Thanks. Tom
Here is one entry from that file:
11/30/06 00:00:21SMTP-IN25AA24076F2041D7B35E97EE7748D06C.MAI65284.244.91.208EHLOEHLO [84.244.91.208]250-home [84.244.91.208], this server offers 4 extensions11922
i recently just uploaded an access database only to find that it has read only persmission, so any adding, updating, deleting etc.. doesn't work anymore. the file became read only when i uploaded it. How do i change the read/write access to this file online?
View Replies View RelatedIm just not sure how to go about it because im new to asp. I want to write an ASP script that will read a money amount from an SQL database and when money is taken through a payment it will change the value in the database.
View Replies View Relatedi was getting error as follow while inserting record in database using objrs.AddNewstatement.
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
i have setup a virtual directory. i tried the steps u suggested in both WWWroot folder and my Virtual directory .still i m getting the same error.
I need to be able to find a record by a unique code from a ms access database,take the value of the price field in that record,then store the value in a JavaScript variable.
These variables are being used for calculations.
So can I change the hard coded JavaScript code
e.g.
var price1=(229); // 229 being $229 the price for item1
to
var price1=(item1); // item1 = 229 - value read from database and stored in variable price1.
I want to Open a database with asp, I know the syntax to do with VB but how do I make the refference of the DAO in ASP?
View Replies View RelatedActually, I do not know why i can not add records to my access database table by using asp code, I get an error that tells me that the database file or object is read only file even though the file is not readable only from its proprties, I need some helpful information to solve this problem.
View Replies View Relatedhow to connect to a mdb database and read from it. But how can i make a simple textarea that takes inout and writes it.
all i want is a textarea with submit so i can write to my database only with a couple of words i dont have any code so fare apart from read the data and connect.
Trying to update 2 fields. my database is read only..
Microsoft JET Database Engine error '80040e09'
Cannot update. Database or object is read-only.
/sendd.asp, line 16
this is line 16: rsAddComments.AddNew
is this something to do with my server directory permissions?
code .....
can any one help me to read the datas from the excel sheet and match it with the database.i will be thankful to you if u provide me a sample code.
View Replies View RelatedMy database is working perfectly and I am still getting the following error:
Microsoft JET Database Engineerror '80040e09'
Cannot update. Database or object is read-only. /raven/aspBoardFunctions.asp, line 144
I called my new webspace provider and they said you should be able to change permissions with my ftp program. I looked and viewing permissions is the only thing I find. Any suggestions? Code:
I'm using ASP to pull info from a database and open it in Word. Everything works fine but I want to specify the paper size to be Legal. Is this possible or am I stuck with Letter size?
View Replies View Relatedthis should be an easy one. I have a script which I use to add a new record to a database. Simple enough. But I have always used this string in opening up a database for just such a purpose:
"SELECT * from images"
Ok, I obviously don't want to select all every time I want to add record, so how would I just get access to that table without opening all of the records? Would it be -
"SELECT images
I have a databse in MS Excel which I would like to use it in ASP? I know in MS Acces the provider parameter is as follow:
Provider=Microsoft.Jet.OLEDB.4.0
What is the equivalent of this provider to open Excel file? Or is there any other way that I should do, inorder to open the Excel files?
I have an asp app that connects to an Access database. It works properly at my work on XP with IIS5.1 running.
I zipped up the asp pages and the Access database and emailed it to my home, which is XP and runs IIS5.1. When I recreate my work environmnet at home and try to update the database I get the following error when the code hits my AddNew method.
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
I've tried going into Access/Security/Tools/User and Group Permissions and setting all the tables to be able to update. I've even created new ODBC drivers, but neither has worked. The database is not set to read-only.
I am trying to add a record to a database. I keep on getting the error message:
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/client_add_db.asp, line 31
Line 31 is rst.AddNew
I have checked the attributes in the folder - it is not set to read only. For some reason the folder that the DB is in will not let me make the folder NOT read only - I have even tried the attrib command as recommended by ms in the cmd but that will still not change the dir to not be read-only although that did make the db not read-only.
my database is database.mdb
my file path is C:Inetpubwwwrootfypdatabase.mdb
Error Type:
Microsoft VBScript runtime (0x800A0009)
Subscript out of range: ''
Besides using this ASP code of opening up my database is here any other way??? I often get the above error due to " This is my present code..
<%
dim objConn, path
set objConn = server.createobject("ADODB.connection")
path = "C:Inetpubwwwrootfypdatabase.mdb"
objConn.open "driver={Microsoft Access Driver (*.mdb)};dbq="& path &";"
%>
I try to use as much functions as possible. So I have written a function to open a database and retreave the information from a specified field but it don't want to work.
This is the function I use Code:
I have two servers is it possible to open a database connect on one server to access the database on the other. If so can anyone give me an example of the path.
View Replies View Relatedhow to open or do a connection to open switchboard in the Acccess database? Really Really need help from you who knows the code to open the switchboard in access database using asp. or Is there a way to link switchboard form to the asp page so that when i click on a link , it will open up the switchboard form (lets say the form's name is called "Contact") from the Access Database ?
View Replies View Related