说服Access 2007使用.UDL文件/oledb连接? [英] Persuade Access 2007 to use a .UDL file/oledb connection?

问题描述

有什么办法哄骗Access 2007使用.UDL文件?

Is there any way of coaxing Access 2007 into using a .UDL file?

具体来说，我们的较旧产品之一使用Interbase 6.0数据库.我的客户希望使用Access 2007(短期内)链接到他的数据库，以进行读/写.

Specifically, one of our older products uses an Interbase 6.0 database. My client would like to link to his database, for read/write, using Access 2007 (in the short term).

虽然这根本不是我的首选工作方式，因为它全都是单用户，而对Interbase数据库的其他访问都是通过Delphi 7客户端完成的，所以我真的不能只说不" -至少要等到我有时间适当地"给他他想要的东西时.

While this isn't my preferred way of doing things at all, given it's all single-user and the other access to the Interbase database is all done via a Delphi 7 client, I can't really just say 'no' - at least, not until I have the time to 'properly' give him what he wants.

尽管我已经制作了一个.UDL文件，该文件可以成功地(通过IBoledb)链接到数据库，但是我没有Access可以使用的任何其他类型的驱动程序.愚蠢的是，我只是假定现代版本的Access可以使用.UDL文件...

I don't have any other kind of driver that Access could use, although I have made a .UDL file that successfully links (via IBoledb) to the database. Stupidly, I just assumed that a modern version of Access would be able to use a .UDL file...

因此，我试图让Access 2007理解该.UDL文件(甚至尝试将其重命名为.DSN并弄乱了文件中的某些值)，但无济于事.看来，获得访问权限以链接到Interbase的唯一方法是通过(购买的第三方)Interbase ODBC驱动程序.

So, I tried to get Access 2007 to make sense of that .UDL file (even tried renaming it to .DSN and messing around with some of the values in the file) but to no avail. It seems that the only way you can get Access to link to Interbase would be via a (purchased, third-party) Interbase ODBC driver.

有人知道吗?我可以通过.UDL链接以某种方式获得Interbase对链接表"的访问吗?

Anyone know different? Can I somehow get Access to 'link tables' with Interbase via a .UDL link?

干杯！

推荐答案

似乎不可能.尽管Access会很乐意使用OLEDB与SQL Server进行通信，但似乎没有一种方法可以使它使用OLEDB与其他数据库的连接.

It doesn't seem to be possible. Although Access will happily talk to SQL Server using OLEDB, there doesn't seem to be a way to get it to use OLEDB connections to other databases.

至少现在我可以接受自己的答案"，我可以结束"这个问题. :-)

At least now that I can 'accept my own answers' I can 'close' this question. :-)

这篇关于说服Access 2007使用.UDL文件/oledb连接?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！