Solved! After look into ADS Data Provider classes I saw that de parameter
type is SqlDbType, so the provider configuration is this:
<provider
name="ADS"
description="Advantage Database Server"
enabled="true"
assemblyName="Advantage.Data.Provider"
connectionClass="Advantage.Data.Provider.AdsConnection"
commandClass="Advantage.Data.Provider.AdsCommand"
parameterClass="Advantage.Data.Provider.AdsParameter"
parameterDbTypeClass="System.Data.SqlDbType, System.Data, Version=
2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
parameterDbTypeProperty="SqlDbType"
dataAdapterClass="Advantage.Data.Provider.AdsDataAdapter"
commandBuilderClass="Advantage.Data.Provider.AdsCommandBuilder"
usePositionalParameters="false"
useParameterPrefixInSql="true"
useParameterPrefixInParameter="true"
parameterPrefix="@"
allowMARS="false"
/>
And it worked!
Thanks
Regards... Jose
On Fri, Oct 31, 2008 at 7:13 PM, Jose Selesan <[EMAIL PROTECTED]> wrote:
> Hi, just another question. I will use Advantage Database Server to access
> an ERP Database and put some functionality in a new web site. For the
> connection from .Net I will use the provider for .Net provided for Sybase
> (Advantage.Database.Provider.dll), but I have a little problem. When I
> define the provider for iBatis, I don`t have a type for parameter
> *parameterDbTypeClass
> *and for *parameterDbTypeProperty* and if I left it null, I get an
> exception. This is my provider configuration:
>
> <provider
> name="ADS"
> description="Advantage Database Server"
> enabled="true"
> assemblyName="Advantage.Data.Provider"
> connectionClass="Advantage.Data.Provider.AdsConnection"
> commandClass="Advantage.Data.Provider.AdsCommand"
> parameterClass="Advantage.Data.Provider.AdsParameter"
> dataAdapterClass="Advantage.Data.Provider.AdsDataAdapter"
> commandBuilderClass="Advantage.Data.Provider.AdsCommandBuilder"
> usePositionalParameters="false"
> useParameterPrefixInSql="true"
> useParameterPrefixInParameter="true"
> parameterPrefix="@"
> allowMARS="false"
> />
>
> But it doesn´t work. My question is: is necesary to define
> *parameterDbTypeClass
> *and *parameterDbTypeClass?.*Can I use another type?
>
> Thanks a lot
>
