Solved

OpenOffice Base - Read MS SQL

Posted on 2013-06-04
4
648 Views
Last Modified: 2013-06-06
Hello Experts,

I've created a set of tables in an OpenOffice database called Surveys.odb. I'd like to link or read records from tables in a MS  SLQ Server 2005. I've been able to create the connection to the server through OpenOffice but only using a seperate odb file called "RMS Connections.odb".

Can I create a link between the two odb files? I need to lookup transaction details in the MS SQL server from the Surveys.obd.

FYI, I can copy a table from MS SQL Server into the Survey.odb database, but that's less than ideal as the tables can be quite large. Also, how would I automatically update the copied table?

Thanks,

Ron
0
Comment
Question by:bikeski
  • 2
  • 2
4 Comments
 
LVL 20

Expert Comment

by:ltlbearand3
ID: 39220841
Open Office Base cannot connect to two data sources at once.  Base is not really meant to be a database itself, but more of a front end to an attached DB.  Perhaps you could describe a little more what you are trying to accomplish and we could propose a different type solution.  There are other free Databases out there and other tools to create the front end or to query them.  There may even be other ways in Open Office/Libre Office to get you your intended result.

-Bear
0
 

Author Comment

by:bikeski
ID: 39223243
Hi Bear,

Thanks for the insight on OpenOffice. Sounds like we need to look at a different solution.

Our main business database is on the SQL server with all the customer info, sale person data, transactional history, product description, etc. We survey customers and employees on various aspects of our business. I'm looking to store the survey data (imported through CSV files) and then reference the revelvant transactional data from the business database for reporting purposes.

Thanks,

Ron
0
 
LVL 20

Accepted Solution

by:
ltlbearand3 earned 500 total points
ID: 39224579
Ron,

In that scenario Open Office Base is probably not the best option.  The next question is, what are you currently using to generate the reports?  You can set up a query off the csv file.  If you are needing the csv files combined together in a single table, then I would look at generating a new SQL Server table on your existing SQL Server.
0
 

Author Closing Comment

by:bikeski
ID: 39227581
Bear,

We have decided to create a new database and tables on the SQL Server and use existing tools to generate the reports. Thanks.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Query 2 63
Updating statistics with error notification email in SQL server 4 110
CROSS APPLY 4 57
Replace Dates in query 14 51
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question