Platform SDK: Team Productivity Update

Save Configuration Values into Instance Database

Here the configuration values are saved into the new instance database.

' Save config values into new instance database
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.ConnectionString = "Provider=sqloledb;" & _
    "Data Source=(local);" & _
    "Initial Catalog=" & DatabaseName & ";" & _
    "Trusted_Connection=yes;"
oConn.Open
Call oConn.Execute("EXEC sp_Expense_Configuration_Insert " & _
    "'" & AccountsPayableNTUsername & "', " & _
    MileageRate)
oConn.Close
Set oConn = Nothing