If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Standalone DB to Replace MDB?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-20-08, 22:07
fwhilton fwhilton is offline
Registered User
 
Join Date: Nov 2006
Posts: 11
Standalone DB to Replace MDB?

Hi,
Is there a standalone database that can replace MS Access for use on a Unix web server?

I know there is MySQL... but I want something that I can move easily on web servers as well as use them on a desktop.

Thanks
__________________
My Sites: TechniPixel SolutionsGive Us A DealFrank HiltonWord-Spirit
Reply With Quote
  #2 (permalink)  
Old 11-20-08, 22:53
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
You can use DB2 Express-C, which is free for development and production and runs on Windows and Linux. You can use it on any size machine, but the DB2 engine will only use 2 CPU cores (one dual-core CPU, etc.) and 2 GB of memory maximum. There is no limit on database size.

DB2 Express-C V9.5 FP2 betas are available, and I would get those instead of FP 0 release (regular V9.5). The beta is for packaging only, FP 2 has been available for the real DB2 code (the one that costs $30K per CPU) for at least a month.

http://www-01.ibm.com/software/data/...s/support.html
http://www-01.ibm.com/software/data/.../download.html

DB2 does not come with a good query tool like Access does, but you can use many 3rd party tools, including Access, to get data out of DB2.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #3 (permalink)  
Old 11-21-08, 05:34
fwhilton fwhilton is offline
Registered User
 
Join Date: Nov 2006
Posts: 11
Thanks

Is that all the choices?

__________________
My Sites: TechniPixel SolutionsGive Us A DealFrank HiltonWord-Spirit
Reply With Quote
  #4 (permalink)  
Old 11-21-08, 07:03
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
Quote:
Originally Posted by fwhilton
Thanks

Is that all the choices?

This section of the forum is about IBM's DB2 product (not dBase in case you are confused). If you don't like it, go somewhere else.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #5 (permalink)  
Old 11-21-08, 07:09
fwhilton fwhilton is offline
Registered User
 
Join Date: Nov 2006
Posts: 11
Quote:
Originally Posted by Marcus_A
This section of the forum is about IBM's DB2 product (not dBase in case you are confused). If you don't like it, go somewhere else.
ummm... wow.
Why are you talking to me like that?

I do not see a general section to ask general questions. I am only asking for a broad list of options to choose from.

I don't know which thread on DBForum to ask this.

God Bless you
__________________
My Sites: TechniPixel SolutionsGive Us A DealFrank HiltonWord-Spirit
Reply With Quote
  #6 (permalink)  
Old 11-21-08, 07:48
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
Quote:
Originally Posted by fwhilton
ummm... wow.
Why are you talking to me like that?
I was kind enough to provide you with information about DB2 Express-C, the finest free database on the planet (I sensed you wanted something "free" or very inexpensive), including links to other sources and the download site. Instead of a "thank you" I get "Why are you talking to me like that" and a condescending and insincere "God Bless you" as you try to put me in my place.

As I previously stated "This section [the DB2 section] of the forum is about IBM's DB2 product." It is not a place to discuss which other products besides DB2 that one should consider. I am sure there are other forums, newsgroups, or websites where you can get information about that.

Now tell us the truth, did you think this was dBase forum?
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #7 (permalink)  
Old 11-21-08, 08:01
fwhilton fwhilton is offline
Registered User
 
Join Date: Nov 2006
Posts: 11
Quote:
Originally Posted by Marcus_A
I was kind enough to provide you with information about DB2 Express-C, the finest free database on the planet (I sensed you wanted something "free" or very inexpensive), including links to other sources and the download site. Instead of a "thank you" I get "Why are you talking to me like that" and a condescending and insincere "God Bless you" as you try to put me in my place.

As I previously stated "This section [the DB2 section] of the forum is about IBM's DB2 product." It is not a place to discuss which other products besides DB2 that one should consider. I am sure there are other forums, newsgroups, or websites where you can get information about that.

Now tell us the truth, did you think this was dBase forum?
Ummmm?? What is going on here? Condesending???

When I posted.. I put smiley faces in the thread.

I am thankful that you said DB2. I was just wondering if there were more.
I asked you why you were talking like that because you told me to go to another forum.

QOUTE: "If you don't like it, go somewhere else" (that is kind of odd)

I told you before I only posted in this thread because there were no other threads for general DB questions.

And NO... i didn't know that this forum is dbase only forum. The title says DBForums and I see several threads on all kinds of databases.

So, I am a little perplexed by your response to "go to another forum"...
did you mean another thread?

I am sorry if you misunderstand why I am asking.
You are totally taking my response wrong.

__________________
My Sites: TechniPixel SolutionsGive Us A DealFrank HiltonWord-Spirit

Last edited by fwhilton; 11-21-08 at 08:09.
Reply With Quote
  #8 (permalink)  
Old 11-21-08, 08:06
fwhilton fwhilton is offline
Registered User
 
Join Date: Nov 2006
Posts: 11
Also... check post #3...

I said Thanks!!

__________________
My Sites: TechniPixel SolutionsGive Us A DealFrank HiltonWord-Spirit
Reply With Quote
  #9 (permalink)  
Old 11-21-08, 08:13
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
Quote:
Originally Posted by fwhilton
And NO... i didn't know that this forum is dbase only forum. The title says DBForums and I see several threads on all kinds of databases.
This is not a dBase forum, it is for IBM's DB2 database product. There are other sections of the dbfourms for other databases, and one for "other."
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #10 (permalink)  
Old 11-21-08, 08:15
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
Quote:
Originally Posted by fwhilton
When I posted.. I put smiley faces in the thread.
But you weren't smiling when you posted that, were you?
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #11 (permalink)  
Old 11-21-08, 08:19
fwhilton fwhilton is offline
Registered User
 
Join Date: Nov 2006
Posts: 11
Quote:
Originally Posted by Marcus_A
But you weren't smiling when you posted that, were you?
Marcus,
Go back and look at ALL my threads... they all have smiley faces.
And.. especially look at #7, which is the post you are referring to.... it has two smiley's

And I really mean this... Jesus Loves You

__________________
My Sites: TechniPixel SolutionsGive Us A DealFrank HiltonWord-Spirit
Reply With Quote
  #12 (permalink)  
Old 11-24-08, 04:23
stolze stolze is offline
Registered User
 
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,662
Could you please be considerate and avoid religious things here? I don't like missionaries, especially not when doing something work-related.

Stick to the point you try to make or the question you want to ask. Everything else borders on (or already is) offensive to various people.
__________________
Knut Stolze
IBM DB2 Analytics Accelerator
IBM Germany Research & Development
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On