ibatis.net + sqlserver2005错误

Question

Unable to open connection to "Microsoft SQL Server, provider V2.0.0.0 in framework .NET V2.0".

<provider
    name="sqlServer2.0"
    enabled="true"
    description="Microsoft SQL Server, provider V2.0.0.0 in framework .NET V2.0"
    assemblyName="System.Data, Version=2.0.0.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="@"
    allowMARS="false"
    />

</providers>

我已经在配置文件里面设置好了相应的环境，但是还是报这个错。

请各位帮小弟解决一下这个问题。在这里我感谢各位了。

Answer 1

你要搜索一个database的节点

修改里面的conncetion string的值为数据库连接字符串：类似如下：

<database>

        <!-- Optional ( default ) -->

        <provider name="sqlServer1.1"/>

        <dataSource name="iBatisNet"

connectionString=""/>--这里写连接字符串。

        </database>

---

family as water

Answer 2

<database>
    <provider name="sqlServer2.0"/>
    <dataSource name="Blogs" connectionString=""/>
 </database>

我已经设置好了啊，但是还是报同样的错误。

我这是第一次试着使用ibatis进行开发，对里面的设置还是没完成明白。

请ls的继续帮小弟解答一下，谢谢！

---

像狼一样活着。。。

Answer 3

连接字符串是空的？？

---

---

The following is signature, not part of post
Please mark the post answered your question as the answer, and mark other helpful posts as helpful, so they will appear differently to other users who are visiting your thread for the same problem.
Visual C++ MVP

Answer 4

不是空的，贴上来的没有加连接字符串。

---

像狼一样活着。。。

Answer 5

把你的连接字符串贴出来。

---

---

The following is signature, not part of post
Please mark the post answered your question as the answer, and mark other helpful posts as helpful, so they will appear differently to other users who are visiting your thread for the same problem.
Visual C++ MVP