Btrieve（文件）所有者问题
我的任务是从 Btrieve（Pervasive）数据库导出一堆表，但其中一个表正在发生争执。我正在使用 Pervasice 控制中心，但是当我运行 SELECT * FROM 时，我收到此错误：
ODBC Error: SQLSTATE = S1000, Native error code = 0
Unable to open table: <troublesome table>.
The owner namme is invalid(Btrieve Error 51)
我用 Google 搜索了此内容，发现可能有一个“所有者” ”到 DDF 文件，但是，如果我理解正确的话，所有表都在该文件中。但只有一张表导致了这个错误，所以我不知道发生了什么。
有人可以提供一些帮助吗？
I've been tasked with exporting a bunch of tables from a Btrieve (Pervasive) database but one of the tables is putting up a fight. I'm using the Pervasice Control Centre but when I run a SELECT * FROM <troublesome table> I get this error:
ODBC Error: SQLSTATE = S1000, Native error code = 0
Unable to open table: <troublesome table>.
The owner namme is invalid(Btrieve Error 51)
I've Google'd this and found out that there can be an "owner" to a DDF file but, if I understand this correctly, all tables are in that file. But there's just one table causing this error so I have no idea what's going on.
Could someone please offer some assistance.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
Btrieve 文件和 DDF 上可以有所有者名称。在这种情况下，Btrieve 文件似乎具有读取该文件所需的所有者名称（所有者名称可以允许在没有所有者名称的情况下进行只读访问或不允许访问）。
根据您使用的 PSQL 版本，您可以在执行 SELECT 语句之前发出 SET OWNER= 命令。有关 SET OWNER 的完整文档，请查看 http://docs.pervasive.com/products/database/psqlv11/wwhelp/wwhimpl/js/html/wwhelp.htm#href=sqlref/syntaxref.3.76.html。
至于确定所有者名称，您必须询问程序的开发人员。没有默认所有者名称，也没有主所有者名称。
There can be an owner name on a Btrieve file as well as the DDF. In this case, it seems that the Btrieve file has an owner name that is required to even read the file (an owner name can allow read only access without the owner name or no access).
Depending on the version of PSQL you are using, you can issue a SET OWNER= command before executing the SELECT statement. For full documentation on SET OWNER, take a look at http://docs.pervasive.com/products/database/psqlv11/wwhelp/wwhimpl/js/html/wwhelp.htm#href=sqlref/syntaxref.3.76.html.
As far as determining the Owner name, you'll have to ask the developer of the program. There is no default owner name and not master owner name.