ASP.NET using a shared Access database... troubleshoot

[teixeira]

Hi all,

 

I'm developing our company Intranet using VS2005/C# and all works fine in my computer, but now that I wanna put the site in the server, i'm having some troubles with my connections to this shared database, with the information of the employers. THis database is used by 10 machines and I wanna create a connection that could use the database, does anyone knows how can I access to this shared database?

When I try to connect to a copy of this database in my pc it works just fine, but when i upload it to the server it gives an error about database connection/permissions.

 

Any ideas/help will be great... thanks in advance

 

Teixeira

Edited September 19, 2005 by teixeira

[tate]

Sounds like your connection string is not correct somewhere. Would you mind posting it?

 

 

Tate

[teixeira]

Thanks for your time.

 

Here's the connstring:

 

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\\\Server\\database.mdb;Persist Security Info=False"

 

The database doesn't have any password ( at least now )

 

Thanks,

 

Teixeira

[bri189a]

ASP.NET does not have read/write permission to the folder you are storing it in. It needs read permission for obvious reasons, it needs write permissions to create the mdl file that is created whenever you open Access. This is why it probably works on your local machine and not your server.

[tate]

Try a connection string similar to;

 

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/??path??/database.mdb") & ";User ID=Admin"