Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Setrting the connection to DB in the global.asa
- Thread starter DREAMaker
- Start date
corrected your english:
But what I don't understand is how to set it in a global.asp and then call it in my page...
You might use an Include
Here is an Example:
<html><head>
<TITLE>includedynamic.asp</TITLE>
</head><body bgcolor="#FFFFFF">
<%
whichfile="bookscifi.asp"
Call ReadDisplayFile(whichfile)
response.write "<hr>"
whichfile="bookhorror.asp"
Call ReadDisplayFile(whichfile)
response.write "<hr>"
whichfile="/learn/test/bookmarketing.asp"
Call ReadDisplayFile(whichfile)
response.write "<hr>"
%>
</body></html>
<%
SUB ReadDisplayFile(FileToRead)
whichfile=server.mappath(FileToRead)
Set fs = CreateObject("Scripting.FileSystemObject"
Set thisfile = fs.OpenTextFile(whichfile, 1, False)
tempSTR=thisfile.readall
response.write tempSTR
thisfile.Close
set thisfile=nothing
set fs=nothing
END SUB
%>
[sig]<p>DougP, MCP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.[/sig]
But what I don't understand is how to set it in a global.asp and then call it in my page...
You might use an Include
Here is an Example:
<html><head>
<TITLE>includedynamic.asp</TITLE>
</head><body bgcolor="#FFFFFF">
<%
whichfile="bookscifi.asp"
Call ReadDisplayFile(whichfile)
response.write "<hr>"
whichfile="bookhorror.asp"
Call ReadDisplayFile(whichfile)
response.write "<hr>"
whichfile="/learn/test/bookmarketing.asp"
Call ReadDisplayFile(whichfile)
response.write "<hr>"
%>
</body></html>
<%
SUB ReadDisplayFile(FileToRead)
whichfile=server.mappath(FileToRead)
Set fs = CreateObject("Scripting.FileSystemObject"
Set thisfile = fs.OpenTextFile(whichfile, 1, False)
tempSTR=thisfile.readall
response.write tempSTR
thisfile.Close
set thisfile=nothing
set fs=nothing
END SUB
%>
[sig]<p>DougP, MCP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.[/sig]
crystalized
Programmer
When you use Visual Interdev it constructs the connection in the global.asa for you. Here is what it put in mine:
Replace any of the values you need to replace in particular the things I put into <>. Now admittedly I am not that great with all the connection stuff in ASP since I have been utilizing the tools Interdev provides so I don't know if all of this is necessary, or if it is well done. I don't think the actual connection is made here but the stuff to make the connections is all set up. I know that I used the connection string in the one connection that I needed to create. [sig]<p>Crystal<br><a href=mailto:crystals@genesis.sk.ca>crystals@genesis.sk.ca</a><br><a href= > </a><br>--------------------------------------------------<br>
Experience is one thing you can't get for nothing.<br>
-Oscar Wilde<br>
[/sig]
Code:
'==Visual InterDev Generated - startspan==
'--Project Data Connection
Application("NetworkDB_ConnectionString") = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=<username for development here>;Initial Catalog=Network;Data Source=<servername here>;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=<SERVERNAME HERE>;"
Application("NetworkDB_ConnectionTimeout") = 15
Application("NetworkDB_CommandTimeout") = 30
Application("NetworkDB_CursorLocation") = 3
Application("NetworkDB_RuntimeUserName") = "<USERNAME RUNTIME HERE>"
Application("NetworkDB_RuntimePassword") = "<RUNTIME PASSWORD>"
'-- Project Data Environment
Set DE = Server.CreateObject("DERuntime.DERuntime")
Application("DE") = DE.Load(Server.MapPath("Global.ASA"), "_private/DataEnvironment/DataEnvironment.asa")
'==Visual InterDev Generated - endspan==Replace any of the values you need to replace in particular the things I put into <>. Now admittedly I am not that great with all the connection stuff in ASP since I have been utilizing the tools Interdev provides so I don't know if all of this is necessary, or if it is well done. I don't think the actual connection is made here but the stuff to make the connections is all set up. I know that I used the connection string in the one connection that I needed to create. [sig]<p>Crystal<br><a href=mailto:crystals@genesis.sk.ca>crystals@genesis.sk.ca</a><br><a href= > </a><br>--------------------------------------------------<br>
Experience is one thing you can't get for nothing.<br>
-Oscar Wilde<br>
[/sig]
Once again, having ADO objects at the application and session level is not recommended (even microsoft advises against this at their top-25-asp-tips page) because of how the underlying threading model works for asp. Setting the connection string at this level is probably OK however.
You can read more about this at:
[sig]<p>--Will Duty<br><a href=mailto:wduty@radicalfringe.com>wduty@radicalfringe.com</a><br><a href= > </a><br> [/sig]
You can read more about this at:
[sig]<p>--Will Duty<br><a href=mailto:wduty@radicalfringe.com>wduty@radicalfringe.com</a><br><a href= > </a><br> [/sig]
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question