VS 2017中的“无法检索表或视图的架构信息"错误-M Access 2016 [英] 'Could not retrieve schema information for table or view' error in VS 2017 - M Access 2016

问题描述

我正在尝试将Visual Studio项目连接到本机上的Microsoft Access数据库，我能够在Microsoft Access中正确打开数据库，甚至尝试使它没有记录并且尽可能简单，当我在Visual Studio中添加它并测试连接时，它显示为Test connection succeeded，并向我显示数据库，它可以找到包含所有字段的表名，但是当我单击完成时，我收到一条错误消息，提示:

I'm trying to connect my Visual Studio project to a Microsoft Access database locally on my machine, I'm able to open the database correctly in Microsoft Access and I even tried making it empty of records and as simple as possible, when I'm adding it in Visual Studio and when I test the connection it says Test connection succeeded, and it's showing me the database, it can find the table name with all the fields, but when I hit finish I get an error message saying :

无法检索表或视图[数据库表名称]的架构信息

Could not retrieve schema information for table or view [database table name]

我进行了很多搜索，并且看到了剪辑正在发生的事情.

I'v searched a lot and I'v seen this post on StackOverflow but it did't help. I'm still getting that error, and this is a short clip on what's happening.

有人可以在这里帮助我吗！

推荐答案

我终于弄明白了，我打开了Visual Studio安装程序，下载并安装了SQL Server Package，然后进行了尝试，一切正常.

I finally figured it out, I opened the Visual Studio Installer and I downloaded and installed the SQL Server Package and then tried and it worked just fine.

知道我尝试使用独立安装来安装SQL Server 2017，但它无法正常工作，因此您需要使用同一Visual Studio Installer来安装它.

Knowing that I tried installing the SQL Server 2017 using a stand-alone installation but it didn't work, so you need to install it form the same Visual Studio Installer.

以下是该图片:

与使用本地数据库和Microsoft Access相比，使用MySQL与PHP一起控制在线数据库的问题比其他问题更难解决时，我真的很着迷.

I really find it fascinating when the things that supposed to be harder than other things like problems using MySQL with PHP to control an online Databases is easier to solve than using a local databases and Microsoft Access.

希望这可以解决遇到相同问题的人:)

这篇关于VS 2017中的“无法检索表或视图的架构信息"错误-M Access 2016的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！