Re: How to set the providers.config for Microsoft SQL Server 2005

[Mario Chavez]

For sql2005 I'm using the following configuration in providers:
<provider
        name="sqlServer2.0"
        enabled="true"
        assemblyName="System.Data, Version=2.0.50215.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
        connectionClass="System.Data.SqlClient.SqlConnection"
        commandClass="System.Data.SqlClient.SqlCommand"
        parameterClass="System.Data.SqlClient.SqlParameter"
        parameterDbTypeClass="System.Data.SqlDbType"
        parameterDbTypeProperty="SqlDbType"
        dataAdapterClass="System.Data.SqlClient.SqlDataAdapter"
        commandBuilderClass=" System.Data.SqlClient.SqlCommandBuilder"
        usePositionalParameters = "false"
        useParameterPrefixInSql = "true"
        useParameterPrefixInParameter = "true"   
        parameterPrefix="@"
        />

On 12/21/05, Wiryadi Adidharma <[EMAIL PROTECTED] > wrote:

Hi,

 

We currently use Ibatis.Net connected to Microsoft SQL Server 2000.

We plan to migrate to Microsoft SQL Server 2005.

Is there any sample of providers.config for SQL server 2005?

 

Thank you

 

Regards,

 

Wiryadi Adidharma

--
Mario Chavez
[EMAIL PROTECTED]
http://mario-chavez.decisionesinteligentes.com/