Database manpulation without connecting to a server...

[Sebouh]

Hi guys. I'm completely new to databases, so i wanna ask you if this is achievable.

I've been learning how to connect to an MS SQL database file with java. I've finally learned the basics, connecting and manipulating... but here's what i wanna do. I don't want to connect to a server to change the database content. I want to have the database file inside the application folder and manipulate it directly from there, without logging on to some server. I want to carry the application with me to any computer and be able to use the database file without connecting to a server.

Is this possible? If so, how?

Thanks.

[vksingh24]

Hi guys. I'm completely new to databases, so i wanna ask you if this is achievable.

I've been learning how to connect to an MS SQL database file with java. I've finally learned the basics, connecting and manipulating... but here's what i wanna do. I don't want to connect to a server to change the database content. I want to have the database file inside the application folder and manipulate it directly from there, without logging on to some server. I want to carry the application with me to any computer and be able to use the database file without connecting to a server.

Is this possible? If so, how?

Thanks.

You can use the MS-Access as your database. You can carry this database with your computer anywhere. Also, If you don't want to connect to the database at all, you need to design a robust front end which does all the database chagnes behind.

[Sebouh]

Well, i guess not connecting is out of the question...

So if i use MS Access, the computer i run the application on must have MS Access then?

[vksingh24]

Well, i guess not connecting is out of the question...

So if i use MS Access, the computer i run the application on must have MS Access then?

Not necessarry.

If you are concerned with that, use XML as your database.