Apache2Triad Help, Support and Development Forum Index Search Profile Log in to check your private messages Log in Register Memberlist Attachments Statistics Crew/Ranks Archive
 Open Office and Postgresql
Google
Post new topic Reply to topic
Author Message
chuck_dubois
 
 


Joined: 20 Mar 2005
Posts: 4

PostPosted: Sun Mar 20, 2005 12:36 am Reply with quoteBack to top

How can I configure Open Office to work with Postgresql database through apache2triad server?
View user's profileSend private message
Vlad Alexa Mancini
lead developer
lead developer


Joined: 07 Jul 2003
Posts: 1539

PostPosted: Sun Mar 20, 2005 10:43 am Reply with quoteBack to top

Apache2triad provides Postgresql , yoo do not connect to postgresql trough apache2triad , once apache2triad laid it into place you would connect to directly to Postgresql from OpenOffice

Making such a connection requires a wrapper layer like odbc , jdbc or sdbc

While such a wrapper is installed in apache2triad for mysql you would have to wait untill apache2triad 1.5.2 to have one for postgres too

But fortunately that should be any day now
View user's profileSend private message
chuck_dubois
 
 


Joined: 20 Mar 2005
Posts: 4

PostPosted: Sun Mar 20, 2005 1:46 pm Reply with quoteBack to top

Thanks,
I am looking foward to the new version of Apache2Triad that will allow me to connect to Postgresql in Open Office. How then do you connect to Mysql and can I assume that connecting to Postgresql will be the same?
This forum is great!
Thanks,
Chuck DuBois(ced142@psu.edu)
View user's profileSend private message
Vlad Alexa Mancini
lead developer
lead developer


Joined: 07 Jul 2003
Posts: 1539

PostPosted: Sun Mar 20, 2005 2:16 pm Reply with quoteBack to top

here are details about how to do that under linux

http://users.binary.net/thehaas/pgodbc-ooo-howto.html

with some adaptation it should work on windows too

maybe i will have the time to install openoffice and make a walktrough for windows
View user's profileSend private message
chuck_dubois
 
 


Joined: 20 Mar 2005
Posts: 4

PostPosted: Sun Mar 20, 2005 2:34 pm Reply with quoteBack to top

That would be great!!!
I noticed Apache2Triad 1.5.2 is in beta stage. Do you think it is mature enough to try out Open Office and Postgresql?
View user's profileSend private message
Vlad Alexa Mancini
lead developer
lead developer


Joined: 07 Jul 2003
Posts: 1539

PostPosted: Sun Mar 20, 2005 3:54 pm Reply with quoteBack to top

Turns out its was really easy and i had it configured in no time

Basically all you have to do after having installed openoffice and apache2triad 1.5.2 is go trough the openoffice Data Source Administration menu the screenshot of which i attached below , and the windows ODBC Data Source Administrator , that i also attached

The first can be accessed in openoffice from Tools-> Data Sources , the later from the same place by pressing Organize or by running "%SystemRoot%\system32\odbcad32.exe"

There are quite a extensive number of options that can be configured from the named interfaces but you generally only need to set the , hostname , username , dbname and password

You can go at it using today's apache2triad build from the beta downloads folder


Last edited by Vlad Alexa Mancini on Sun Mar 20, 2005 5:18 pm; edited 1 time in total
View user's profileSend private message
chuck_dubois
 
 


Joined: 20 Mar 2005
Posts: 4

PostPosted: Sun Mar 20, 2005 4:11 pm Reply with quoteBack to top

Thanks,
I'm sure that will help me alot. I will not be able to try it till tommorrow though because I have a dialup connection at home. I'll download at work tommorrow and give it a try. I hope it is as easy as you say.

Thanks,
Chuck DuBois(ced142@psu.edu)
View user's profileSend private message
Display posts from previous:      
Post new topic Reply to topic


 Jump to:   



View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum
Powered by phpBB © 2001, 2002 phpBB Group :: FI Theme
All times are GMT