connecting to 2 seperate servers

[jmaresca2005]

i have an asp project in which i need to connect to 2 seperete servers. 1 is the webserver that is outside the network the other is a db server that is in the network. the asp pages need to be on the webserver while i retrieve data from the db server that resides on the netwrok. how to i get the connection string to connect to both databases. im sure i have to code for it in the global.asa and the asp page itself. any help would be appreciated.

i tried this code but it still doesnt work: global.asa. i emoved info for security reasons, obviously.

Sub Application_OnStart
dim rsTemp, dicTemp
Application("Server") = ""
Application("Server") = ""
Application("UserID") = ""
Application("PWD") = ""
Application("DBName") = ""


Application("Conn_ConnectionString") = "Provider=SQLOLEDB.1;Password=;Persist Security Info=True;User ID=;Initial Catalog=;Data Source="





End Sub
Sub Application_OnStart
dim rsTemp, dicTemp
Application("Server") = ""
Application("Server") = ""
Application("UserID") = ""
Application("PWD") = ""
Application("DBName") = ""

Application("Conn_ConnectionString2") = "Provider=SQLOLEDB.1;Password=;Persist Security Info=True;User ID=;Initial Catalog=;Data Source="

[jmaresca2005]

i got it!!!