Access database on localhost

[Himo]

I want to access an MS access database on my localhost, but when I'm using this connection string:

String sConnString = "Driver={MS Access Driver (*.mdb)};Dbq=http://localhost/WebApplication1/bin/users.mdb;";

It just won't work, saying: Invalid filename

What could I do about it?

[PlausiblyDamp]

For that to work the .mdb file would be accessible to everyone from the url - not a secure option. Plus unless you are using something like WebDAV it would not be treated like a normal file anyway.

What you will need to do is get the filename at runtime via Server.MapPath(...)

e.g.

String ConnString = "Driver={MS Access Driver (*.mdb)};Dbq=" + Server.MapPath("bin/users.mdb;") 

[Himo]

2 questions then:

 

1) WebDAV?

2) How could I configure SQL Server then correctly to do this? I couldn't figure out the hostname, since he wouldn't take 'localhost'.

 

Thank you very much already :)

[PlausiblyDamp]

http://www.webdav.org/

 

If you are using SQL server then you would have a totally different connection string anyway - you would not be connecting direct to a file.

However if SQL is on the same server you could get away with something like Data Source=(local) to identify the server.