Re: [Emerald] SQL Server 7.0 Internet Connector and Emerald

Dan Tang ( (no email) )
Wed, 2 Jun 1999 22:36:18 +0800

If you are not using IDC files you do not need 'Internet Connector', but you
need to have a global.asa file which can be created through Visual InterDev
at design time, which will verify the run time username and password, some
thing like that:

<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Session_OnStart
'==Visual InterDev Generated - DataConnection startspan==
'--Project Data Connection
Session("Emerald_ConnectionString") =
"DSN=Emerald;SERVER=DIALUP;UID=sa;APP=Microsoft (R) Developer
Studio;WSID=PUBLISHER;DATABASE=Emerald"
Session("Emerald_ConnectionTimeout") = 15
Session("Emerald_CommandTimeout") = 30
Session("Emerald_RuntimeUserName") = "********"
Session("Emerald_RuntimePassword") = "************"
'==Visual InterDev Generated - DataConnection endspan==

'==Master Account Info
Session("CustomerID")="0"
Session("FirstName")=""
Session("LastName")=""
Session("Company")=""
Session("Address1")=""
Session("Address2")=""
Session("Zip")=""
Session("HomePhone")=""
Session("WorkPhone")=""
Session("Fax")=""
Session("PayPeriod")=""
Session("SalesPerson")=""
Session("emailaddress")=""
'==Sub Account Info
Session("Username")=""
Session("Password")=""
Session("ConfirmPassword")=""
Session("AccountType")=""
Session("OSType")=""
Session("NetSoftware")=""
Session("ModemType")=""
Session("sPhoneWork")=""
Session("sPhoneHome")=""
Session("MaidenName")=""
Session("SubAccountID")=""

'== User Home Page Prefix
Session("HomePagePrefix")="http://www.dmn.com.au/"
'== User FTP Server Prefix
Session("FTPSvrPrefix")="ftp://ftp.dmn.com.au/"

'== Windows NT Server Shared Directory for Stored Procedure WebSignUpSub
'== As Home Directory of www.dmn.com.au.
'== Will move home page to other server like ISP.dmn.com.au later
Session("PrefixFTP")="\\ftp\hosting\~"

'== User Default Home Page. Which will be copied to new user FTP directory
when customer create their account
Session("UserDefaultHomePage")="\\ftp\hosting\UserHomePage.htm"

'== Web Server Address
Session("WebServerAddress")="http://www.dancomputers.com.au/"
Session("TemporaryExtendDay")=1

End Sub
</SCRIPT>

Regards,

Dan Tang
Network Operation
Domain Internet Access
---------------------------------------------------
Sign Up a Dial up account at http://isp.dmn.com.au and get connect right
now.
Free web hosting for commercial customers.
---------------------------------------------------
Join the Emerald ASP Addon Product mailing list
by sending email to emerald-request@dmn.com.au with message body SUBSCRIBE
only