Microsoft Knowledge Base Article
i wanted to get the 411 on this article. I want to create a small utility web site with a logon page and a form connected to an Access database. The article below explains exactly how but when I try this I can only see the code no actual logon page - nothing but code.
My system is asp allowed and asp.net extensions allowed. FP 2002 extensions allowed. All other extensions are prohibited. I am using w2k3 IIS 6.0 and running 3 html sites succesfully all with working forms. Is there something on the server/website itself I need to enable?Why do I only see code and not a logon page as described in the article?
View Replies
ADVERTISEMENT
Can anyone point me in the direction of a freely-available Knowledge Base/FAQ script, compatible with iis5 and ms sql.
View Replies
View Related
I am just after a bit of your expert Knowledge. Maybe a very stupid question but can you use SWITCH statements in asp?
View Replies
View Related
I want to put an article from a newspaper web site into my web site. My aim is to pull only the necessary information which is related to author. Many of the newspapers have daily article from author.
Within author daily article, my only interest to get the article. I do not need any other section from web site.
View Replies
View Related
I am trying to figure out how to divide longer articles in to separate pages with a "next page" function at the bottom of each page.
Thus far, for my information based website, I have created my database, my Articles.asp page, my Catagory.asp page, and my default.asp and I have built a content editor to enter my articles. And all are working great.
My problem is, I would like to divide my longer articles into smaller pages. I see it all the time on sites...so I can't believe it is that hard. Do I need to divide the articles into "fields" in my database? or is there a way to do it without altering my database?
View Replies
View Related
An MSKB article on the scalability of ADO/ASP
(http://support.microsoft.com/kb/176056/EN-US/) says in a discussion of
why connection objects shouldn't be stored in session variables, "If
you do not pool there will be idle connections wasting server and
network resources. You also have some threading issues that can occur
if multiple concurrent threads end up hitting on the same connection
(though the session ID might save you here, but it is conceivable that
a browser could submit two concurrent requests using the same session
ID and you could get into situation with transactions or with SQL
Server's inability to process more than one command at a time on a
given connection)."
What are the potential threading issues here? (Are there threading
issues even when connection objects are created on each page?) I
thought that even with connection pooling, each connection is only
being used by one user at a time. (And what does this have to do with
Session ID?)
View Replies
View Related
Say I have a 3000 word article in a database field and I want to break it up into a number of pages.
The page break point will be at the end of an paragraph.
View Replies
View Related
I followed the instructions in this article, building the COM+ component and registering it, and creating the two asp files - Upload.asp and Postfile.asp. The problem is that as soon as I submit the Upload form on the Postfile.asp page, I immediately get an "Out of Memory" error from the server. Amazingly though, the file gets uploaded intact.Does anyone have experience using this method or have any ideas as to why I get this error?
View Replies
View Related
I am using asp to create a form where you can send the news article to a friend, and it actually sends the entire article. The problems the article contains <br>,<b>,<i> tags, and when I send the email it shows up like this Quote:
in the Holy Land: The Ideal and the Real. </b><br>
<br><br><br>
The lecture is co-sponsored by the Center for Middle Eastern Studies at
North Park University,
I discovered the replace function. Replace(body, "<br>", chr(09)). That got rid of all the <br> tags, but there are still <b>, <i> tags in there. Is there a way to do a multiple replace like Replace(body, "<br>",chr(09) & "<b>", Chr(09))? I tried it and it did not work. Is there a way to do that?
View Replies
View Related
I need some advice/ideas on how I could do the following:
I want to store articles which contain both images and text - like a writeup of an event - kind of an image and text blog.
I want to store articles in a database probably - at the moment I use access databases.
Clearly I could have the text of my article in one field and store images (or links to them) in other fields and then display all the images at the end of the article but what I want is..
to be able to make it to have text then a few paragraphs down have a nice right aligned image with text to the left of it and then some more text etc etc so it looks like a static, layout planned article.
What would be the best way to go about this? Can this be done by storing in a database?
View Replies
View Related
I am trying to use GetRowsMove method since we are not using stored
procedures, I got until 77 rows found. Showing page 1 of 2. - nothing shows
up in the list box and GetRowsMove.asp I couldn't get that up and running
instead of your recordset I am pulling from my own database that is the only
difference...
View Replies
View Related
So I have that huge database, with a lot of article from different poeple on the same subject. Listing all the articles is too big so I decided to add paging to my pages. So far so good, its working real fine exept for one thing and its here I need help as to how I could configure my things.
For each people with an article a user page is create and in that page are listed their article with the link to them. So how can I specify the link so it knows that the article of that person is at the page=2 or 3 or 4 ... of the paging?
Before paging it was quite simple I was just using an HTML anchor with the reference numberID of the record like this : <a name="<%=RsCritique("refID")%>"></a>
Any idea?
View Replies
View Related
I'm trying to build an application in ASP and using multiple database, but I've receiving some problem, have any idea or have any sample scripts to use multiple database?
View Replies
View Related
I'm using W2k Pro, ASP 3, IIS 5 & DWMX 6.1 and code in VBSCRIPT
I currently use the <BASE href=XXXX> in all my pages and just read
that this tag is no longer supported so will soon vanish
I have a couple of sites that I'm working on and to make all my links
work right etc I need to use the base href tag
http://localhost/site1/
http://localhost/site2/
http://localhost/site3/
where online the base href would be
http://www.site1.com/
http://www.site2.com/
http://www.site3.com/
all my links are like <img src=images/mylogo.gif> or <a
src=info/info.asp>Info</a>
Now my problem is how else would I design my sites if I cant use the
Base href tag so the site would work both on LOCAL & REMOTE servers as
needed in the above paths?I'm sure other people develop on a WIN 2k PRO system where you canonly have ONE site (c:inetputwwwrooot) Which was fine when I only
had one site... but when I needed a second I had to change my first to
use the Base href so I could check the sites out locally (offline)
before uploading them to a live server.
View Replies
View Related
Do I create and name all pages with .asp or still in .html. when creating a drop down menu, assuming all the tags are in place, how do i test the site on the server?
so do i create the html pages first or the data base first or does it matter? where is the data base created in notepad or excel?
View Replies
View Related
I have been using php for a while now but have recently had to start using asp. I have purchased some hosting from webfusion.co.uk but have been having trouble connecting to the sql server, could someone possible help me here as I don't know what is the correct code to use to start with let alone know where I have gone wrong.
View Replies
View Related
This error occured with me when i want to open my access database:
----------------------------------
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 0x888 Thread 0x1288 DBC 0x2e8f014 Jet'.
/AAA/Afghanistan.asp, line 374
----------------------------------
View Replies
View Related
I have a data base that I wish to add a record to. I have many fields to ender, but I was testing my code with just one and it works just fine : Code:
View Replies
View Related
Im creating mcq questions using asp and have problems in storing the scores into my database..
View Replies
View Related
I have a few check boxs on a page. What I want to do is if a box is checks a value of Y is stored in the database. Could you please show me how to do this?
View Replies
View Related
how can i insert the images in any format in MS Access database using the ASP plz give me a simplest and easy code which i can use in ASP
View Replies
View Related
I want to update Excel file when i update database.
View Replies
View Related
how do i get a value from a combo box and populate a list box base on the selected value from a combo box? If possible can i get a sample coding.
View Replies
View Related
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
I keep getting this error message when im adding a new record to my database.
Here is my code: ....
View Replies
View Related
i m trying to coneect to a access database Using DSN , but when i try to connect i get an error
Microsoft OLE DB Provider for ODBC Drivers error '8007000e'
[Microsoft][ODBC Microsoft Access Driver] System resource exceeded.
View Replies
View Related
I am trying to peform a multiple deletion of records from a single table "Stockist"
I i keep getting the following Error and can't see where i am going wrong. Can anyone help?
Microsoft OLE DB Provider for ODBC Driverserror '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
/RetailerStockProductRemove.asp, line 22
The code i have used is as follows:
View Replies
View Related
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?
View Replies
View Related
this small bit of SQL:
SQL_EditNews = "INSERT INTO tblNews (newsBody) VALUES ('" & editedNews & "') WHERE newsID=63"
Is there something wrong with this statement? When i try to execute it, i get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Missing semicolon ( ; ) at end of SQL statement.
/edit_news_03.asp, line 19
View Replies
View Related
I am urgently finding a set of codes to write data into a form and the data will go to my database. However i have tried a lot of form but couldn't successfully process. Below is one of my problem...
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 0x9a8 Thread 0xa08 DBC 0x3041e1c Jet'.
View Replies
View Related
I have this insert statement where instruction field in the DB is a memo field.
SQL="INSERT INTO int ([instruction]) VALUES " & _
"('"&Request.Form("myTextarea")&"')"
objConn.Execute(SQL)
Its giving me error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
View Replies
View Related
Dreamweaver created code to update to data base. But when testing on website i get the following message. I have no clue what it might be.
Microsoft JET Database Engine error '80040e14'
Syntax error in UPDATE statement.
/admin/update.asp, line 111
line 11 is strName.execute
I read it might be forbiden characters in the data base field names or spaces...
but i don't have that. the names are userName, userLevel, ID, Password.
View Replies
View Related
Is there any way to set <base target="_blank"> for links which link to a
page outside the domain, and <base target="_self"> for links which link to a
page inside the domain?
Can i do such a thing in the global.asa file or maybe in an other include
asp file? I am working on a site with 3-4000 hyperlinks, and I do not look
forward to "marching" through every each one ove them and set target to
_blank og _self...
View Replies
View Related
Any body knows how to include microsoft agents in an ASP page????
View Replies
View Related
