?
Solved

OpenOffice Base - Read MS SQL

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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

762 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