blocks|key|4468447|text|我似乎发现，在IIS作为服务运行时，映射的网络驱动器是不可用的。此外，我无法创建带有UNC路径的DSN条目。因此，我用本地数据库创建了DSN，然后在Regedit中更改了路径。好痛啊。确保提供正确的凭据(UID和PWD)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4468448|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I have discovered, it seems, that a mapped network drive is not available to IIS as it runs as a service. In addition, I have been unable to create a DSN entry with a UNC path. So, I created the DSN with a local database, then changed the path in Regedit. What a pain. Be sure to provide proper credentials (UID and PWD).

blocks|key|4468386|text|使用一个有效的路径，这与|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4468387|Y:\\192.168.2.5\data\db.accdb|code-block|syntax|javascript|4468388|\是一个特殊的角色。你需要，|offset|length|style|CODE|4468389|Y:\\192.168.2.5\\data\\db.accdb|4468390|或|4468391|Y:/192.168.2.5/data/db.accdb|4468392|entityMap^0|0|0|0|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@$I|X|J|Y|K|L]]|9|@]|A|$]]|$1|M|3|N|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|10|8|@]|9|@]|A|$]]|$1|Q|3|R|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

Use a valid PATH, the problem with this

<pre><code>Y:\\192.168.2.5\data\db.accdb
</code></pre>

Is that <code>\</code> is a special character. You need,

<pre><code>Y:\\192.168.2.5\\data\\db.accdb
</code></pre>

or

<pre><code>Y:/192.168.2.5/data/db.accdb
</code></pre>

blocks|key|4075607|text|总之，我打赌这是个许可问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4075608|有着完全相同的错误信息，并且因为它更早的工作而感到困惑。这是因为我正在更改Tomcat的版本，并且它在未经许可的情况下运行，访问我的db资源。|4075609|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

To summarize I bet this was a permission problem. 

Was having the exact same error message and was baffled because it was working earlier. It was because I was changing versions of Tomcat on my end and it was running without permission to access my db resource.

blocks|key|4468496|text|因此，我有一个类似的，如果不是相同的，问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4468497|安装了沼泽地。正在使用php访问网络上的mdb文件。我收到消息说没有找到路径。|4468498|所以我所做的是，创建了一个正常的dsn配置，然后它看起来像这样:+Y:\mydata.mdb|4468499|我在regedit上搜索了"y:\mydata.mdb“并找到了它。将其更改为完整路径，例如"\serverip\serverfolder\mydata.mdb“|4468500|这是在管理用户身上完成的。|4468501|我刷新了网页，它起了作用。希望这能帮上忙。|4468502|附注：写得太匆忙了。抱歉我没说清楚。|4468503|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|S|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|T|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|V|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|O|$]]

so I had a similar, if not the same, issue.

had installed wamp. 
was using php to access a mdb file on the network. and I got the msg saying path not found.

so what I did was, created a normal dsn configuration and then how it looked like was something like this:
Y:\mydata.mdb

I searched for "y:\mydata.mdb" on regedit and found it.
changed it to full path for example like "\serverip\serverfolder\mydata.mdb"

This was done on administrative user.

I refreshed the web page and it worked.
Hope this helps somebody. 

p.s.
written on a rush. sorry if I wasn't clear.

blocks|key|4075648|text|我只是通过拼写完全限定的dns名称来修复这个连接字符串，而不是使用映射的驱动器名"H:":。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4075649|坏的|4075650|sCN_ODBC+=+@"Driver={Microsoft+Access+Driver+(*.mdb)};+Dbq=H:\vol01\IIT\Apps\Applications\MFG\User.mdb;Trusted_Connection=yes";|code-block|syntax|javascript|4075651|好的|4075652|sCN_ODBC+=+@"Driver={Microsoft+Access+Driver+(*.mdb)};+Dbq=\\tstorage.iit.edu\depts$\vol01\IIT\Apps\Applications\MFG\User.mdb;Trusted_Connection=yes";|4075653|我使用的是C#+dotnet，这个线程上的其他帖子是java和php|4075654|entityMap^0|14|5|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|X|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|Y|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|Z|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|10|8|@]|D|@]|E|$K|L]]|$1|Q|3|R|5|6|7|11|8|@]|D|@]|E|$]]|$1|S|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|T|$]]

I just fixed this connection string by spelling out the fully qualified dns name, instead of using the mapped drive name <code>"H:":</code>

BAD

<pre><code>sCN_ODBC = @"Driver={Microsoft Access Driver (*.mdb)}; Dbq=H:\vol01\IIT\Apps\Applications\MFG\User.mdb;Trusted_Connection=yes";
</code></pre>

GOOD

<pre><code>sCN_ODBC = @"Driver={Microsoft Access Driver (*.mdb)}; Dbq=\\tstorage.iit.edu\depts$\vol01\IIT\Apps\Applications\MFG\User.mdb;Trusted_Connection=yes";
</code></pre>

I'm using C# dotnet , other posts on this thread are java and php

I have created DSN for Mapped drive like this:-

<pre><code> Y:\\192.168.2.5\data\db.accdb
</code></pre>

Now i am accessing this database from java application using sun jdbc odbc drivers. Application is running on Window 2008 64-bit system and database is running on Window Server 2012 64-bit system.

When I ran this application with Java 64-bit it throw error of architecture mismatch.

Then i install java of 32-bit and the above problem is resolved. But getting another problem as

<pre><code> java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is
 not a valid path. Make sure that the path name is spelled correctly and that yo
 u are connected to the server on which the file resides. 
</code></pre>

How to resolve this problem?

<img src="https://i.stack.imgur.com/2qb2N.png" alt="enter image description here">

See the database path witch is not valid for my program. This path is mapped with Y:\192.168.2.5\shared drive.

[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我为映射驱动器创建了DSN，如下所示： Y:\\192.168.2.5\data\db.accdb现在，我正在使用sun驱动程序从java应用程序访问这个数据库。应用程序运行在Windows200864位系统上，数据库运行在Window 2012 64位系统上。当我使用Java 64位运行这个应用程序时，它会抛出架构不匹配的错误。然后我安装了32位的java，解决了上面的问题.但另一个问题是  j

问[ Microsoft ][ODBC Microsoft访问驱动程序]‘(未知)’不是有效路径
EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问[ Microsoft ][ODBC Microsoft访问驱动程序]‘(未知)’不是有效路径EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问[ Microsoft ][ODBC Microsoft访问驱动程序]‘(未知)’不是有效路径
EN