Win a copy of Event Streams in Action this week in the Java in General forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Devaka Cooray
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Paul Clapham
  • Knute Snortum
  • Rob Spoor
Saloon Keepers:
  • Tim Moores
  • Ron McLeod
  • Piet Souris
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Frits Walraven
  • Ganesh Patekar

Access DB

 
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Mark Leong
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).]
 
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Author
Posts: 377
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!