Connect to remote Access DB
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.
Code:
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + "http://e.domaindlx.com/usamaalam/TestDB.mdb" + ";Persist Security Info=False";
Conn.Open();
Re: Connect to remote Access DB
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?
Re: Connect to remote Access DB
Quote:
Originally Posted by 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?
Not totally correct . My friend could wire ASP.NET with Access db as back end .It's working fine with him.
Re: Connect to remote Access DB
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...)