SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 phpMyAdmin connection to spreadsheet
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jasonlive
Starting Member

1 Posts

Posted - 09/25/2013 :  01:48:05  Show Profile  Reply with Quote
hi folks,

i have written a nice little php page that submits employee timesheets to a phpMyAdmin database. Currently the DB is stored on my Mac using MAMP with address localhost:8889. the username is root.
its all running great from php.

the long term goal is to have the database hosted online and i will need to connect to it from mac and windows machines.

for now my issue is i want to connect to the localhost db from libreoffice ( and excel from a windows machine) and be able to query to the spreadsheet.
i have no idea how to begin to do this. im getting asked all sorts of things like "datasource url" and "driver class". i have no idea how to fill in these fields. i have only a blank spreadsheet at the moment. is there a tutorial on this or any guidance somewhere!
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000