aspose file tools*
The moose likes Other Java Products and Servers and the fly likes Access DB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Other Java Products and Servers
Bookmark "Access DB" Watch "Access DB" New topic
Author

Access DB

Mark Leong
Ranch Hand

Joined: Dec 11, 2000
Posts: 60
Anybody knows how to create Access DB using SO 5.2?
I can use it to access and modify mdb files but cannot seem to create them.
Floyd Jones
Greenhorn

Joined: Dec 13, 2000
Posts: 25
Howdy Mark -
You can't actually create Access databases with SO. You can, as you mentioned, access and modify them in SO. That's the deal. If you want to create relational databases in SO, the Adabas D format is what you'd use. If you want to create single, non-relational tables, use the dBase format.
------------------
author of:
StarOffice Companion
Standard CYA*******************************
All responses to questions posed in this News Group are given on an
"as is" basis. We believe the solutions or explanations given here are
correct, but do not guaranty that responses will be complete, without
error and/or work for all platforms and system configurations.


author of:<BR><A HREF="http://www.amazon.com/exec/obidos/ASIN/0130307033/electricporkchop" TARGET=_blank rel="nofollow">StarOffice Companion</A>
Mark Leong
Ranch Hand

Joined: Dec 11, 2000
Posts: 60
Actually that's what I thought. Just want to be sure.
Is there a way I could access Adabas db using JDBC? If yes, where do I get the drivers and how to specify the DBUrl and driver?
Floyd Jones
Greenhorn

Joined: Dec 13, 2000
Posts: 25
Mark -
My expertise with Adabas D stops at creating them in SO and setting up relations between tables. I don't know how you'd access them from an outside app. Sorry I can't be more help.
------------------
author of:
StarOffice Companion
Standard CYA*******************************
All responses to questions posed in this News Group are given on an
"as is" basis. We believe the solutions or explanations given here are
correct, but do not guaranty that responses will be complete, without
error and/or work for all platforms and system configurations.
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
These links are to companies that have JDBC drivers specific to Adabas:
http://www.i-kinetics.com
http://www.informationbuilders.com
http://www.adabas.com
http://www.sas.com
http://www.trifox.com
I guess I would recommend using the driver written by Software AG since they are the Adabase guys. Anyway, this link details the use of their driver, including the connection url that you will need.
[This message has been edited by Bodie Minster (edited December 21, 2000).]
tony hutcheson
Ranch Hand

Joined: Dec 08, 2000
Posts: 38
I know this was posted a long time ago, but I wanted to respond because it helped answer a question I had.
I tried "creating" a database with Star Office and was frustrated rather quickly. The help files were not very clear from the start that SO does not have the stuff to create a database, only to connect to them (unless you install Adabas D). I will try either DB2 or Adabas and then connect it to SO.
Star Office has not disappointed, just frustrated a couple of times. Knowing is more than half the battle.
Solveig Laura Haugland
Author
Ranch Hand

Joined: Oct 24, 2000
Posts: 377
Originally posted by tony hutcheson:
I know this was posted a long time ago, but I wanted to respond because it helped answer a question I had.
I tried "creating" a database with Star Office and was frustrated rather quickly. The help files were not very clear from the start that SO does not have the stuff to create a database, only to connect to them (unless you install Adabas D). I will try either DB2 or Adabas and then connect it to SO.
Star Office has not disappointed, just frustrated a couple of times. Knowing is more than half the battle.

Hi Tony,
You definitely can create databases using StarOffice. See "Creating Databases" on page 992 of "StarOffice Companion" for more info. You can create dBase (nonrelational)and Adabas D databases. And I think can add a table to Access 97 databases. It's definitely not the most intuitive approach, but it's possible.
I think you can also do drag-and-drop to turn a spreadsheet into a dBase database--that's the easiest way to create a database. (Page 1004.)
Hope this works,
Solveig

------------------
author of:
StarOffice Companion


OpenOffice.org Users' Guides, Training, and More www.getopenoffice.org
J2EE: The Big Picture - Dating Design Patterns: What the Gang of Four Didn't Tell You - Dating Power Tools: Simple Stuff That Works - She'll Love It: The Guys' Guide to Giving Great Gifts
 
Don't get me started about those stupid light bulbs.
 
subject: Access DB