Can someone point me in the right direction?

[memevertical2]

Lately I've been working on applications that read a MDB database.....and the language used inside Delphi is SQL, with the ADOquery.....

But now I need to develop a similar application, but in multiple computer that all read from the same database.....I guess for this I need to use a SQL server.....but I'm lost in that department.....

Can someone point me in the right direction?

Thanks.

 

[lespaul]

MDB being an Access database? you can use an access database with multi users (which I guess is what you mean by "multiple computer all reading from the same database")...what makes you think you can't do what you need with access? how many consecutive users are you expecting?

Leslie

Have you met Hardy Heron?

 

[memevertical2]

Oh, well, I just assumed SQL Server handles multi-user better.....but if I can do it with MDB better yet, so on each computer a just point to the network address where the database is??? or how can I do it?

 

[whosrdaddy]

memevertical2,

don't go the multiuser route with access, it's not made for that. SQL server is what you need. depending on how many concurrent users you have, you can use the free version of sql server (sql server express 2005). I personally use MySQL, but it's a matter of personal taste...

tell us more and we will nudge you in the good direction.

Cheers,

Daddy

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!

 

[memevertical2]

Thanks,

I believe there will no more than 5 users. The application will handle the basic information from the Database, it will load info at startup, and the user will input info, retrieve info, print reports.....the basic stuff.....

What I would like to know is how to install the SQL Server, how to load from delphi the database.... I assume that when using ADOquery, the sql statements will be the same, right?

Thanks

 

[lespaul]

well something more robust than Access will handle multi user better but Access can do multiuser.

Leslie

 

[whosrdaddy]

[/quote]
well something more robust than Access will handle multi user better but Access can do multiuser

yes that's true, BUT for multiuser, you need some kind of network share for all users and from my personal experience the access db becomes easily corrupted after network problems. So I really can't recommend it.

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!

 

[roo0047]

I guess for this I need to use a SQL server

If you're asking if you need to setup a Server to run SQL queries with multiple users, then no.

Install the database (any that have already been suggested) on any workstation within your networked workgroup and set it up as "shared". You can simplify it further by having all user machines map a drive letter to the folder of the machine where the tables are located, aka: the database.

Roo
Delphi Rules!

 

[DjangMan]

There are other databases that work with Delphi that are out there. For that number of users I wouldn't hesitate using an Access database for your application. Price is sometimes a consideration. There are some awesome databases - Firebird and MSSQL Express which you can get for free - but they both require further knowledge on how to install and configure and troubleshoot.