Click here to Skip to main content
15,064,351 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

I am using vb.net for transport management software. My database (ms access 2003) is online (on my website server). my application is stored on local pc. what connection string for the that.

Thanks
Vikash Yadav
Posted

This link[^] might help you.
   
This might work for you
Dim connectionstring as String="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Server.MapPath(mydatabase.mdb);"

On a webserver it would be ideal to use Server.MapPath function. Instead of this you can also try absolute path.
There is CodeProject article too, its in C# though but it might help you out.
How to link to an Access Database in a C# Application[^]

Best Regards,
Ashish
   
Access databases only work over Windows Networking, not over HTTP. There is no connection string that will allow you to work with an Access database over HTTP through a web server.

Either your clients have to be able to get at a share folder on the server or you'll have to wrap all database access in a web service or you cannot use Access and must switch to a real database engine, like SQL Server.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900