无法通过ODBC连接对SQLlite的访问 [英] Unable to connect Access to SQLlite via ODBC

问题描述

我有一个Access 97数据库，它通过ODBC和链接表作为前端，并连接到在Wiin7-64下运行的MySQL数据库. (是的，它确实有效！)该数据库包含有关我所居住的法国部分地区的朝拜地点和朝圣的信息.另外，我在Photoshop Elements 9中有数以万计的网站照片.PSE9的底层数据库引擎是SQLite，并且有关于照片的有趣数据(标题，我喜欢的标题等).我想像从MySQL到MySQL数据库一样，从Access链接到SQLite数据库中的表.

I have an Access 97 database that serves as a front-end, via ODBC and linked tables, to a MySQL database, running under Wiin7-64. (Yes, it does work!) The database contains info about places of worship and pilgrimage in the part of France where I live. In addition, I have tens of thousands of photos of the sites in Photoshop Elements 9. The underlying database engine of PSE9 is SQLite, and interesting data about the photos is there (titles, which ones I like, etc.). I would like to link from Access to the tables in the SQLite database as I do to the MySQL database.

我的问题:我无法创建与PSE9 SQLite数据库的ODBC连接.我已经通过Google进行了多次搜索，在stackoverflow和其他地方阅读了多个帖子，尝试了各种建议，但在Win7-64的32位或64位ODBC工具中都没有ODBC连接.我很困惑.

My problem: I am unable to create an ODBC connection to the PSE9 SQLite database. I have done multiple searches via Google, read multiple posts at stackoverflow and elsewhere, tried various suggestions, and still no ODBC connection, neither in the 32bit or 64bit ODBC tools of Win7-64. I'm stumped.

到目前为止，我已经

• 从 http://www.ch-werner.de/sqliteodbc/下载了sqliteodbc.exe. a>并运行(多次)
• 将sqlite3odbc.dll，sqlite3.def，sqlite3.dll和sqlite3.exe复制到\ windows \ system32文件夹中
• 在Windows命令行中输入了此命令:"rundll32 c:\ windows \ system32 \ sqlite3odbc.dll，安装"，这会产生此错误消息将c:\ windows \ system32 \ sqlite3odbc.dll复制到c:\ windows \ system32 \ sqlite3odbc.dll失败."

• downloaded sqliteodbc.exe from http://www.ch-werner.de/sqliteodbc/ and run it (multiple times)
• copied sqlite3odbc.dll, sqlite3.def, sqlite3.dll, and sqlite3.exe to the \windows\system32 folder
• entered this command at the Windows command line: "rundll32 c:\windows\system32\sqlite3odbc.dll,install", which produced this error message "Copy c:\windows\system32\sqlite3odbc.dll to c:\windows\system32\sqlite3odbc.dll failed."

当我查看ODBC和ODBC(32位)窗口时，找不到SQLite的用户DSN，系统DSN或文件DSN.有什么建议吗?

When I look at the ODBC and ODBC (32-bit) windows, I don't find a User DSN, System DSN or File DSN for SQLite. Any suggestions?

谢谢， 哈维在宜人的波尔多

Thanks, Harvey in balmy Bordeaux

推荐答案

所有正在复制的dll都有什么用-您无需执行任何操作.只需下载32位版本并双击它-驱动程序将被安装.然后找到32位ODBC管理器(请注意，在64位窗口上有2个，只有一个是32位)，启动它并创建DSN.您应该在驱动程序选项卡中看到sqlite3.

Whats with all that copying dlls around - you don't need to do any of that. Just download the 32 bit version and double click on it - the driver will be installed. Then find the 32 bit ODBC Administrator (note there are 2 on 64 bit windows and only one is 32 bit), fire it up and create a DSN. You should see sqlite3 in the drivers tab.

这篇关于无法通过ODBC连接对SQLlite的访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！