Solved

OpenOffice Base - Read MS SQL

Posted on 2013-06-04
4
657 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Why You Need a DevOps Toolchain

IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.

Question has a verified solution.

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

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

739 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