Help coderanch get a
new server
by contributing to the fundraiser
  • 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Access DB

 
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Die Fledermaus does not fear such a tiny ad:
We need your help - Coderanch server fundraiser
https://coderanch.com/t/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic