i want to make a direct connection to my SQL server 2000 database without using Data Sources (ODBC) like on access. Code:
et db=server.createobject("ADODB.connection")
db.open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="+server.mapPath ("db1.mdb"))
so anybody have an idea about the code>?
i have uploaded my files and now it comes up with a 500 error message. what i did was when i started bulding the site i used dreamveaver and its dsn connection and its features but now i need to change the dsn connection on the relevant pages to direct connection and i am very very confused how i will do this and as an amature i need help. to start of my default.asp uses dsn conection can you show me all the sections i need to change.i have attached a txt file that contains all the code in my default.asp page.
View Replies View RelatedI wanted to know wheather DSN is ok for the connection to a database or direct conection is better?
when i started my web project on dreamweaver i had to make a DSN connection as i have followed the books, but as now as i have also asked several questions on this site, i have aslo implemented a direct connection as well on some pages, now i am wondering
is this going to have any affects when i uplode the complete site on the server.
i have noticed that on my computer when i am testing the site and uploading new records on sections that have DSN connections you can see the new record but on sections that i have implemented direct connection i cannot see it coz it is linked to the local directory database not on the testing server.
i have also never experienced uploading to a IIS server with DB connection so its my first time with dynamic websites. so am i in trouble or its ok the way i have done my site..
how can i make connection using mySQL with asp?
View Replies View RelatedI am using server side javascipt and want to do a redirect to another asp page passing parameter values using the POST method. This redirect needs to occur if an else statement in my code is reached. I need to have a function which does this redirect to the other asp page, passing the parameters via POST.
View Replies View Relatedcan i directly mail to hotmail or yahoo acount with any asp.net code.
i have an example like above but i need smtp adress for hotmail, i tried it for smtp.mail.yahoo.com but it didnt work and "authentication required" error accured
here is the code: ....
I have an asp page which basically takes some data from a previous
page form and inserts the data to my database and then does a
re-direct to:
Response.Redirect "JS_Create.asp"
On this page is just an animated logo saying something like 'Loading
Data ....'
On this asp page JS_Create.asp I have another re-direct handled by a
timer to go to JobSheet.asp.
The idea is that the user enters data into the form, if the form is
validated correctly, they are transferred to the next page which tells
them the data is loading. They are held there for say 3 to 5 seconds
and then transferred to the final page JobSheet.asp.
The code I have on JS_Create.asp for the timed re-direct is: Code:
I have a web site in asp where I do not want the users to
directly type in the URL
of some pages in the browser. For e.g. the main page
is 'index.asp' and depending on
the users resolution either 'mypage1024.asp' or
page 'my800.asp' would open up in the
browser.
What I want is that no user should be able to directly
access the page by typing in
the URL www.mysite.com/page1024.asp or
www.mysite.com/800.asp. If a user
tries to access these pages directly then they should be
forcefully redirected to the
home page www.mysite.com/index.asp and this page would
check the resolution
and load the 'mypage1024.asp' or 'mypage800.asp' depending
I have used ASP to force a user to log on to a page prior to allowing them to see a page including images. However, once a person knows the URL to the image on its own a person can type in that full URL and see the image, without being logged in.
For example, password login required to get to:
http://www.mydomain.com/showmypics.asp
But, you can navigate straight to:
http://www.mydomain.com/pictures/mypicture.jpg
how to prevent a user going to the picture directly?
I have a page with a div tag styled in this div is a list of projects pulled from a db.
text-align: middle;
clear: both;
overflow: auto;
width: 95%;
height: 175px;
This means that the content in the div tag when larger than the div height has a scroll bar at the side to view all the projects. Once the projects area displayed there is a image at the end of each row that when clicked goes to the db and pull back reports for that project. This is all done by passing vars in the querystring pulling info from the db and writing out the appropriate code. Code:
I ám looking for print function in ASP and/or Javascript which can print without pop up the page just as desktop application did. so when you click the print button it will directly print without open a page.
View Replies View Relatedi was hoping to include a 'page direct' function into this if-then statement below. I want the user who is logged into the session to be directed automatically to the purchase.asp page. I know the goto statement is wrong here. Any suggestions on what I should be using unstead?
<%
if session("name") <> "" then
goto "purchase.asp"
else
response.write "You must log in to buy views.<p>"
end if
%>
I have a page that logs the user in (the code will be below). When they log in correctly, or even incorrectly, they get directed to default.asp. The login is working correctly however because when I log in with a false name and password I cannot proceed to checkout. How can i direct the user (ONCE they are signed in correctly) to a customer page(custpage.asp) instead of my homepage(default.asp)? Code:
View Replies View RelatedBasically I have something that needs to be installed in the htdocs in order for me to use it - however i need to be able to access something thats in the private dir on the same dir.
Dirs go like
/whateverftp/
/whateverftp/private/
/whateverftp/htdocs/
obv Const DB_FOLDER_PATH = "/whateverftp/private/" wouldn't work, what would I put in there in order to gain access to the private dir?
I have a 'primary' intranet website and a 'secondary' backup of this site as
well. I would like to programmatically have the effect that if the
primary site is (page not found 404) not available, for it to access the
secondary site or at least be able to add a message with (or instead of) the
404 error dialog that the primary site is down and give the user a link to
the alternative (secondary) site.
If you have a directory of pdf files, how can you prevent someone from typing in www.yoursite/pdf_folder/some_file.pdf and getting that file? You could write a login script but if they know the path to the pdf, they could get it. I want to prevent people from doing this.
View Replies View RelatedI have an email containing link say (somelink.asp) A user clicks on this link (say from outlook). because this user is not logged into the site, the request goes to somelink/login.asp.
The user then logs in. After successful login I would like to take this user to the link he clicked on originally. Is this possible without having to pass the lionk url as part of the query string?
Is there a way where I can prevent people from downloading a file using a direct link (or bookmarked) (i.e. http://www.myfile.com/file.csv)? I want my user to log in with their email address so I can keep track of who downloads my files and when.
I already wrote a filedownload.asp file already which tracks and logs users who downloads the file. But I made a mistake in giving out the direct links to people already. So now people are using that direct link which bypasses filedownload.asp file. If there are any techniques on doing this.
1.
conn.ConnectionTimeout = 60
conn.Open connString
2.
conn.Open connString
conn.ConnectionTimeout = 60
Do both of them give different?
I changed domains on a site - I would like a re-direct errorpage script that re-directs from:
www.originaldomain.com/page.asp?a=26
To new:
www.newdomain.com/page.asp?a=26
Is this possible? (all page ids are the same in the old and new). As it is now, I just have a simple re-direct that goes to the mainpage no matter which page people are coming from.
How can I make a ASP-file to a .DLL? The idea is to protect the source from others who use the same IIS. Can I make a ASP-file that calls a .DLL - file with all functionality, or how does it work?
View Replies View RelatedHi does anybody know if you can make a form
have two actions and how?
how to format the table in order to show 23,567,987 instead of 23567987 , I mean it's very hard to read when there are more than 4 digits.
View Replies View Relatedwhen you click on it to go to the off site the user name and password will be automaticly inserted to where the offsite is asking for the name and password.
My company deals with insurance companies and we would like to make it to where when our employees go to our intranet and click on a link to one of our carriers it will have the name and password in place for them. i heard its possible and old company did it but I am having so much trouble trying to figure this out.
Its the first time I use ocx on my asp pages. Say I have an ocx which is a dropdown with multiple columns. Before its displayed, I call a method to populate the pulldown, so how do I make the script block talk to the html?
'script block
<%
dim myObject
set myObject=server.createObject("myObject.pulldown")
myObject.Populate(.....)
%>
'HTML block
<Html>
<OBJECT ID="MyObject1" CLASSID="CLSID:12345678-8AB4-4230-A65E-DA15A40F9900"></OBJECT>
I want to know how to make a match for a text , for I'm wan't to search for this in the db . the search i made search only for the exact text user inserted so if the user misspelled the word the search will give him zero result. So i want to seach for any part of the word or if it is aword in aphrase.
View Replies View RelatedWhen you hover over one of the topic in this forum a box appear with the first few lines of the message in it. How is this created. What events area used to creat something similar and does anyone know of any good website where i can look at a tutorial for it.
I dont even know what they are called so dont know what to search for even on the web as if i write pop up i get something else which i dont think is what i really want to use, or maybe it is.
how to make the session timeout. and where should i put the session timeout.
View Replies View RelatedI have Windows 2000 Server. Running IIS 5. I created a ASP file that connects to a database and when i go to view it, It either says that there is a error in the code on like 106.
Which is only an "End If" command, Or it will say that this page needs to be posted on a web server that supports ASP. Well.. I have indexing service running, And I know for a fact that the code in the page is correct because it works on other 2000 server.
I have a webapp. that holds a lot of documents. Some of the documents needs to be produced from a database on-the-fly, some are static documents like PDF, Word documents, etc... In the end, a user can do a request to produce a large amount of documents as one huge PDF document. Today the creation of documents is working, but all code is done in ASP.
In Visual Basic, I was thinking about making an ActiveX EXE server that generates the PDF document. The ASP page will be polling until the file is generated. When this is done, the file will be displayed. I have only written down my thoughts on the subject. Is there a good way to do this?
how to off the html in the textarea or text box. so if user write an html code in textbox or textarea , would.nt make the page changes. like this add thread how about if i wrote an html like </table>, it will make the display page change.
View Replies View RelatedIs it possible to make a cookie NEVER expire? or not?
View Replies View RelatedHow to use asp to populate checkboxes from a column in an Access table? I want them to be updated when the table is updated.
View Replies View Related