Our ASP web application uses connection object from global.asa.
We hard coded Uid and pwd in global.asa.
Is there any way we can encrypt this Uid and Pwd in global.asa, or can
we access them through environment variables, if so can some one give me a
sample of code( to access environment variables through asp code.)
Is there any way to attain the names of the tables in a database from using
either ADO connection or ODBC or any other type of connection.
The reason I wish to do this is so that I can display all the information in
table (field names and values - this piece of code works) from a dynamic
SQL statement.
Here is what I am trying to do:
<%
Connect to my_table.
%>
<select>
<%
For each Table in My_table
response.write "option value='" & table.name& "'>" & table.name & "</option>
Next
%>
</select>
Is this possible?
Im doing a login page for my website, and it seems i have to do this:
'Database connection info and driver
strCon = "DRIVER={Microsoft Access Driver (*.mdb)};uid=;pwd=letmein; DBQ=" & Server.MapPath(strAccessDB)
What the hell is that? Do I just put the physical path of my DB in there?
I'm new to asp and I was told that I need a global.asa file in order to connect to a db (within our intranet).
okay, great fine...now I have an 'example' of a global.asa file. now, how do i go about connecting to a db from my asp page using this global.asa file?
i am making a site using asp. in this i am using mssql server2k as backend. i ve created a dsn. i want use global.asa file for creating connection object so that i don't ve to create con object in every .asp page. for that i ve write following code
<script language="vbscript" runat="server">
sub Application_onStart()
set con=server.createobject("adodb.connection")
con.open "dsn=pc;uid=sa;pwd=;database=dbname"
end sub
sub Application_onEnd()
set con=nothing
end sub
sub Session_onStart()
end sub
sub Session_onEnd()
end sub
</script>
now anyone tell me how to use that connection object in any asp file for fetching the recordset.
I currently have my SQL Server connection string in an Application variable in the global.asa. Could that be a security risk? I have heard that with Cold Fusion, when there is a page error. the actual Connection String is written to the screen as part of the error page.
I'm quite sure that would not occur in ASP but just wanted to be sure, and get a few expert opinions.
I was looking at another post, and what the person did was:
Dim strConn
strConn = "string"
application("strConn") = strConn
Now, am I able to create a connection object in my global.asa like so, and then keep my existing syntax for all my hundreds of queries?
Dim strCon
strCon = string
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open strCon
?
I'm trying to SAVE bandwidth, so I want to create my connection in global.asa instead of each time my include file 'top.asp' is executed. I can also close it easily...
PS. I believe Application_OnStart() is the best place to put it, am I correct?
1. Connection strings need to be in global.asa file always?
2. How can we encrypt the connection string userid and passwd in global.asa?
I have actually an asp web site which use the global.asa file to connect to
the database but for security reason, I want to put username and password
information (or the complete connection string) in a seperate file so only a
special user could read these informations.
I have one application folder containing all ASP code files. I want host multiple sites pointing to same code. Can I do this ? If YES then how I can assign diffrent global.asa to each application...
View Replies View RelatedI have added a db driven marquee to my site and need to combine the global asa's to 1 global asa file. Code: ......
View Replies View Related1.
conn.ConnectionTimeout = 60
conn.Open connString
2.
conn.Open connString
conn.ConnectionTimeout = 60
Do both of them give different?
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..
Is asp.net similar to vb.net ? What can you create with it ? ,Is there a program you suggest me to use , or even a compiler ?
View Replies View RelatedI need to know where I can get information about learning how to code in ASP. This getting cide snippets and such doesn't work out real well if you don't know what to configure. Also I would like to have my own work not someone elses.
View Replies View RelatedIn different examples I've seen different ways to do the same thing, and I want to know what is best (fastest, easiest to remember, same command for all types of stuff, etc)
For example, to get data from a database, should I use:
[VBS]set rs = conn.execute sqlstmt[/VBS]
or
[VBS]rs.Open sqlstmt, conn[/VBS]
or something else?
what can i use to get my server's ASP information, like with PHP you can use:
PHP Code:
<? phpinfo(); ?>
What can i use in ASP?
I have a form that I use a few option selections from DB table and a insert script at the end.I'd like to have access to aditional info from the same table after choose an option
View Replies View RelatedI am trying to retrieve data from a dropdown listbox in asp using:
<%Response.Write + Request.Form("cboBox")%>
The problem is that I only retrieve the first value of the option. For
example, if my first option was <option value=this that>, I only can
retrieve "this". It won't get the second word.
Recently, I came across a site with information to my area of knowledge. The pages have been designed and consist of the .asp extension in the url.
I'm not able to select the text on the web page, either click right mouse button or anything to copy the information. when I'm trying to print it is not perfect.
So, I would like to know from ASP guru's whether there is any way of saving the information on the web pages, so that the same can be formatted in a word document for printing purpose.
My web site is windows authenticated.
When someone connect to my site, I get his SID with a small active X object
which uses OpenProcessToken and GetTokenInformation (token user etc ...
But now, I also need the SID list from AD user object SIDHistory. (when a
user is moved across domain).
I've got a WYSIWYG editor, that runs off a template page (i.e. template.htm) that gets opened in an iFrame for editing.
How can I get it setup so I cange the template at the click of a button? I've tried doing a form with radio buttons, but can't get it to work.
For example, the iframe source has been set to "strTemplate". My form processing was along the lines of:
<%
If request.form "template" = "template1" then
strTemplate = "template1.htm"
Else
strTemplate = "template.htm"
If request.form "template" = "template2" then
strTemplate = "template2.htm"
Else
strTemplate = "template.htm"
End If
End If
%>
Anyone have anything like this? I don't care what data it is... I just want
to see how to query the AD and place the data into a web page.
Basically I want to be able to send users (if they sign up to it) an SMS alert whenever someone leaves them a message on a webpage. Similar to Hotmail where you can get an SMS when you receive an email, or Ebay where you can get alerts if you are outbid.
I'm thinking maybe something very similar to CDO in terms of coding Code:
im running an asp page where by i can upload a xls file- which adds data to a database provided it passed validation. this then sends a success message to the user. what i need is a button where i can call the data which was recently added into the database- but dont know how to go about it or code.
View Replies View RelatedI am using :
<% FOR EACH field IN size_info.FIELDS
Response.write("<option value=''>" & replace(field.name, "asize", "") & "</option>")
NEXT%>
to loop the names of the fields in a DB, but I cannot get it so that is the value of the data in that field is lower than 5 it simply doesn't show, i thought i might be this
<% FOR EACH field IN size_info.FIELDS
if size_info.fields.name.value > 0 then
Response.write("<option value=''>" & replace(field.name, "asize", "") & "</option>")
end if
NEXT%>
but that doesn't work.
Is this the right forum for this. Considering using this but not sure, specially considering the price and I would need to add a host. If you have any knowledge please let me know. Also if this the right forum, also let me know and I will give more details. It is an ASP program of course.
View Replies View RelatedCurrently I have one asp page which opens after the proper ID entered by user and it generate <A> tag with application software download link. When the user click on the link (which is pointed to the actual physical file.EXE of Size around 10 - 20 MB) it downloads file. But how do i change the logic so that the activity will get LOG in some text file. Like which user has downloaded which file. (it should log into text file).
I think I need to remove the <A> for direct download instead it shoudl call an asp page whcih should log the event and push the file to user.suggest with sample code if possible.
How can I get ASP and IIS version info?
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.
I am working on a users system for my site. I have the databases and most of the pages set up. But, I need to create a page called "My Info". This page would display only the information of the person that is logged in.
I am curious as to how I would retrieve only one entry in an access database and display it based on the person logged in.
anyone know how to update the inforation in a select box without refreshing the page or using massive javascript arrays using regular asp(not .net)?
View Replies View RelatedI have an intranet site hosted in IIS 5.0 Win2000, and want to display the name of the user logged into the local machines(WinXP) in the pages they access like 'Welcome JohniBravo'.
So, i used the Request.ServerVariables("LOGON_USER"), but get a blank ("") displayed in the page. And i even tried "REMOTE_USER" but, still the same. from somewhere i got to know that theres something called 'Allow anonymous user' should be enabled to get these info from servers. help me with the same?