OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Anyone using Base with Ingres?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
shearerg@onesteel.com
Newbie
Newbie


Joined: 05 May 2007
Posts: 2

PostPosted: Sun May 06, 2007 2:34 pm    Post subject: Anyone using Base with Ingres? Reply with quote

Hi all,
I'm new to OO but am keen to have it replace an existing Excel reporting system. I have Ingres II r3 installed on Linux and would like to use OO (Base, Calc) also on Linux to replace the current reports running under Win 2000.

I've installed the latest OO release OK.
I've configured both odbc and jdbc data sources in Base which test OK
..... but I can't get either to successfully return data into Calc.
Quite frustrating.

odbc returns data into Base OK, and some data into Calc .... but leaves date fields blank.
jdbc tests OK in Base ... but crashes Base when attempting to return any data.

I'm also chasing this in Ingres forums, but would like to know if anyone is successfully using OO with Ingres data sources. A quick search of the forum seems to suggest that this is not the case .... but thought I'd ask the question anyway.

Here's hoping,
Greg Shearer
_________________
Greg Shearer
Back to top
View user's profile Send private message
jpzuate
Newbie
Newbie


Joined: 03 Oct 2007
Posts: 1
Location: France

PostPosted: Wed Oct 03, 2007 8:19 am    Post subject: Reply with quote

Hello,

You're not alone to try using OO with Ingres. In my case i did some tests with OO 2.1 to OO 2.3, each time with Ingres2006 (the next R3).

In all cases I fall on the same issues you fall. For ODBC, if OO Base present me a table list, it is impossible to update data : this is due to the lake of Update ODBC Driver in Ingres distribution.

When I connect with JDBC, I can't see my table list but I'm able to run queries.

And, important to note, all my Ingres versions work well in Java environment (with DB Visualizer [http://www.dbvis.com/products/dbvis/] for example).

Sure this is not helping you, but keep in mind we are 2 now Smile

Regards,
Jean-Pierre
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
shearerg@onesteel.com
Newbie
Newbie


Joined: 05 May 2007
Posts: 2

PostPosted: Wed Oct 03, 2007 2:09 pm    Post subject: Reply with quote

Jean-Pierre,

Thanks for the reply. I haven't been actively pursuing this since my earlier disappointment, but will undoubtedly look into it further over the next few months. Good to know I'm not alone. If you have success in the future, please post another reply.

Thanks,
Greg
_________________
Greg Shearer
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001, 2005 phpBB Group