coombzee

Hi,

I have searched these forums and havent found anything that quite answers my questions. here's the deal:

Im using Visual Basic 2005 .NET Express Edition. I want to create an online database that my windows application links to.
The purpose of my application is for different clans of gaming communities to be able to find other clans so that they can organise 'scrims' (practice matches). The front end of this application has a form with a set of text boxes. One set is for creating a scrim and the other is for finding a scrim.
So basically, a person fills in the boxes and uploads their scrim details onto the database. While another person fills in the other boxes and the database is searched with their entries. After this, below the textboxes, the search results are displayed in a table form.

Sorry for the long explanation but i had to describe it well so ppl would know what i was trying to do.

My first question is: is this possible
second q: If so, what will I need and what is the best way to do it
I have thought of mySQL and xml but dont know which one would be the most suitable.

Thanks in advance!



Re: Visual Basic General Online database

Joshua Morgan

Your best bet is hosting this solution with an ISP, unless you have a database server and a web server with static IP addresses.

It is very possible and I would recommend using web services to interact with your windows application. The web services will be the 'middle tier' between your database and your windows application clients.

You can use mySQL or MS SQL. Though make sure you have an ISP that provides hosting for ASP.NET applications.






Re: Visual Basic General Online database

coombzee

Thanks for the help.

I have looked around and i think my best bet might be with a PHP and mySQL setup.
Does the IP address of the server have to be static or can i refer to it thru a url

Also, my plan is to embed the database into my application so users can make entries, search entries and view entries.

Many thanks.




Re: Visual Basic General Online database

Joshua Morgan

You could find a work around over using a static IP, but it would just be easier to get a static IP.

You can embed a DB with your application. For a small app, maybe you should consider MS Access.






Re: Visual Basic General Online database

coombzee

ok, it sounds like a static IP is cumpulsory.
just so you know, im using Visual Basic 2005 .NET Express Edition so there may be limitations which im not aware of.

do you know of any tutorials that would help me in setting up an online MS Access database and then implementing that into a VB application I've used Access before so thats fine. its just the online and emedding part that im stuck on.

thanks all.




Re: Visual Basic General Online database

Joshua Morgan

This a good place to get started.

http://www.asp.net/getstarted/default.aspx tabid=61