Lotus Notes NotesSQL ODBC 驱动程序只读
我被要求远程检索数据并将其更新到 Lotus Notes 数据库。 我在 64 位 Windows 7 PC 上安装了 Lotus Notes NotesSQL ODBC 驱动程序。我可以很好地从 Notes 视图中读取数据,但是当我尝试更新字段时,我收到一条消息,指出记录集不可更新。
有谁知道什么会导致数据只读?
注释视图可以设置为只读吗? 难道我有 64 位操作系统而驱动程序是 32 位(我相信)? 还有其他人看过这个吗?
笔记。我正在使用 MS Access 查看数据。
I have been asked to retrieve and update data remotely to our Lotus Notes database.
I installed the Lotus Notes NotesSQL ODBC driver on my 64 windows 7 PC. I can read data from a Notes view just fine however when I try to update a field I get a message stating the that the Recordset is not updateable.
Does anyone know what would cause the data to be read-only?
Can a Notes view be set as read-only?
Could it be that I have a 64 bit OS and the driver is 32 bit (I believe)?
Has anyone else seen this?
Note. I am using MS Access to view data.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
Notes 视图本质上是只读的。我在通过 NotesSQL 进行更新方面没有太多经验,但您可能会看到是否可以连接到“Notes Form”并进行更改。除此之外,我会确保您用于连接的 Notes 帐户具有对数据库的适当访问权限。
Notes views are read-only by nature. I don't have much experience with making updates via NotesSQL, but you might see if you can connect to a "Notes Form" instead and make a change. Other than that, I'd make sure the Notes account you're using to connect has the appropriate access to the database.