Direct Connection
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
ADVERTISEMENT
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>?
View Replies
View Related
I 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..
View Replies
View Related
I 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 Related
can 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: ....
View Replies
View Related
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:
View Replies
View Related
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
View Replies
View Related
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?
View Replies
View Related
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:
View Replies
View Related
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 Related
i 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
%>
View Replies
View Related
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 Related
Basically 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?
View Replies
View Related
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.
View Replies
View Related
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 Related
I 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?
View Replies
View Related
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.
View Replies
View Related
1.
conn.ConnectionTimeout = 60
conn.Open connString
2.
conn.Open connString
conn.ConnectionTimeout = 60
Do both of them give different?
View Replies
View Related
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.
View Replies
View Related
I am trying to create a web page that has a drop down menu in which it retrieves data from our SQL server. Maybe this is a bit more simple than I am making it but I am really pulling my hair out trying to get this right. Code:
View Replies
View Related
this is my error:
[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.
here is my db connection string:
<%@Language=VBScript%>
<!--#include file="adovbs.inc"-->
<%
dim rs, cn
Set cn = Server.CreateObject("ADODB.Connection")
'with cn
' .Provider="Microsoft.jet.oledb.4.0"
' .ConnectionString=Server.MapPath("home/nfiweb.mdb")
' .Open
'end with
cn.open "nfijobs"
set rs = Server.CreateObject("ADODB.Recordset")
%>
View Replies
View Related
When I click submit after updating the information all of my info gets deleted from the db so I'm guessing that the values that are being submitted are not getting picked up in the sql. I've tried changing the form names, etc, but still have the same prob. My code is below: Code:
View Replies
View Related
I am having trouble connecting to an Access db fro mmy asp page. I get the following error: The page cannot be displayed There is a problem with the page you are trying to reach and it cannot be displayed. Code:
View Replies
View Related
I'm using an SQL2K backend and attempting to connect to it with the following code.
' -- Connection String Value
response.write "Setting strConnection"
strConnection = "DSN=tracktimedb"
' -- Our SQL Statement
response.write "Declaring SQL Statement"
strSQL = "SELECT * FROM TIMES"
' -- Populate our Recordset with data
Set objRS = GetRecordset(strConnection, strSQL)
I have done many searches but all the connection strings I've found seem to be using a DSN to an access DB. Currently I get this error when trying to connect.
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I can't seem to find the proper syntax to specify a db login (sa) and password in the connection string.
View Replies
View Related
on 1 page i open
a connection to a database and build a recordset to check
username and password. there are other fields in the db
that i need to access on the next page. how do i reference that
connection and run a new sql query without having to reopen the connection?
i thought it would be as simple as NOT closing it, but thats not working.
View Replies
View Related
I am having problem in my connection to database when running ASP.
It works fine for the first time but if I run it again without a gap of atleast a minute,
it gives me the following error message:
Error Type:
Provider (0x80004005)
Unspecified error
And the line it is showing error is where I am opening my database connection using conn.open.If I wait for couple of minutes and run again,it works fine.
View Replies
View Related
I'm trying to maintain a permanent tcp/ip connection between two
computers using ASP. I need users accessing the ASP pages to be able
to send and receive messages using this connection. I know that I
can't use a Winsock control with ASP so I guess I'm looking at a third
party control. Even if I can get this working I'm not sure that I can
have different users accessing this one permanently open connection.
I've looked all over the Net for ideas on how to do this but I've had
no luck. Has anyone had to do anything like this?
View Replies
View Related
I am trying to establish an ODBC conection to ORACLE 10g and have tried all the following. Please advise:
We are trying to connect to a 10 g server and nearly gone crazy after doing so. tried everythign, DSN, DSN less .... The bottom line the connection is successful when we try it form the control panel-> data source thing but not from ASP. We tried the following things: Code:
View Replies
View Related
I created a master detail page using the wizard in Dreamweaver, however I need to create a DSN-less connection. How do I do that? I am assuming I need to edit this part of my code:
View Replies
View Related
Can anyone help me create a dsn less connection to the sql server 2005 db
from the connection.asp file below please,
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
Dim MM_TobiasNET_STRING
MM_TobiasNET_STRING = "dsn=TobiasNET;uid=sa;pwd=*******;"
%>
Need detailed explanation if poss or even better an example.
View Replies
View Related
Need to implement an online payment facility, which requires SSL
encryption. I have bought the keys and they are installed on the server
(IIS5)
Can anyone point me in the right direction for help in activating the SSL
encryption using asp - tutorials or sample scripts etc?
View Replies
View Related
I am getting 500 Internal Server Error. I have tried disabling the show
friendly error in IE and I have tried it on Firefox. It will not give me the
reason why it will not work, I only get 500 Internal Server Error.
I have tested the code up to the point of Set objConn and it works but when it gets
to the objConn.open dsn that's when I get the error. I wish to find out why
it is not allowing it to get pass this point. I have control of the server
where this is hosted and if there is anything I need to do, I can do it.
View Replies
View Related
I am trying to create a web page on our company intranet.I am using Frontpage 2000.I need to be able to read from and write to databases in this project.I am starting slow since I am just learning, so for now I am trying to read from an existing SQL database on a network server. The server is running SQL Server 2000 and IIS.
I could create a database connection using the Database Results Wizard in FP. The connection would verify OK and I could select the columns from the table I wanted to display. When I published the page to the server, all I got was column headings, no data.
when I try to create a new db connection, it will verify, but it will not show up as an existing db connection.
View Replies
View Related
