连接到局域网中的访问数据库(位于某些位置) [英] connecting to the access database in lan (located at some where)

问题描述

我想连接到位于其他系统中的访问数据库，这些访问数据库在LAN中连接，我们已将访问数据库保留在共享文件夹中.

我尝试了很多，但是显示如下错误

"''E:\games\All projects\oct\connecttoaccess\connecttoaccess\bin\Debug\10.0.0.3\share\testing.mdb'' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides."

到此

Hi,

I want to connect to the access database which was located in some other system and these are connected in LAN, we had kept the access database in the sharing folder.

I had tried a lot but it was showing the error as below

"''E:\games\All projects\oct\connecttoaccess\connecttoaccess\bin\Debug\10.0.0.3\share\testing.mdb'' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides."

upto this

E:\games\All projects\oct\connecttoaccess\connecttoaccess\bin\Debug\

，这是我的程序保存的路径


IP地址:10.0.0.3

共享文件夹名称:share

数据库名称:testing.mdb

it was my program saved path


IP address :10.0.0.3

Sharing foldername :share

database name :testing.mdb

<pre lang="C#">OleDbConnection con = new OleDbConnection("provider =Microsoft.JET.OLEDB.4.0;data source=10.0.0.3\\share\\testing.mdb");

我在连接字符串站点中已经看到了这种配置，我认为我做错了什么，或者是否有任何其他过程可以连接到访问数据库.

请帮帮我.


这是C#.net中的Windows应用程序；

I had seen this configuration in connecting strings site, I think I am doing something wrong, or is there any other process to connect to the access database.

Please help me.


This was an windows application in C#.net;

推荐答案

检查该IP地址连接了什么. 运行您的Internet浏览器，然后在地址栏中键入10.0.0.3.按ENTER-会发生什么?

Check what is connected to that IP address.
Run up your internet browser and type 10.0.0.3 in the address bar. Press ENTER - what happens?

执行以下步骤:
1)确保系统上的共享文件夹(放置访问数据库的位置)具有写/读权限.
2)同样，当您想在应用程序中访问db文件时，请尝试执行以下操作；
\\您的伴奏名称\ Share \ testing.mdb.
3)首先，只需尝试在Start>>中运行上述路径即可.运行.
如果失败.然后尝试运行\\您的伴奏名称并按Enter.
当窗口带有共享文件夹时，双击它.
如果看到MDB文件，请尝试打开该文件.
如果打开，则将文件路径复制到Windows地址栏中，并在您的应用中使用.

告诉我您是否坚持使用某些东西.

Do the following step :
1) make sure that the share folder on system (that where you put u''r access DB) have a write/read permission.
2) also when you want to access the db file in your apps try like this ;
\\Your comp name\Share\testing.mdb.
3) first just try to run the above path in Start >> Run .
if it fails . then try to run \\your comp name and hit enter.
when window come with a share folder double click on it .
if you see the MDB file try to open the file.
if its open then copy the file path in windows address bar and use it in your apps.

inform me if you stuck with some thing.

我得到的答案是一个小错误，


经过长时间的奋斗，我明白了，这看起来像是一个有趣的
东西，
一次看到答案

i got the answer its an small mistake ,


after a long struggle , i got this , this looks like a funny
thing ,
see the answer one time

"provider =Microsoft.JET.OLEDB.4.0;data source=\\\\10.0.0.3\\share\\testing.mdb");

我忘了保留转义序列，那就是问题了
感谢您的全力支持，
非常感谢

i had forgot to keep the escape sequences , thats the problem ok
thanku for all ur attenttion ,
thanks a lot

这篇关于连接到局域网中的访问数据库(位于某些位置)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！