I have an xml file, which is to be updated by an asp script (vbs) when users are submitting forms from their browsers. Now I wonder if there is anything that stops the following to occur: Code:
View RepliesHow would you make it so that people cannot download your .mdb file straight out of your site and see peoples usernames and passwords and then just log in with their info? Is there a way to block people from downloading the access database?
View Replies View RelatedI am greeting I would like to consult the better solution(with security consideration) to
the access is for MSSQL(2005) from ASP(Classic) in the system of the intranet.
a) SQL mixed mode and depositing user name and passwords for MSSQL of the
server in "connection string" (with open text)
b) Windows Authentication and to send rights to SQL of the server for
IUSR_computername
c) ?
Intranet(server ASP and MSSQL) in the company available from the any
computer, workers data (name and pass) they are being kept in MSSQL tables.
Problem is because Server MSSQL(Intranet) he will be replacing himself into
data with two MSSQL servers and with one PostgreSQL through Windows
Authentication.
i need to build a billing reports system that stores very secure ditails +plus+ i got to connect it to some customer relations systems that runs on the web(asp sql).
i got 2 options:
writting it in asp and storing all secure ditails in the same secure+ssl sql database.
or to write in visual C/ C++ program that will run on computer and every few minutes will connect to the customers relations system and save all the new data on the computer.
I have one ASP and sends XML data to another ASP which returns Data from a Database. Pretty straight forward, however the XML string is quite long and I would like to pass it to the second ASP via a POST rather then a GET. Problem is that the only way to retrieve the data is to use the BinaryRead method of the Request object.
This data is only text, but I can not find any reference of how to use the data once I have retrieved it?how do I access the Data from the REQUEST.BINARYREAD?
I'm busy working on a content management system for a client and some entries that they want to add have single quotes in the text.
How would I make sure the entered text is SQL safe but without stripping out the '.
My Interdev works fine, but he can't seem to use dreamweaver. The files open ok, and they save to VSS, but don't show up on the site.
Is there something I'm missing?
Has anyone seen a good solution for Search Engine Safe URLs with Classic ASP? I've been looking for a while and short of using the 404 or installing tool on the server I was hoping there might be something else.In ColdFusion you can do a server.com/myfile.cfm/id/410 and it just works ... (well, after you parse the slashes)
View Replies View RelatedI am writing a new asp.net program. Here in, the user has to click on a
button on a web page, and a new excel sheet should open up.
I could do it successfully using Office 2k3 PIA's for the click event handler for the button. Then I decided to create a new thread and complete the process of creating an excel sheet in the new thread itself.
But I am getting the following error.
An unhandled exception of type 'System.UnauthorizedAccessException' occurred
in Unknown Module.
Additional information: Access is denied
But, the code executes successfully when i remove the thread and directly
code it in the click event handler for the asp button.
What might be the problem?? How can I give access permission to the thread??
Should set some permission in the Internet Information Services Manager.
Does the issue posted in http://support.microsoft.com/?kbid=243543 apply to IIS 5.0 and IIS 6.0 whereby storing objects in session or application objects causes thread affinity thus removing all benefit of a thread pool
View Replies View RelatedIs there an explanation somewhere as to how IIS6 determins how many ASP threads its actually going to use?I have configured IIS6 to have 20 threads (ASPProcessorThreadMAX) but it uses them all.
I am using the MACT test tool to stress test and with 50 concurrent users I quite often see only a single ASP thread being used the other 49 are on the Requests Queued. The Request Wait Time in Perfmon can be averaging around 5 or 6 seconds and there is plenty of spare CPU.
The application quite often has long running queries(15 to 20 seconds per request)and rather than use another thread IIS will quite often just keep ticking along with the threads its using with the result that the Request Wait Time can jump significantly.
Here's a question that I've not been able to get a definitive answer to.
Creating an STA object (such as a typical VB6 object) and assigning to the
ASP Session store is a bad thing.
It's a bad thing because it forces IIS to affiliate the Session with the
Thread on which the STA object is created.
This means all subsequent requests for that session can only be handled by
that worker thread and can therefore result it in poor performance as
requests queue up to access the thread they are affiliated with.
My question(s) is/are this:
Is this affilation now set in stone for the life time of the session?
Does removing the STA object from the session remove the affiliation or is
IIS/ASP just not that clever?
I am putting the thread details into the Thread_Table table, and so creating a new record in that table. THen I need to create a new post in the Post_Table, and need to pass it the ThreadID that I just created in the Thread_Table. Code:
View Replies View RelatedI am using ASP + IIS + MS access, when running the following codes:
set Conn=Server.CREATEOBJECT("ADODB.CONNECTION")
conn.open "DRIVER={Microsoft Access Driver
(*.mdb)}; " & Server.MapPath("db.mdb")
The following erorr is show:
General error Unable to open registry key
'Temporary (volatile) Jet DSN for process 0x508 Thread 0x634 DBC 0x2181024 Jet'.
I have shared the MS knowledge base and try to grant the modify Permissions to IUSR_SERVER on the folder that holding the database, and set the script authority in IIS, the error is still exist. If I create a system DNS for that Access file and modify the second code as ...
conn.Open "AKmobile"
Another error is show:
[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.
But there is no problem when conencting with MS SQL Server.
I have a Development server that is running Win2k, IIS 5.0, and ASP enabled. I am trying to gain access to an Access 2000 DB located on a file server within my domain. I'm pretty sure I have all the correct permissions set, but I am having problems when trying to access the DB.
The error is similar to:
The Microsoft Jet Database engine cannot open the file '******'. It is already opened exclusively by another user, or you need permission to view its data.
I'm looking for ways to fix this... Microsoft suggests turning off the ability for IIS to sync passwords. Unfortunately, this is not a viable solution for me.
Is it possible to create a new virtual server that is a share to my file server? Put my ASP and MDB file in there and have it work? Anyone have any other ideas?
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xa60 Thread 0xb30 DBC 0x1391ec4 Jet'.
/name.asp, line 17
my code:
All time that I go to make login to enter in admin is appearing this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x120c Thread 0x1494 DBC 0x1690024 Jet'.
/noticias/config.inc, line 6
In line 6 of config I have this: .....
Is it possible to read a file from a local computer? I know how to read a file that is in the server, however I would like for the user to read a values contained in a file that is loacted in his/her computer and then load these values into a database.
A way around this would be for the user to upload his/her file into the server, but reading the file directly from the local computer would be much faster.
is there a way i can read into two tables in the same database access file?and if so.. how would i write the code?the code below is already connected to a database reading from table1.. and i wish to read it from table2 as well...
rsMap.Source = "SELECT * FROM table1 WHERE (State = '" + Replace(rsMap__MMColParam, "'", "''") + "') OR (City LIKE '%" + Replace(rsMap__MMColParam2, "'", "''") + "%') ORDER BY City ASC"
Is there a way to upload a file first to a directory (which is have done) and then either upload it to a database or referance it within a database
View Replies View RelatedI want to do one of two things and I not sure which until I know the difficulty level (knowing a little asp but not alot) of each. I am helping in the office and we will have several small access dbs using the FrontPage forms methodology.
So, now that I have some data bases, I will want my users to be able to 1)copy the database to their own machine where they can massage and do whatever they need to with the data, or 2) perform a query against my data bases, and have that result sent in db form to their machines to do whatever.
I've seen somewhere that asp has some file system components but am not sure how that
works. I am willing to read and figure it out if I can get a push in the right direction.
i've bunch of files in a directory which need to be displayed in a html page. is there a way to display those files by order (dateCreated (descending))?
View Replies View RelatedI worked on a database on PWS (Personnal Web Server). But transferring the database and all the files (html is used for inputting "search" words, asp used for results from database table). Here is my code:
View Replies View Related1. I want to import a dbf file to access through ASP Programm. When i import a dbf file with filename greater than 8 chr, it gives an Server error saying File Not Found,Maker sure if the path is correct or filename is spelt correct. what should be done do import a dbf file with a longer name.
2. In the dbf file i want 3 fields to export to MS Access table. for eg : - Name, Address,City.
How can i make sure if all the field Names (Columns) ie: Name, Address and city is present in the dbf file programatically. for eg : if There is Only 2 fields in the dbf file while importing to Access rather than giving an server error message, it should display my customised Error .
Is it possible to write from FLASH SFW file to ACCESS via ASP as they write to MySQL via PHP ?
View Replies View Relatedi am trying to write something to an existing file. but i got error msg: Error Type: (0x800A0046)
I have done research on this error, i have change the write permission, setted up IUSR_(my computer name) account in authentication method, unchange the read from the parent folder.
i have done every thing, i dont know what can i do to allow me write something to a text file using asp. I can read the file no problem. here is my code:
I usually use SQL Server, but have occasionally had to use Access. This is
such an occasion. My research, mainly at aspfaq.com, has been that you need
to put the file path in your connection string, like this (watch out for the
wrap):
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:mydirectorynamedbname.mdb;User Id=xxxxx;Password=xxxxxxx;"
Well, the host of this new site I am working on is asking me if a relative
path will work. I don't think it will, but thought I should ask.
on my asp page i have a list of results pretty much printed out the same way the access database is structured, so its nice n simple. although i want to let users download the results into an excel file or text file.
View Replies View RelatedWas asked to take a look at a script and to adjust the file uploading limit to more than 1MB. Currently, only files (.pdf) not more than 50kb can be uploaded to the database. Other than that, the script works fine.
View Replies View RelatedI am methodically working my way through the Sitepoint 'Build your own ASP.NET website' and have been successful in every lesson up to page 279. However I've come stuck when trying to add information to an Access Database. When I try to do so I get the message:
Operation must use an updateable query.
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: Operation must use an updateable query.
I have tried the solution described in the book but still get the message. I am using IIS and XP Professional. The database works for queries so how do I get it to accept information entries?
I have one COM (.dll) for uploading files to server. Its working fine on server A but same code and file not working on server B giving error Path/File access error .
View Replies View RelatedI had some issues with setting file permissions to write to my database in access. How do I go about, step - by - step setting the file permissions?
View Replies View RelatedI am trying to upload an excel file into MS access dB using ASP and its not working.
View Replies View Related