I've done several sites with ASP that use an Access database, and it has worked fine so far. I will be developing a much larger site and I need to know if Access just isn't going to cut it anymore.
Is MSSQL what I should use instead? How much is too much for an Access database? What are the differences in coding for something besides Access? (is it just in the connection string, or what?)
A few weeks ago I was told in this forum that ASP would be a great solution to a large web site. I purchased a book about ASP.Net but have also seen info on ASP. Can you please tell me what is the difference between the two?
I don't know computer programming at all. Dreamweaver MX is the program I use. Can ASP be done with a WYSIWYG program? I have set up databases in Access & built web sites with DW MX I am not sure how to tie the two together.
It sounds like you are looking at the properties of the WebSites main branch, when you need to look to the first element under this branch (opening it) to the next "step down", and check the properties of the child element (mine is called "default web site", but yours perhaps has been changed from that).
It also contains an "advanced" button on the Web Site tab (right next to the "IP Address" field) which allows "multiple" identities, which is the part which I couldn't to work with 100% consistency.
I'm just deciding whether to use Access or MS-SQL for a web-application
I'm predicting that my application will grow large enough to warrant use of MS-SQL, but I'm wondering how extensive the changes to my code that would make
...Specificially in ASP.Net, if I use ADO.Net, would I just need to modify my connection string or would it involve more extensive modifications?
If you have a large traffic site, say over 30 current users accessing the database at once, can Access handle this. I know MSSQL can. Is there any other databases that can be used with asp other than Access and MSSQL and what would there benifits be?
View Replies View RelatedDoes anybody know of some asp code (free) to convert an Access database to an MSSQL database.... With contents and all?
View Replies View RelatedI'm now receiving this error:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
login.asp, line 9
Worked fine with Access. Can somebody help me tidy up my code. login.asp below. Code:
I 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.
whats the best browser for mac OS X?
View Replies View RelatedI want to be able to do the following, but im not sure how in asp.
<?php
class Cart {
var $items;
some functions.
}
?>
<?php
class Named_Cart extends Cart {
var $owner;
}
?>
How can I make such a bold statement? Two words: Buffer Overflow.
In the very first class I took in programming (those many years ago), we were berated class after class about proper bounds checking to prevent buffer overflows. What this means in simple terms is that every time my program asked the user for input, it had better check to make sure the input fit in the place I reserved for it. If I asked for a ''Y/N'' and I got a ''yes'' or a ''no'', those extra characters had to go somewhere and I had better be prepared for them.
i have a browse button on a web form that the user can upload images via ftp. the user clicks on the browse button to browse a file on his computer and the text field displays the path - "mycomputerdesktopmyimage.jpg".
i need to get the name of the image and insert the name into my database. so i need to be able to search the string ("mycomputerdesktopmyimage.jpg") and insert all the characters after the last "" which will give me the image name. ive tried just writing out the string in asp (jscript), but it gives me "mycomputerdesktopmyimage.jpg" without all the backslashes.
how do i get those backslashes back into the string? my second question is how do i search for the characters after the last backslash? i know i can use a substring on this, but how can i use it for the last backslash?
I have a form and if none of the radiobuttons are selecte or any of the txt fields are empty i want it to display an error, also if the entry in a txt field is not numeric i want it to display an error, if there are no errors then i wanted to display a message
what is the best way of going about this??
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 been looking around at various design solutions for uploading a file using ASP and have found that many sources have devised a much simpler plan using ASP.NET.
My question is this, I have a box running Win2k Advanced Server, with the .NET framework installed. WIll that enable me to run some of the new functions etc. decribed in ASP.net ??
What's the difference between ASP and ASP.Net? Which one should I learn in order to start making dynamic web pages for the internet?
View Replies View RelatedSo I need to write the difference between the biggest and the smallest number in database table. I know that I need to take MAX and MIN from table, but I just can't get it work.
Example:
Let's say max = 5 and min = 1, I need to have it like this:
5-1=4 (max-min=total)
Maybe my books are just sorry, but I can't find a description of what <%# is supposed to mean. I find Dreamweaver inserting it often.
View Replies View RelatedIs there any technique available that my asp code will convert into asp.net
View Replies View RelatedWhat is the difference between
Code:
<meta http-equiv="refresh" content="5;url=menu.asp">
and
Code:
Responce.Redirect("")
Which one would you chose?
I have imported a list of links to MSSQL database with enterprise manager. I use ASP to show the list of links and it's description. Originally I had 8600 links in the database and I have imported 700 new one.
I have checked in table and all the links exist and the table is indexed on field linkID. My asp script has worked before and there is no problem with it.
I can still show all the links including the new links and it's descriptions but if I click on an old link, it goes to that site while with new imports, it just opens another example of my site (404 page set to open my index page).
The link is correct since if I copy it from screen and paste in browser, it opens the page correctly.I have removed the index from table and made it again but no difference. There is also an edit function in my script, if I click on it, I will get a message that filed linkID does not exits but it clearly exists in the table and the rest of script is using it.
If I creat a ASP page, what do I need or how do I connect to a MSSQL database? Is it possible to connect to MySQL with an ASP page, or is it better to stick with MSSQL when creating an ASP page?
View Replies View Relatedis there anybody know to code the time difference in asp? i used timediff, it returned a date, it should return a time actually. i tried the command in mysql n it's fine. but it's error when i switched to ASP. i hv refered to alot references such as sql time manual n other sites. but stil fail to find ans.
View Replies View RelatedWhat is the difference, and when to use one over the other?
View Replies View Relatedi have a problem with differentiating these
response.redirect()
server.transfer()
server.execute()
do they all perform same?
I'm writing an ASP app that administers an ISA server remotely. The fact that it's an ISA server isn't my problem I believe. My question? What is the security difference between disabling anonymous access and using account X from the web client, versusallowing anonymous access but using account X as the account that runs the application?
When I configure my web application to allow anonymous access, but set the anonymous process to use account X, my ASP code works (the ASP code can administer my ISA Server). When I disable anonymous access, and I log into the web application using the same account X I mention above, I get an error 80070005 when my ASP code tries to connect to my ISA server to administer it. I would think the above two options would be equivalent, but they're not. What is the difference?
I have a problem to calculate the day different. I use
datediff(currentdate, quoteDate) > 20
The error message is : Wrong number of arguments or invalid property
assignment: 'datediff'
I use datediff("D", Date, quoteDate) > 20, but still could get the correct one. Maybe I need to change string to the digit. How to do it?
I understand how asp scripting works and how you put <% %> around your server script. However this is .asp . what is .aspx? is this the new version ASP.nET? I dont understand how it works when i create a new aspx project in vstudio.net and i create a aspx page in design view.
I add a button and then double click it to add code to that button. I dont see any html code around it? In an asp page the server side code is surrounded by html code. An aspx page almost looks like a normal vb application, why is there no html
code around?
Can someone shed light on this: -
When I search for 'ô', the url encode shows a "%F4", whereas should I show a "%C3%B4"
I have an arrayA and arrayB. How do I get the difference into arrayC.
View Replies View RelatedI have 2 fields in a MySQL database. The fields contains calendaristic data. I want to generate a HTML report and make difference between theose date fields. Is there a function in ASP to accomplish this task (like : "=dateDiff(date1,date2)" where date1 and date2 are calendaristic dates)?
View Replies View RelatedI've been messing around with some way on how to insert into access. One page use the sql insert, the other uses
RS.Fields("Column_Name").Value = request.Form("Column_Name")
Both insert, but when i query them from a drop down box in an asp page the sql returns the values, the other one won't query, is there any logical reasoning behind this?
Does anyone try before using ASP to execute JOB in MSSQL?
View Replies View Related