<%
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'Reference:			M-WEB SafeShop 2 Add-ins
'
'Version:			1.0
'
'Description:		This script contains the required DSN information to access 
'					your database as well as the Connection Declarations and 
'					initiations.
'
'Note:				This is the connection script and must appear at the top of 
'					all the ASP pages
'
'Usage:				Copy Connect.asp to the "Include" folder in the web root
'					At the top of your ASP file include the following line:
'					<!-- #INCLUDE FILE="Include/Connect.asp" -->
'					
'Features:			myStore is the store number
'					myUserName is the username for the store
'					myPassword is the password for the store
'					mySQLServer is the DNS name or IP address of the Database
'
'Contacts:			pparent@mweb.com
'
'Author:			Pascal Parent
'Date:				18/02/2001
'Last Modified by:
'Last modified on: 
'
'''''''''''''''''''''''''''''''''''''''''''''''''''

myStore		= "401541"
myUserName	= "wesleys.co.za"
myPassword	= "weswes"
mySQLServer	= "safeshopDB.mweb.co.za"

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.ConnectionString  = "Provider=SQLOLEDB.1;Password=" & myPassword & ";Persist Security Info=True;User ID=" & myUserName & ";Initial Catalog=Store_" & myStore & ";Data Source=" & mySQLServer

'oConn.Open
%>