|
 |
asp_databases thread: Global.asa Variables
Message #1 by Farid Attamimy <Farid.Attamimy@a...> on Mon, 29 May 2000 14:08:10 +0700
|
|
Hi Friends,
In my Global.asa file I have codes like this :
Sub Application_OnStart()
Application("strSQLPassword") = "pwd~2000"
Application("strSQLUserName") = "applogin"
Application("strSQLServerName") = "devsql"
End Sub
And in my ADO Connection String I have code :
<%
sConn = "Provider=SQLOLEDB;Data Source=devsql;Initial
Catalog=DBWorld;User ID=applogin;password=pwd~2000;"
set conn=server.createobject("adodb.connection")
conn.open sConn
%>
How to put the variables that I have state in my global.asa file into my ADO
Connection String ...?
Message #2 by "Ken Schaefer" <ken.s@a...> on Tue, 30 May 2000 09:51:45 +1000
|
|
sConn = "Provider=SQLOLEDB; Data Source=" & Application("strSQLServerName")
& "Initial Catalogue=DBWorld;User ID=" & Application("strSQLUserName") &
"etc...
Why don't you just put the whole connection string into one application
variable though?
Cheers
Ken
> Hi Friends,
> In my Global.asa file I have codes like this :
>
> Sub Application_OnStart()
> Application("strSQLPassword") = "pwd~2000"
> Application("strSQLUserName") = "applogin"
> Application("strSQLServerName") = "devsql"
> End Sub
>
> And in my ADO Connection String I have code :
>
> <%
> sConn = "Provider=SQLOLEDB;Data Source=devsql;Initial
> Catalog=DBWorld;User ID=applogin;password=pwd~2000;"
> set conn=server.createobject("adodb.connection")
> conn.open sConn
> %>
>
> How to put the variables that I have state in my global.asa file into my
ADO
> Connection String ...?
>
>
>
Message #3 by "Robert Larsson" <robert.l@m...> on Tue, 30 May 2000 10:01:42 -0700
|
|
<%
sConn = "Provider=SQLOLEDB;Data Source=" & Application("strSQLServerName")
& ";Initial"
Catalog = "DBWorld;User ID=" & Application("strSQLUserName") &
";password=" & Application("strSQLPassword") & ";"
set conn=server.createobject("adodb.connection")
conn.open sConn
%>
Mvh,
Robert Larsson!
Web-production Coordinator
---------------------------------------------------------------------
Mindflow AB | www.mindflow.se | 08-545 635 10
----- Original Message -----
From: "Farid Attamimy"
To: "ASP Databases" <asp_databases@p...>
Sent: Monday, May 29, 2000 12:08 AM
Subject: [asp_databases] Global.asa Variables
>
> Hi Friends,
> In my Global.asa file I have codes like this :
>
> Sub Application_OnStart()
> Application("strSQLPassword") = "pwd~2000"
> Application("strSQLUserName") = "applogin"
> Application("strSQLServerName") = "devsql"
> End Sub
>
> And in my ADO Connection String I have code :
>
> <%
> sConn = "Provider=SQLOLEDB;Data Source=devsql;Initial
> Catalog=DBWorld;User ID=applogin;password=pwd~2000;"
> set conn=server.createobject("adodb.connection")
> conn.open sConn
> %>
>
> How to put the variables that I have state in my global.asa file into my
ADO
> Connection String ...?
>
>
>
|
|
|
View Cart
