Re: [libreoffice-users] Connection to SQL database

Carl ,

Use a mySQL database and connect over the Native Connector

then google for the book "DataBase Programming" writen by Roberto 
Benitez  for Openoffice but also for LibreOffice
a lot of code can been found on the Book-website

Greetz

Fernand


On 15/01/2014 16:55, Ryan Ashley wrote:
> SQL files are normally SQL scripts which are backups or scripts that 
> create a database on a SQL server. If you need something in that 
> script, you would need to setup a MySQL server, execute the SQL file 
> on that server, and then get the data out that you need. I know that 
> is a mouthful, and the process varies based on your operating system 
> (Linux, Windows, Mac, etc).
>
> After you do the above, you can connect with base, but you could also 
> get your data out using the MySQL Workbench tool or even a 
> command-line if you are using Linux. I can help you if somebody else 
> doesn't help first, but I need to know what OS you are running to be 
> able to help you further.
>
> On 01/15/2014 10:51 AM, Carl Paulsen wrote:
> > I have a project for which I need to extract data that is in a .sql 
> > file (presumably a SQL database).  I've done very little with SQL so 
> > I need some guidance on doing this.  One route would be to open it 
> > with Base or Access (I now finally have access to MSAccess on a 
> > Windows machine but would prefer Base), but I don't understand the 
> > basics of doing this.
> >
> > So...can someone point me to a tutorial on how to do this, 
> > step-by-step and from the very beginning?  For instance, do I need to 
> > set up a SQL server and if so, how?  (I've tried installing XAMP with 
> > MySQL on the Windows machine but haven't gotten it to connect to the 
> > file yet.)  Can I access a .sql file directly or via other methods?  
> > I'd like to eventually learn how to use SQL but I'm also on a pretty 
> > limited timeframe on accessing this data.
> >
> > Or does someone want to outline the steps here for me to research on 
> > my own?
> >
> > Thanks very much,
> > Carl


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted