Chad.
Thanks for the reply. I suppose I'm just not sure what I would replace
my existing providers.config file with. I pared its contents down to
simply:
<?xml version="1.0" encoding="utf-8" ?>
<providers>
<clear/>
<provider
name="sqlServer1.1"
enabled="true"
assemblyName="System.Data, Version=1.0.5000.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="@"
/>
</providers>
It doesn't seem to matter what I have in there. I've replaced it with
a fresh one (from npetshop) -- and made all the necessary changes --
and it makes no difference.
Here is my SqlMap.config file:
<?xml version="1.0" encoding="UTF-8" ?>
<sqlMapConfig
xmlns="http://ibatis.apache.org/dataMapper";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
<settings>
<setting useStatementNamespaces="false" />
<setting cacheModelsEnabled="false" />
</settings>
<providers resource="providers.config" />
<database>
<provider name="sqlServer1.1" />
<dataSource name="SHS"
connectionString="connstringhere" />
</database>
<sqlMaps>
<sqlMap resource="Maps/ALLMYMAPS.xml" />
</sqlMaps>
</sqlMapConfig>
Whether or not I include the <providers> entry seems to make no
difference either.
Thanks for your help.
Brian
On 9/21/05, Chad Humphries <[EMAIL PROTECTED]> wrote:
> Brian,
>
> The DTD changed in the Providers.config between those versions as did
> all of the other files I mentioned. I believe that their are new
> nodes as well (?description) so overwriting the old providers.config
> with a newer one is probably the safest bet.
>
> If that fails attach your providers.config to your reply.
>
> -Chad
>
> On 9/21/05, Brian Elcock <[EMAIL PROTECTED]> wrote:
> > Hello.
> >
> > I got the latest version from SVN, compiled it, updated my references
> > and DTDs according to this article:
> >
> > http://tiredidea.com/2005/08/23/ibatissvn/
> >
> > and now I get the error:
> >
> > Error while configuring the Provider named "sqlServer1.1". Cause : The
> > provider is not in 'providers.config'
> >
> > I've looked at the providers.config file, the sqlMap file and
> > everything seems to be in its proper place. Can anyone give me any
> > ideas here as to what might be causing this? Is there a new format for
> > the providers file?
> >
> > Thanks for your help.
> >
> > Brian
> >
>
