Hi evrybody
I want to connect my vb.net application over the network to Ms Access database?
And can i change the my access database to foxpro with out effecting
in the source code of my vb.net application.
Thanks in Advance
Printable View
Hi evrybody
I want to connect my vb.net application over the network to Ms Access database?
And can i change the my access database to foxpro with out effecting
in the source code of my vb.net application.
Thanks in Advance
The source code would have to be modified as each database requires a different connection string.Quote:
Originally Posted by startnow
Is that a question or a statement?Quote:
Originally Posted by startnow
Your mdb file would need to be in a shared folder that the users have read/write access to.
The VB.Net would need a connection string to that folder, so perhaps an ini file or a registry place holder. You'd need a form or a separate app to locate the back end mdb and store the path. Should work ok though once you have the path. Not sure if .Net allows a install to type thing? might be able to get it to ask the user where the back end should go...?
Read up on the distributing .net projects online?
If you are connecting over a LAN the answer is Yes. If by network you mean the internet then it is not possible to connect directly to an Access database. There are work arounds that will allow you to do this using other Microsoft products.Quote:
I want to connect my vb.net application over the network to Ms Access database?
At the very least you will have to create a new connection string for Foxpro. You could handle this in your code by giving the user a menu option or checkbox option to choose which database type you want.Quote:
And can i change the my access database to foxpro with out effecting in the source code of my vb.net application.
Ecniv's suggestion that you create an ini type file is the one that I use most often.
When you talk about changing your Access DB to Foxpro do you mean converting your Access DB to Foxpro? You may run into issues with data types and how Foxpro distinguishes dates, numbers, text when running queries.
Ok am trying to connect over local LAN so how the string will looks like after
connecting is it like this:-
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\192.165.132.212\SaveTree.mdb
and yah i need to convert the data file from access to Foxpro so i did it but still shows me some error in the .Net
As far as I know Access does not use IP addresses so your connection string should look something like...
I don't use Foxpro so I don't know what it's connection string will look like.Code:yourDbConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=u:\someFolder\SaveTree.mdb;Persist Security Info=False"
What error are you getting and where does it occuir in your code? Showing the code you are using would be helpful.