Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Dbase Solution. HELP!

  1. #1
    Fastest Thing Alive s0nIc's Avatar
    Join Date
    Sep 2001
    Location
    Sydney
    Posts
    1,584

    Unhappy Dbase Solution. HELP!

    Hi Guys!

    First of all, glad to be back. It's been yonks since my last visit. Been busy with work and family. Yes me and angelic_ky got married and now have a little girl.

    Anyhow, to my question. I need to create a database app for work. Thing is, our machines at work do not have MS Office, so using Access is out of the question. We do however have OpenOffice.

    My question is, what would be a reliable and quick soltion...

    1) just create the dbase app using Open Office
    2) create dbase on MS Access and just code a FrontEnd using VB.NET.

    Thing is, I've done MS Access dbase with a custom FE coded using VB.NET. However, it is a pain to do the FE coz of all the components I have to code (the gui, classes, the bit that convers vb commands to sql, the bit that connects the client to the remote dbase, etc).

    I need the database to be accessed by multiple user at same time, and i'm not sure if OpenOffice allows that.. actually I'm not sure anything about OpenOffice.

    Any ideas?

  2. #2
    Senior Member nihil's Avatar
    Join Date
    Jul 2003
    Location
    United Kingdom: Bridlington
    Posts
    17,188
    Hi,

    I would just do a small POC with Open Office. Base will support multiple users in read mode, but I am not sure if the whole database is locked when a single user is updating it. The point is that these apps are "containers" rather than true databases and they may not handle record locking too elegantly.

    All you need do is create a database with a couple of records in it on your network. Log on in update/amend mode then see if you can log in as a different user.



    Incidentally, the latest version of oo is 2.4

  3. #3
    Shadow Programmer mmelby's Avatar
    Join Date
    Jul 2002
    Location
    Ft. Myers, FL
    Posts
    291
    What kind of DB are you looking to create?

    What is the OS of the back end server?

    What is the OS of the clients?

    Is just an application with basic functionality?

    Does it need to be web based?

    Just some questions that might help us give you a better direction
    Work... Some days it's just not worth chewing through the restraints...

  4. #4
    Ninja Code Monkey
    Join Date
    Nov 2001
    Location
    Washington State
    Posts
    1,027
    Why not use sql server express or mysql?
    "When I get a little money I buy books; and if any is left I buy food and clothes." - Erasmus
    "There is no programming language, no matter how structured, that will prevent programmers from writing bad programs." - L. Flon
    "Mischief my ass, you are an unethical moron." - chsh
    Blog of X

  5. #5
    Senior Member
    Join Date
    Dec 2001
    Posts
    319
    In the latest version of .NET, they made working with databases a whole lot easier. Read up on LINQ.

    In response to your question, though, we need some more info than that. Are you locked into a particular backend if it is MS-based? How many users will be accessing the DB? Will it need to be relational?

  6. #6
    Senior Member
    Join Date
    Oct 2003
    Location
    MA
    Posts
    1,052
    The most practical DB for small stuff is MySQL and Oracle for big stuff IMO. I tend to stay away from MSSQL but all 3 are relational so I am not sure why you would ask that delstar...

    And running a database server for a flat DB is kind of useless, you might as well just use a text file :-P

  7. #7
    Senior Member
    Join Date
    Dec 2001
    Posts
    319
    Quote Originally Posted by oofki
    And running a database server for a flat DB is kind of useless, you might as well just use a text file :-P
    Not necessarily. One advantage would be that multiple users could access at the same time, which is a requirement. You could simulate that with a text file, but if you have more than 2 or 3 users, I wouldn't suggest it. In response to why I would ask, there's more out there than just those 3.

  8. #8
    Member
    Join Date
    May 2008
    Posts
    34
    The biggest issue is the number of concurrent users and the total size of the database over time. If this is business-related, I would personally suggest SQL Server. Oracle is great, if you have plenty of RAM. MySQL is good if you like PHP and open source. You can get a version of SQL Server 2000 for free, at least as long as you keep the size under 2 GBs. That might be perfect for a small business. The .NET framework supports it easily. (Don't forget to use read and write locks so that you keep data integrity, and implement a time-out so that the program will wait for a user rather than aborting the instant it encounters a lock.)

  9. #9
    Ninja Code Monkey
    Join Date
    Nov 2001
    Location
    Washington State
    Posts
    1,027
    Why go sql server 2000 when you can get the equivalent in sql 2k5 for free?

    You can also use ado.net with mysql, you just need to pick up a decent mysql driver.
    "When I get a little money I buy books; and if any is left I buy food and clothes." - Erasmus
    "There is no programming language, no matter how structured, that will prevent programmers from writing bad programs." - L. Flon
    "Mischief my ass, you are an unethical moron." - chsh
    Blog of X

  10. #10
    Senior Member
    Join Date
    Dec 2001
    Posts
    319
    Quote Originally Posted by Juridian
    Why go sql server 2000 when you can get the equivalent in sql 2k5 for free?
    You can't get SQL Server 2k5 for free. You can get SQL Server 2k5 Express for free. Unfortunately, the Express edition doesn't allow remote connections, which is a requirement

Similar Threads

  1. Hardware Security Solution?
    By AngelicKnight in forum Network Security Discussions
    Replies: 4
    Last Post: June 22nd, 2005, 12:02 AM
  2. ADSL Troubleshooting Methodology
    By Computernerd22 in forum General Computer Discussions
    Replies: 5
    Last Post: May 24th, 2005, 12:49 AM
  3. Denial of Service
    By M@rin3 Snip3r in forum AntiOnline's General Chit Chat
    Replies: 6
    Last Post: September 24th, 2003, 03:59 AM
  4. old dBase IV files
    By whooper in forum Cryptography, Steganography, etc.
    Replies: 0
    Last Post: December 10th, 2002, 06:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •