没有这样的表在C＃与SQLite [英] No such Table in C# with SQLite

问题描述

我想使用Microsoft Report Viewer在C＃中使用SQLite DB进行报告，我使用

并且我有数据集和数据库连接：

但是当我要从Table加载数据时，它会重试连接：

---

随时使用数据库再次连接到数据库。

---

当我要显示表日期时， connect：

解决方案

我认为这是一个问题，当您在 64位操作系统上进行 32位应用。

是

I want to make a Report with Microsoft Report Viewer in C# with SQLite DB, I am using SQLite ODBC Driver and when I make DataSet and Data Source to report, it has such Error:

Additional information: ERROR [HY000] no such table: Fuel (1)

but I have this Table and I have Connection to SQLite DB.

Here is Error:

and I have Dataset and Database connection:

But When I want to load data from Table it retries to connect:

---

Anytime to work with Database it wants to connect to DB again.

---

When I want show Table date it was retry to connect:

解决方案

I think it is a problem when you make a 32bit application on 64bit OS.

This is the notice in SQLite ODBC Driver, need install 64 bit and 32 bit.

这篇关于没有这样的表在C＃与SQLite的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！