我如何...通过LAN网络连接到Microsoft JET 4.0数据库（.mdb） [英] How do I...Connecting to a Microsoft JET 4.0 database (.mdb) over a LAN network
问题描述
我正在构建一个vb6应用程序，我需要在Windows XP或更高版本的LAN网络上运行它。到目前为止，我已经制作了一个算法来制作和管理数据库（Microsoft JET 4.0数据库.mdb），我通常可以在使用此连接字符串的网络上使用它们：
Adodc1.ConnectionString =Provider = Microsoft.Jet.OLEDB.4.0; Data Source = \\192.168.1.20\SharedFolder\Data.mdb; Persist Security Info = False
但我需要从我的应用程序访问数据库，例如在另一台通过LAN网络的PC上的共享文件夹中。我知道如果我尝试在Win7Computer \ Network \ RemotePC\SharedFolder上打开一个共享文件夹，它会弹出一个显示Username和Password的窗口。所以它有密码保护，我也需要解决。
可能我需要的是一个好的，独特的连接字符串，可以访问像\\这样的数据库192.168.1.20\SharedFolder\Data.mdb没有抛出关于权限的例外。我可以像这样访问它，但只有当我在主机PC上禁用密码共享时才会访问它。
请帮助...谢谢！
I'm building a vb6 application and I need to run it on a LAN network on Windows XP or newer. So far, I've made an algorithm to make and manage databases (Microsoft JET 4.0 databases .mdb) and I can normally use them while on a network using this connection string:
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\192.168.1.20\SharedFolder\Data.mdb;Persist Security Info=False"
But I need to access a database from my application that's for example in a shared folder on another PC over LAN network. And I know that if I try to open a shared folder on Win7 "Computer\Network\DistantPC\SharedFolder" it pops up a window that says "Username" and "Password". So it has password protection which I need to resolve too.
Probably all I need is a good, unique connection string that can access a database like "\\192.168.1.20\SharedFolder\Data.mdb" without throwing an exception about permission. I can access it like this, but only when I disable passworded sharing on that host PC.
Please help... Thanks !
推荐答案
如果您有域，则必须在使用计算机资源之前进行身份验证。
如果您不在域中，请设置无密码共享： http://stackoverflow.com/ questions / 18442846 / how-to-access-shared-folder-without-giving-username-and-password [ ^ ]
If you have a domain then authentication before using the computers resources are mandatory.
If you are not on a domain then setup your sharing without passwords : http://stackoverflow.com/questions/18442846/how-to-access-shared-folder-without-giving-username-and-password[^]
这篇关于我如何...通过LAN网络连接到Microsoft JET 4.0数据库（.mdb）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
