Connect to remote Access DB

[usamaalam]

Hello everybody,

I need to connect my C# application with access database which is reside on remote sesrver, i.e. http://e.domaindlx.com/usamaalam/TestDB.mdb. I wrote the following code to connect the db but getting exception.

Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + "http://e.domaindlx.com/usamaalam/TestDB.mdb" +  ";Persist Security Info=False";

Conn.Open();

[PilgrimPete]

What is the exception?
I don't think that you can connect to Access over HTTP anyway... I think the database needs to reside locally or on a network share.
Could you create a Web Service on the server and communicate using that?

[Pirate]

What is the exception?
I don't think that you can connect to Access over HTTP anyway... I think the database needs to reside locally or on a network share.
Could you create a Web Service on the server and communicate using that?

Not totally correct . My friend could wire ASP.NET with Access db as back end .It's working fine with him.

[PilgrimPete]

Cool - can you share how? I might need to do that soon!

(The only way I managed so far was through an ASP page posting XML to the Response and Request objects. Works, but isn't ideal...)