lostinthegame
asked on
writing to a database on my website
I am fairly new to using databases. I currently have a windows form application that has it's own database to save client information. The database is stored locally on the user's computer, and I can easily access it to pull records and update client information.
When an error occurs in the software it sends out an email to me with the error code and the line number so that I can correct it. Also, when the user registers the software, I am sent another email with the registration code and expiration date for the software.
What I would like to do is have a database that is stored on my website so that if an error occurs, the program will attempt to write the error message to my online database, then if it fails, proceed with sending the email so that I can still receive the error code. I would like the same idea for the registration and expiration date to be stored on a website database instead of emailing to me.
I don't have any work to show, because I am completely stumped at line 1. Can someone send me in the right direction to accomplish this? Essentially, each user should have their own local database, but all users' programs can write to a single error and registration database on my website.
I am using vb.net, visual studio 2010, and I have a godaddy website.
When an error occurs in the software it sends out an email to me with the error code and the line number so that I can correct it. Also, when the user registers the software, I am sent another email with the registration code and expiration date for the software.
What I would like to do is have a database that is stored on my website so that if an error occurs, the program will attempt to write the error message to my online database, then if it fails, proceed with sending the email so that I can still receive the error code. I would like the same idea for the registration and expiration date to be stored on a website database instead of emailing to me.
I don't have any work to show, because I am completely stumped at line 1. Can someone send me in the right direction to accomplish this? Essentially, each user should have their own local database, but all users' programs can write to a single error and registration database on my website.
I am using vb.net, visual studio 2010, and I have a godaddy website.
Do you have a database already? If not, I suggest you use MySQL. it is open source and is supported by godaddy
ASKER
I built a quick on using godaddy's website. I was actually tooling around with it when you posted. I may be getting somewhere because it gave me a php connection string. I guess I just need to figure out how to connect using vb.net.
I have very limited experience with this, but you should look into sending SOAP messages from the client and consuming them with a web service.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Got it working between both installing Mysql connector and writing the connection string as listed. The issue was that the godaddy database was restricted from direct access. Made a new database, and now I'm good to go.
Thanks
Thanks