C# Error in accessing an Access Database over LAN

Question

Here's my connection string:

sConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\" + lstNet.SelectedItem.ToString() + "\SharedDocs\Documents\Debug\App_File\ggbase.mdb;Jet OLEDB:Database Password=g3n3r4l;";

lstNet is a listbox that contains all computers found in the network.

I'm assuming something else is wrong with my connection string.

According to Connection Strings website, to access a database over LAN, the following connection string format is used:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\serverName\shareName\folder\myDatabase.mdb;User Id=admin;Password=;

I'm assuming that shareName is where my Connection String fails. What is a shareName? And what are the shareNames of Windows XP and Windows Vista / 7 if, say, I placed my database in their Shared Documents / Public Files?

I've tried modifying my connection string into the following:

\C$\Users\Public\Documents\Debug\App_File\ggbase.mdb;Jet OLEDB:Database Password=g3n3r4l;";

And I still get the following error:

"Format of Initialization string does not conform to specification"

May I have some help on this, please?

EDIT: Tried accessing the database in the Public\Documents section of a Windows Vista PC on my network with the following connection string:

\Public\Documents\Debug\App_File\ggbase.mdb;Jet OLEDB:Database Password=g3n3r4l;";

I also tried to access my own (Windows 7 PC) local Public\Documents section using the same connection string, since the serverName can be changed using the program.

Still nothing.

halfer · Accepted Answer · 2024-04-06 11:10:54Z

1

Try this:

"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\serverName\shareName\folder\myDatabase.mdb; Jet OLEDB:Database Password=g3n3r4l;Persist Security Info=False;"

You must need to test first if you can access the shared path folder on client P.C. And if it can access it there will be no problem. Make sure also that the client user is administrator so it can do CRUD using your app.

edited Apr 6, 2024 at 11:10

halfer

20.2k20 gold badges111 silver badges208 bronze badges

answered Nov 14, 2011 at 7:01

Crimsonland

2,1943 gold badges25 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

zack_falcon Over a year ago

On the client PC? I can access the shared path folder fine on both the Server, and the Client. I added the "Persist Security", but I'm sorry to say it didn't work. I still think it has something to do with that shareName. I just don't know what it is. Researching it had me come up with some codes, so I'm pretty sure it's not a folder. (c$, winnt, stuff like that).

zack_falcon · Accepted Answer · 2011-11-14 16:12:16Z

0

Well, I actually solved it. Wow.

It turns out, there was an extra " at the very end of the connection string from the .ini file.

answered Nov 14, 2011 at 16:12

zack_falcon

4,38423 gold badges70 silver badges111 bronze badges

Comments

Shailendra Mishra · Accepted Answer · 2013-10-11 09:21:06Z

0

//Try This One...

        string constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.\\PIS(ACU).mdb;";
        Con = new OleDbConnection(@constr);
        Con.Open();
        Com = new OleDbCommand();
        Com.Connection = Con;

answered Oct 11, 2013 at 9:21

Shailendra Mishra

7110 bronze badges

Collectives™ on Stack Overflow

C# Error in accessing an Access Database over LAN

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related