I have a bunch of .dbf files stored in a folder called dbf. My index.asp page is one level above that (let's call it the root). My asp page uses the following function to retrieve all of the .dbf files: ....
View Repliesi am building a search form by word from text field in a table. for example the table has
1. ID
2. Price
3. Note
the Note field of a record could have sentence that contains words or jargon. What sort of method or approach can i use to solve the problem? can we use sql statement? if yes what sort of?
I'm having a probelm with inserting data into a database using asp but I can't see what i'm doing wrong. I get the page cannot be displayed error ....
View Replies View RelatedWell, it was my experience that the generated stuff didn't work, but I didn't want to make a definitive statement and have someone more knowledgeable come through and tell me how wrong I was.
So now I'll agree: DON'T use Word to generage your code. It is a very bad idea, and for what (it looks like) you're trying to do, it is so easy that writing it in notepad would only take a few minutes, and be much nicer.
I am trying to connect to my database on a server, but am getting the following error: Could not find installable ISAM.
What is the problem here?
Code: ....
I have just set up an ASP-based site to a new Windows 2003 SP1 server with
IIS 6.0. Before now the site has run under IIS 5.0 on Windows 2000.
Every time an ASP page is opened, IE shows the error: "Cannot find server or
DNS Error".
All static page types open fine (HTM, GIF etc)
The confusing thing is - I have allowed Active Server Pages under Web
Service Extensions in the IIS manager. No other extensions are allowed,
other than ASP.NET.
I have tried accessing the site from the server itself, from another machine
on the LAN. I have tried using the IP address, server name and localhost in
the URL. I have also removed the Virtual Directory the site lives in. None
of these changes made any difference. Oh yes, I have also tried rebooting!
I am encountering the same old error,
"Microsoft JET Database Engine (0x80004005) Could not find installable ISAM."
when i try to open an Access file and export the data into it from a table.
Have updated MDAC2.7 and even then its not working. My code looks like
Set tdf = Server.CreateObject("ADOX.Table")
Set cat = Server.CreateObject("ADOX.Catalog")
tdf.Name = ltablename
cat.Create "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & lFilepath & ";Jet OLEDB:Engine Type=4;"
What should be done.Provide some solutions.
1) This is page built as a form which displays the content of a SQL database (a specific row) for users to update.
2) Each form field contains the actual information that the database has at this time (some Columns May or May not have info in it. No actual way to determine if its NULL or Just Empty).
3) I have the actual row selector based on the Unique ID (autonumber value). Its selected from a previous page and passed through GET.
Code:....
i get "system cannot find the file specified" error. iam sure that the path of file iam looking for is true. i guess this is a friendly message thrown. when i turned off the freind messages in IE (client side) i still get the same error. is there any way that i can see the exact error so that i can debug.
View Replies View RelatedI have just started using ASP, I am normaly using PHP but I thought ASP might be a good road to go down. I am having a few problems, I am trying to limit the number of records I take out the database but I keep getting errors.
<%
'connection string
datapath=Server.Mappath("guest.mdb")
strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & datapath & ";"
Set CONN = Server.CreateObject("ADODB.Connection")
CONN.Open strconn
'select all records row by row
DBquery="SELECT * FROM Guests LIMIT 10"
set query=Conn.execute(DBquery)
do while not query.eof
'get a variable from the table
guest_id = query("ID")
guest_name = query("Name")
guest_msg = query("Mesg")
guest_date = query("DateTime")
'print the variable to the screen
response.write guest_id & "<br />"
response.write guest_name & "<br />"
response.write guest_msg & "<br />"
response.write guest_date & "<br />"
response.write "<br />"
'move to the next record
set conn = nothing
query.movenext
loop
%>
I am getting this error;
Microsoft JET Database Engine error '80040e14'
Syntax error in FROM clause.
/guestbook/guest.asp, line 11
can anyone help me?
I keep getting an error when I try to run this update statment: [CODE]
INSERT INTO MYPosts ( IEname, country, server_name, LANIPAddy, license_ver, wrkstn1, wrkstn2, wrkstn3, wrkstn4, wrkstn5, notes, status, rdse, esc, eso, parent, , timezone, ) VALUES ( '" & lcIEname & "', '" & lcCountry & "', '" & lcServerName & "', '" & lcLicenseVer & "', '" & lcwrkstn1 & "', '" & lcwrkstn2 & "', '" & lcwrkstn3 & "', '" & lcwrkstn4 & "', '" & lcwrkstn5 & "', '" & lcNotes & "', " & lcStatus & ", " & lnRDSE & ", " & lcESC & ", " & lcESO & ", " & lcParent & ", " & lcTimeZone & ")"
I get the following error:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression
I am testing a new website I built on the actual server. My section for uploading documents seems to be giving me problems. Can someone help me please? This is the error I am getting:
Microsoft JET Database Engine error '80004005'
'c:logindatairb.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
/login/insert.asp, line 28
I had this before: .....
I have a query. When I write out the sql and run it directly in the access db. it works. When running it using ado it doesn't work. I know I have run into this before but don't remember what the solution was.
Works in access but when running it using connection.execute sql
I get the following error:
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
admin.asp, line 345
well i m developing application in asp when i want to access these pages from ie5 it shows error HTTP Error 403 - Forbidden in internet explorer http://localhost/Mail/email.htm .
View Replies View RelatedI thought this is more of an IE issue but i've had no joy on that group
perhaps somebody here will have a clue.
If i click a link to a web page embedded in Excel (97 OR 2000) i get the
standard error page displayed by IE (you know, the 'cannot find server or
dns error' page).
Turning off 'show friendly http error messages' alleviates this.
(Unfortunately this is the Windows default setting!)
Whats going on?!?! Code:
I've had some problems with an ASP site I've developed. Everything is pretty simple/basic, however, the box it is hosted on is very "neglected" to say the least (old NT 4.0 box, zero services, etc).
Anyway, I have these pages that worked fine until today. The pages are fed from an Access 2000 database. The system administrator's been switching all the DNS records for various boxes lately and was wondering if this could be the culprit giving me this error.
I know this error is often associated with I_USR account privileges, could they have been re-set during this process thus giving me the error? Or could it be something else?
I'm getting the following error when I try to connect to an Access database using ASP 3.0: "Could not find installable ISAM."
Here's my connection string:
objCn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbPath & "; UID=admin; PWD=mypassword;"
This started happening when I added a password to the database connection string. It worked before I added the password to it. What am I doing wrong?
Unable to open registry key 'Temporary (volatile) Jet DSN
I keep getting this error and it is when i have my database open whilst i'm trying to use my site. Is there something you can do that allows you to have your database open and still use your website.
Hello I am trying to install a blog on a .asp site... and .asp is by no stretch my strength.
I did exactly what the install specified but when I try to enter an entry I get:
Quote: INSERT INTO T_WEBLOG (b_headline, b_content, b_date, b_time,b_month,b_year,b_author,b_published) values ('Test','test',2926800,'11:00',7,2006,'admin',true )
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
Now, this tells me I would need writable premissions- which I can do all day long on a unix machine, but I can't on Win box to my knowledge.
Can someone provide a little guidance?
Thanks so much!
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked.
This error occurs when I execute the codes below but I don't see any mistake.
while not rs_month.eof
cmdDel2.commandtext = "Delete From " & rs_month("table_name2")
cmdDel2.execute()
cmdINSERT.CommandText = "INSERT INTO " & rs_month("table_name2") & "(BUID, SBUID) SELECT SBU.BUID, SBU.SBUID FROM SBU"
cmdINSERT.Execute()
rs_month.movenext 'move to the next row
wend
I created a website and it has been functioning without a problem for a week. It uses an access database and pages are written in asp.
I am suddenly getting the following error (and I didn't change any code since it was working)
Microsoft JET Database Engine error '80004005'
Unspecified error
/openconn.asp, line 18
This is my objconn.open line.Any ideas?
I am trying to connect to a database and insert data from a form. The code is correct, to my knowlegde. Now, I have another page that is selecting from the database, this page works fine. The page inserting for some reason I can't firgure out why it is giving me an Operation must use an updateable query. I have read through some of the cause for this and haven't had much luck here's why.
I think it is the permissions but I need someone to walk me throw how to change them. The company has a dedicated server located off the property where the web site is contained. We also have a mirrored server in house that I have access too. Now when I go into the mirrored server and right click on the database I can change the permissions here.
Which I have done and it's still not working. At first I didn't have IUSR set up, I have a couple of Iusr accounts to chose from and don't know which to choose. Plus when I finally did choose one the code still gave me the same error.
<LI>Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
/akamat/ImportFromExcel.asp, line 47
strExcel = "Select * from sometable;"
dbSchConn.execute("Insert into tblAssignSiteDate strExcel ")
this is the error I get. sorry if this is a repeat posting but I been looking and having found anything to answer my question.
Microsoft OLE DB Provider for SQL Servererror '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
What I am doing is doing a Select Statement from a Table and using that information to populate another table with an insert statement. The thing is, it insert a couple hundred entry and then it gives me that error message. I could insert a couple hundred a time but that is going to take too long.
I get the following error can you help me why?
Microsoft OLE DB Provider for ODBC Driverserror '80004005'[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data. /Vestelweb/Tools.asp, line 6
Tools.asp line 6:
Sub OpenAddress (ByRef con)
Set con = Server.CreateObject("ADODB.Connection")
con.Open "DSN=Address"
End Sub
I have a page that displays results of a database query that is paged to 5 records per page and i have some very messy code for the navigation.
Firstly i have a "First/Previous/Next/Last" navigation set then i have direct page numbering which is limited to 10 pages and as you move through the pages the page numbers change depending where you are in the page set.
If that makes any sense.
i.e. if you are on pages 1 to 5 it shows pages 1 to 10, if you then go to page 10 it shows pages 5 to 14 etc.
This all seems to work quite well, not sure how but it dose.
What i am having problems with is the URL's the links point to as the page can have various parameters. the URL always calls the same ASP page but the parameters can be different.
example:
Page.asp (default page)
page.asp?page=5 (default but on page 5)
page.asp?user=userID&page=5 (page with specific user and on page 5)
at the moment there is only the user parameter apart from the pages but this could change.
I need to be able to build the URL's for the links dynamically so it includes all previous parameters from the existing page but then changes the page number when navigating through the pages.
Anyone got a good solution to this one, i keep hitting a snag with the parameter separator whether to use ? or &.
I get the following error:
Command text was not set for the command object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Command text was not set for the command object. Code:
I am unable to access an Access database through a webpage I built, but only if the database is on a server running Windows NT 4.0 Server. If I copy the database to
a pc using NT Workstation then there is no problem. I have a user account set up on the sever as IUSR_pcname. It is a domain user with full privileges. This is the connection code:
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=10.10.10.10pcdTEST.mdb;"
It gives me a 'disk or network' error and for some reason, and the server locks out the IUSR_pcname account after I try.
I have a two dropdown lists (Job Catogory and Sub Job Catagory). The values are populated from the database in the following manner, when a user chooses a particular job catagory from the Job Catagory list, the corrosponding sub job catagories are populated into the Sub Job Catagory list. I am using asp as the server side script and sql server as the database. Now whats happening is that when a user chooses a particular job catagory, the form reloads and thn only the sub job catagory list is populated. Is there anyway that this can by done without reloading the page. Probable using a combination of asp and javascript
I posted the same problem in XML forum as someone told me that this can be done through it.
In all likely-hood this is a very easy fix, but I have been working on this site all day and am a bit burnt.
This is for a search page and I am getting this error:
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/Itec4477/MyProject/searchIt.asp, line 63
From this code:
I am trying to retrieve and updata a MS Access record with the following code:
View Replies View RelatedI have an unusual problem and am stuck trying to solve it. My code worked fine last week and hasnt been altered since. I now get the following error:
Microsoft JET Database Engine error '80004005'
Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.
/Cs_Jobs.asp, line 41
The code i am using to acces the DB is: Code:
My database is on another disk partition. When I try to run the following code to make a connection to my DB. I get an error message.
"server.mappath must use a virtual path, physical path has been used"
How can I fix it?
strDataPath = server.MapPath("T:databaseTest.mdb")
strConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;"_
+ " Data Source= " & strDataPath & ";"_
+ " Mode=Share Deny None;User Id=admin;PASSWORD=;"