Simulating Stored Procedures in Microsoft Access using Enterprise Library Application Blocks

To Convert to SQL:

1. Create a Database called: EDAB_Example

2. Create a user in the database called: "EDAB_User" with the password: "password12"

3. Locate the "EDAB_Example.sql" file in the "SQL_Scripts" directory and runn the script to create the Addresses table and the stored procedures.

4. In the "dataConfiguration.config" file (in the main directory) find the following lines and update them if you need to:

        <connectionString name="Sql Connection String">
          <parameters>
            <parameter name="database" value="EDAB_Example" isSensitive="false" />
            <parameter name="Integrated Security" value="False" isSensitive="false" />
            <parameter name="pwd" value="password12" isSensitive="false" />
            <parameter name="server" value="(local)" isSensitive="false" />
            <parameter name="uid" value="EDAB_User" isSensitive="false" />
          </parameters>
        </connectionString>

5. Find the following lines in the "dataConfiguration.config" file (in the main directory):

      <instances>
        <instance name="SQL_CurrentInstance" type="Sql Server" connectionString="Sql Connection String" />
        <instance name="CurrentInstance" type="OleDB" connectionString="OleDB Connection String" />
        <instance name="OleDBInstance" type="OleDB" connectionString="OleDB Connection String" />
        <instance name="SQLInstance" type="Sql Server" connectionString="Sql Connection String" />
      </instances>

6. Change:

	<instance name="CurrentInstance" type="OleDB" connectionString="OleDB Connection String" />

	to

	<instance name="Old_CurrentInstance" type="OleDB" connectionString="OleDB Connection String" />

7. Change:

	<instance name="SQL_CurrentInstance" type="Sql Server" connectionString="Sql Connection String" />

	to

	<instance name="CurrentInstance" type="Sql Server" connectionString="Sql Connection String" />

8. Rebuild the application and you're done!

Notes:
* The EDAB componants cache the settings so you may have to close down Visual Studio and re-open it to get the settings to change.

* The "EDAB_OleDB_StoredProcedures.exe.config" must be in the "/bin" directory for the application to work. It is put there by the "PostBuildEvents.vbproj" project. However, this project will be corrupted if you change it in Visual Studio. if that happens re-copy it from the source. The line:

                PostBuildEvent = 'xcopy /C /I /R /Y  "$(ProjectDir)dataConfiguration.config" "$(ProjectDir)$(OutDir)."&#xd;&#xa;copy  "$(ProjectDir)EDAB_OleDB_StoredProcedures.exe.config" "$(ProjectDir)$(OutDir)."&#xd;&#xa;'

Must be in "PostBuildEvents.vbproj" to work. See "PostBuildActions-Readme.txt" for more information.