[Question] VB.NET and Databases.
[Question] VB.NET and Databases.
So I have a database attached to my program which contains names.
But what I need to know is, how would I make the database update if theirs new names added to the database.
Example:
Computer A has my program but doesn't have a correct database. How would I make it so that Computer A can get an updated version from the Main computer.
Thanks in advance.
But what I need to know is, how would I make the database update if theirs new names added to the database.
Example:
Computer A has my program but doesn't have a correct database. How would I make it so that Computer A can get an updated version from the Main computer.
Thanks in advance.
host the database on the server, use a connection string.
How you maintain the database is a matter of logic and what type of database you are using (3rd time today, awesome, I am glad to see that people are starting to use databases)
What type of database are you using SQL Server, MySQl , Access, Entity...
This matters somewhat
How you maintain the database is a matter of logic and what type of database you are using (3rd time today, awesome, I am glad to see that people are starting to use databases)
What type of database are you using SQL Server, MySQl , Access, Entity...
This matters somewhat
I'm going to start with Access as I find it very easy to work with
When you add a database the connection string will be
where mydatabase is the name of your database.
You need to edit the data string so the source points to the hosting account instead of the local drive
You can do that in the database properties.
Note: When you create the database be sure to use a username and password for security, and set them in the above string
Example of database string in use
Databases will update dynamically by checking the datastring for location then updating it's information "on the fly"
Code:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;
You need to edit the data string so the source points to the hosting account instead of the local drive
You can do that in the database properties.
Note: When you create the database be sure to use a username and password for security, and set them in the above string
Example of database string in use
Code:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=http://mywebdomain.com\db\mydatabase.mdb;User Id=myusername;Password=mypassword;
That's just the info I needed!
Thanks for the quick help!
Thanks for the quick help!
Not a problem, It's what I hang around for
Similar Threads
- 17Last post
- 6Last post
- 20Last post
- 2Last post
- 0Last post