<% '***************************************************** '* Milk Group '* Copyright WozzaWorks, 2006 '***************************************************** '********** USER CONFIGURABLE GLOBALS - MODIFY AS NEEDED FOR YOUR INSTALLATION ********* ' connection string for MS Access. dim sDBCONNSTR 'sDBCONNSTR = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & server.mappath("\ourwebsurvey\db\OWS.mdb") & ";" ' if database is outside web root (better for security) use the approach below 'sDBCONNSTR = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\Sitedata\questions\Inetpub\ftproot\database\OWS.mdb;" const strDatabase="db_milk" 'Database name const strSQLUID="usr_RawM1lk" ' SQL Server user const strSQLPwd="pwD_Raw5" ' SQL Server password const strSQLServer="localhost" ' SQL Server name or IP address const strSQLDriver="MySQL ODBC 3.51 Driver" 'MySQL driver sDBCONNSTR = "DRIVER={MySQL ODBC 3.51 Driver}; Server=" & strSQLServer sDBCONNSTR = sDBCONNSTR & ";Database=" & strDatabase sDBCONNSTR = sDBCONNSTR & ";UID=" & strSQLUID sDBCONNSTR = sDBCONNSTR & ";PWD=" & strSQLPwd sDBCONNSTR = sDBCONNSTR & ";option=NUM"' ' modify below depending upon where the survey software is situated under root web Const adCmdStoredProc = 4 ' selective const from standard ADOVBS.INC Const adInteger = 3 Const adCurrency = 6 Const adParamInput = 1 Const adParamOutput = 2 Const adExecuteNoRecords = 128 Const adParamReturnValue = &H0004 '********** END SYSTEM GLOBALS ********* %>