Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

OpenOffice Base - Read MS SQL

Posted on 2013-06-04
4
Medium Priority
?
725 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 1500 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

597 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