i downloaded soem code that is a way to view a MS access db with asp. The error I get is Not a valid file name. Microsoft JET Database Engine error '80004005' . I know it might not be enough information, but anyone have any clues? Code:
View RepliesIs this sql statement valid?
strQ = "SELECT *"
strQ = strQ & " FROM Receipt"
strQ = strQ & " WHERE Receipt.Expense ='Inventory' AND Receipt.ReceiptDate Between #1/1/2005# And #12/31/2005#"
strQ = strQ & " ORDER BY Receipt.ReceiptDate"
What I like it to do is select all references to "Inventory" under the field Expense for the entire year of 2005, with the results sorted by date ascending.
If you use ASP.NET you can still make valid xhtml code right? Becuase Visual Studio .NET 2003 doesn't care if it's <br> or <br /> thats bad in my opinion =) You know if Whidbey will make better xhtml?
View Replies View RelatedThe field name 'articleid', which is an identity/primary key , is not being recognized in my recordset as I get an " Item cannot be found in the collection corresponding to the requested name or ordinal" error with the following- the line number that the error message points to is on my response.write for the rsid("articleID") :
dim sqlid,rsid
sqlid = "SELECT max(ArticleID) from tblarticles"
Set rsid = Server.CreateObject("ADODB.Recordset")
rsid.Open sqlid,sqlc,3
response.write rsid("ArticleID")
I'm using a ACCESS database that has a databasepassword. In the connection string I'll provide the password as follows:
MM_test_STRING = "dsn=test;pwd=test;"
This works fine on IIS 5 but on IIS 6 on Windows Server 2003 I'll get the
followwing error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Not a valid password.
When I'll remove the password the DSN works fine also.
I want to use validation with my ASP script before i add a new record to the database.
Code:
if UserID = "" then Response.redirect("login.asp?login=createnameEMPTY")
so far it only checks that the field is empty- how would i also check that the field is just letters and numbers or if the email field is valid?
When I'm trying to start the smtp virtual server the status of the smtp server is showing 'the requested Control is not valid for this service'
Its state is shown as unknown.Wat ay be the reason.
The messages I'm sending is going to the pick up directory from there its not taking
Is this a valid name for a session variable:
Session("mySessionName:$SO")
If so, does the " :$SO " mean anything special? I'm going through a web application written by somebody else (who I don't have contact with...) and it's littlered with these types of session variables.
I have one asp page in which i ask the user to enter the path. This then transfers the control to next asp page. In the next page i want to check whether the path is valid or not. I know there are methods of FileSystemObject like DriveExists, FolderExists and FileExists but these has to be used individually.
Suppose the user enters the path as "D:" then i should use DriveExists
and if the user enter the path as "D:/test" the i should use FolderExists
i.e i have to use individual functions. How to check this using one function only
Another problem is that i want to display the message on the page for some seconds and then the control should transfer to next page. How do i go about it.
I use the following code to chck for a working url. It does work for some, but sites that seem to be written in PHP, and google, seem to return a "fail" - I can't figure out how to get p-ast this.
Dim objHTTP
Dim sHTML
Set objHTTP = Server.CreateObject ("Microsoft.XMLHTTP")
objHTTP.open "GET", strURL, False
objHTTP.send
sHTML=objHTTP.statusText
if err or sHTML<>"OK" Then
sTxt="fail"
else
sTxt="ok"
End if
Set objHTTP=nothing
else
sTxt="fail"
End if
Say I retrieve and e-mail adress from a form like this, then I know how to check that it's not empty, contain numbers etc. but I don't know how to check that the e-mail complies with some kind of regular expression or the like.
Therefore I wonder if you have any good e-mail form validation code that can be used on the server side (comparable to Java Script reg.exp on the client side).
<%
Dim mail
mail = request.form("email")
IF mail = "" or mail does not complain with some kind of reg. exp THEN
some code....
End IF
I am now all of a sudden getting an error in this sql connection
string, saying that the Provider keyword is invalid:
<add key="MM_CONNECTION_STRING_isox"
value="Provider=SQLOLEDB;SERVER=xx.xx.xx.xx;UID=xx;PWD=xx x;DATABASE=xxxx;"
/>
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Not a valid bookmark.
has anybody seen such types of errors?
how to write to check verification valid email thru nslookup or mx record or dns record. Is it possible to do that. Is there any tutorial from sitepoint, previously found it but i lost the link.
example to check assume test@domain.com is not a real email, abc@domain.com is real email
how do u check it.
i'm converting an image file to hexa..then the hexa is saved to a text file..
can any one help me how to read the content text of a text file?...
im doing it this way because i don't want to save hexa in my database, because it makes the database slower to open up.
is there a way, using asp, to find out the width and height of an image file?
View Replies View RelatedI have code that loops through a directory reading files..
now the problem is that files are constantly being uploaded and I only want the file system object to read those that are finished being uploaded.
How can I check the properties of the file to see if it's in middle of being written before i read the file?
i am having a problem in how to create a Open File dialog to enable user to select a image file that will be stored into database. i just want the file path to be stored in database, not the image.
View Replies View RelatedIt works if the file in on the server side, how to use the component (DSOleFile) with the file on the client side? Also how can I calculate the width of the file. (Page set up - Landscape or porrait). Code:
View Replies View RelatedI need to do online streaming multimedia file on my web portal, just like those online portal that selling MP3. User need to click on the preview link to stream the audio file to listen before they decide to buy the file or not. How do i link my audio file in my web server to allow it to be stream? Totally lost on this function,
View Replies View RelatedThis question has to do with MS file search but it is happening only with
..asp pages, so I though someone programming with .asp pages has experienced
the same situation.
I'm trying to find .asp pages with a certain table name (i.e.
"renewalInfo" )
When I ran the search I get no results. I know that I have that string in a
couple of pages. My file system search engine is working fine with other
file types, like Word documents, Excel spreadsheets, etc.
I tried typing the string outside the <% %> tags and when I do the search I
get the file results, so it seems like if the search engine in my file
system was not searching inside the <%%> tags. Code:
I'm having a problem with the fact that I want to allow image files to be uploaded to a remote web server, as the hosting package the web site is on is IIS6 and has a default file upload size limit of 200kb. As it's a shared hosting package, the default limit cannot be changed for me unfortunately.
Anyway - i need to check the size of the file being uploaded, so i can notify the user and prevent them getting the default Microsoft error message page. The problem is that I can't implement a server side size check which works, using either Request.TotalBytes or load.getFileSize (with "load" being an object of my loader class). It seems that I can't carry out any of these operations when the file size is too large.
I'm trying to run the server.execute command inside a executed file. It doesn't work. Can anybody tell me why? I've searched all around and haven't found a reason. Could it be because it's not supose to work, or is the syntax diferent then in the first file?
It's something like this:
File 1
...
<%Server.Execute("File2.asp")%>
...
File 2
...
<%Server.Execute("file3.asp")%>
...
File 3
<HTML>
<body>
Hello!
</body>
</HTML>
Is this possible?
I am using the File System Object to create server side cookies and part of
the Function that I am writing deletes a file but I am getting a permissions
denied error on that line of code.
I am using Integrated security only on this site but how do I get the
IUSER_Machinename account to work with Integrated Security?
I have an asp page written entirely in jscript with a vbscript used as an include file which one variable on the page must access.
When the page runs, I run into jscript complilation errors when it tries to access the include file (since it is written in vbscript), and I can't figure out how to get the two to work together. How do you get both scripting languages to work on the same page?
if i got a file path as a variable say for Example:
c:folder1folder2folder3folder4file.txt (The Path could be any long)
how do i just store the Path of the file name and the file name seperately. like :
File Path=c:folder1folder2folder3folder4
File Name=file.txt
I would like to add a facility to my web page which allows users to upload basic files (word, excel, text, gif, jpg etc) to the server.
I know there's a facility to do this using HMTL forms, but I don't know how to handle the file on the server side.
What I think I need is an ASP file running some code to manipulate the filesystemobject, allowing me to receive the file and store it in the filesystem on the server. It would be nice to access some of the file properties too (name, type etc).
I've seen a few custom components online which allow you to do this, but I can't depend on installing them. I need to be able to script it myself.
I have a page on our intranet that is supposed to stream an Excel sheet to
the user. I'm using pretty standard code:
Does anyone know of a method of converting text files to sound files (.wav, mp3 etc) which can be accessed from ASP?
I have an ASP-based website that enables users to design choreography for equestrian dressage. The resulting design is held as a series of coded movements in a database and it can then be reproduced as text or as a series of diagrams. I would like to offer the option of an audio version.
i would like to add a user and set file permission to a file with ASP.
(No component). is that possible ? do you have a link ? an example ?
I would like to use this code on my website to allow simple file uploads from clients. I would like to restrict the file types they can upload. Code:
View Replies View Relatedi am currently working on a project in which part of the requirements are to store files on the Server filesystem and make these files available for download by users. Is there a simple way to provide the user with a link which starts downloading the file when it is clicked?
View Replies View RelatedI have an upload feature on my site... it works fine... but I want to validate the uploading file extension for .doc or .html before being uploaded to the server(client-side).
I have the validation to check text fields are not blank.... The first validation is for checking the text field... the second "blob" is the file upload field.... This is my code in Vbscript.. Code: