Solved

OpenOffice Base - Read MS SQL

Posted on 2013-06-04
4
637 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

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…
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 …
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

919 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now