I am planning to design a database (destined for the web) that will have between 20000 and 45000 records in it and will receive a lot of reads but very very few writes (just from me).
Now the question is should I use:
1) The combination of Access 2000 (accessible through ASP or ASP.NET) using OLEDB Jet
or
2) SQL Server 2000 ?
Of course I know that the SQL Server option is a better one, especially since it's said that an Access DB can have about 9 users or so accessing it at the same time. But is that a general rule or is it about many people writing to the DB? In other words, if an Access DB has hardly any writes and 99.9% reads can it be used as efficiently as it would be used on SQL Server 2000?
i am creating a kind of search using dropdown boxes to search the database. I have got two dropdown boxes one called location and one called cuisine i have sorted out some if statement.
so that it works if they select either one or the other and if they select any location or any cuisine but the problem comes when i need them to be able to select a cuisine in a particular location ie on bothe boxes.
i need it if both are selected at the same time then search the database via location and cuisine. can anybody help here is the code for the two files.
I have one 3 tier architecture application running on Windows 2000 Server.
I have created replica of same machine on another machine where OS is Windows 2000 Advance Server.
But when I port same running application on new machine i.e. Machine with OS as Windows 2000 Advance Server, my middle tier (Active-X Dll, COM+ application) fails.
It throws common error Invalid Procedure Call or argument
What could be the problem? Do I need to change any settings for running application on Windows 2000 advance Server.
I want to search through different strings and replace the ‘0’ with empty value. My problem is I want to search and replace the ‘0’ with empty values until there is a value other then ‘0’.
I've got the following code that sets a session object. set obj = server.createobject("Scripting.Dictionary") set session("testobj") = obj
If I want to remove the session object, do each of the following does the same job? Which one is the best? 1 --> set session("testobj") = null 2 --> set session("testobj") = nothing 3 --> Session.Contents.Remove("testobj")
If I want to check if the session object is not exist, which is the best option? 1 --> if (session("testobj") = null) then ... 2 --> if (session("testobj") = nothing) then ... 3 --> if (isobject(session("testobj"))) then ...
I am trying to update and append to an existing XML file. However I seem to be stuck. I am using ASP as my scripting language.
The form fields has the same value as the KEY attribute so all i have to do is loop through the submiting form for its fields and use the name to update the XML via the keys... Code:
I have heard a lot about SQL Injection. I was wondering how does an injector come to know about the table/column name when they cannot see the asp codes in a website?
In one Application (2) the client is redirected to a Logon ASP in a different Application (1). A Session Variable is made in Application 2 which needs to be recognized in Application 1. Can I do that in Windows 2000 SP3 IIS5 no .NET Framework?
Does anyone know of a simple (and I stress simple as I'm a beginner with this asp stuff!!) script to allow for basic functionality of Add/Edit/Update/Delete ASP page which works with an Access 200 mdb. Something I may easily adapt for what I have?? I'm running Windows 2000 Professional with IIS 5.0.
HTTP 500.100 - Internal Server Error - ASP error Internet Information Services
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D) [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'IUSR_MOHD'. /sql1/data.asp, line 16
when i try to add data to my sql server 2000 database throw asp?!? so whatz the problem , i try to connect it to access on the same lginuser and it works well
Our current websites are hosted on Win2K Servers using classic ASP and IIS 5.0. We will be acquiring a 3rd party website that is written in ASP.NET. Hate to sound stupid, but is it possible to run ASP.NET on Win2K or does it need to be run under Win2003?
I have heard a lot about SQL Injection. I was wondering how does an injector come to know about the table/column name when they cannot see the asp codes in a website?
I would like to create, using ASP, a new user inside a "Group of User" that I prior have created, as Administrator (Eg. IUSRGroup), in order to use the internal Win 2000 SRV DB, Security and Permisions.
if is it possible to connect a database (access 2000) through frontpage? i try to do this and i got an error. in frontpage, there is a option to connect database. then we have to publish a web and after you can store your data through form. all these steps i have already clear. but i can't.
Overnight my work PC has been upgraded - I'm re-installing all my software, and PWS does not work
It may be that it's a permissions thing (I need to get this sorted, as it is stopping me from installing a few things) However, I also suspect that PWS for NT is no longer any good for W2K Is there a new version for W2K?
I have created an Access database with an Autonumber field and set as promary Key. When I insert a record from my ASP web page it insists on making me add a value to this field. Is there anyway to set this as an IDENTITY field.
We are not using Active directory and as such do not have access to Kerberos authentication methods. What I need to do is connect to an SQL (2000) database using ASP 3.0 - I have setup an account on SQL Server with read access to two tables (and no password). Just to complicate the issue even further, the IIS server and the SQL server reside on different machines on the network. Code:
I have a simple .asp page with a text field and submit button. When it runs on a Win 2000 Professional + IE6 client machine, and the .asp page is set "anonymous access" only on IIS, the contents I entered to the text field did not get submitted when I click the submit button. If the setting is "Integrated Windows Authentication" everything is fine. Has anyone had experienced this problem?
I have written some code that tries to send out an email, using CDONTS, in ASP. My problem is that the email just sits in the "Queue" folder in the Ipubnetmailroot directory. The server is Windows 2000.
I'm just after installing windows 2000 server. It seems to be running fine. I can log onto sites stored within etc. However I'm having major problems trying to sending email forms. I am using an asp form to send the details however I never receive them. After completing the form and submitting the user is brought to a confirmation window which displays all the form details. There are no errors howver the email is never recieved.
With the errors I cannot say if the email was sent or not. So i do not know if it is the server settings or the asp file.
Do I need to preform additional installation of configuration to get the smtp server up and running as I am only using the default settings.
I was wondering if it was possible to have multiple server connections in one asp application. Like if one connection to the main sql server failed, it would connect to the backup sql server.
I just started learning ASP.NET and i need to learn to use the database for SQL Server 2000 quickly. First, (forgive me for my ignorance) what is a database? Do you guys know any good sites that teach you how to access the database for SQL Server 2000? and have tutorials, and sample code?
I am trying to connect to a MSDE 2000 database located on a server on my network. I can connect to a SQL Server 2000 database; however, I cannot connect to this MSDE database.
This is the error I get: Code:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
What am I doing wrong? I can't figure it out. The ASP page and the MSDE are on two different servers, if that makes any difference. I can add the MSDE server to Enterprise Manger using the same login information too.
I will be traveling and I will need to show someone a secure folder in an IIS website and I will be on a public computer. When we are done, I will need to be able to log off so no one else using that computer will find their way into that part of the website. The security is Windows authentitication using Clear Text.
Can ASP log me off. If so I will need to code this before I leave. Can anyone point me to where I can get some examples of code to do this ?