Deployment without installing SQL

[emjez15]

Hi there,


I just wanna ask if there could be a way to install a VB. NET App without installing SQL Server in the computer where the app is installed. Like a built in database.
Coz' what I know right now is you have to install the SQL express(for instance) in the computer you want to install.
I want to do it like in MS Access (the system can simply have to access the mdb file in the bin folder)

thank you
-EM

 

[jacky.goy]

You may try on Firebird SQL. They have embedded server which no need to install the SQL server on the computer where app is installed but embedded server only support standalone. If your app need multiple concurrency access from other network workstation then you need to install SQL server instead.

 

[emjez15]

Thanks!, that's what I needed.
One more thing. I'm creating a man power agency processing system.
So what I just need is a server for data storing and a client(10 users) is just to input/update data & create reports.
Is is applicable/practical to use firebird sql for that?

 

[jacky.goy]

Ya, you can use firebird SQL for that. (the coolest part... this firebird SQL is FREE!!!)
Just install firebird SQL Server at the server which the db to be stored then on the app of client's pc you need to set the connection string to point to the server.

 

[emjez15]

wow thanks, i'll try it now, i'll let you know the result.