Home » Other » General » connect oracle 10g with openoffice.calc
connect oracle 10g with openoffice.calc [message #572719] Sun, 16 December 2012 10:36 Go to next message
myadi26
Messages: 7
Registered: December 2012
Location: india
Junior Member
Hi,
I have created odbc connection for oracle so that the data i will update in excel sheet that will be updated in my oracle database.
I am using oracle database 10g on Windows XP.
My openoffice.calc version : openoffice.org 3.0.0
I followed these steps:
start menu => settings => control panel => administrative tools => data sources(odbc)

odbc => user dsn tab => add => select driver name => microsoft odbc for oracle .
=> data source name: demo_dsn
description : any
username : hr
server : orcl (from tnsnames.ora)

open openoffice.calc

file => new => database

database wizard dialog box:

select connect to an existing database => odbc => next => odbc ds name: browse : demo_dsn => next => user name :hr(check password check box) => click on test connection
=> enter password=> connection established successfully.
All the tables in HR schema are now showing in my excel db.When am updating data in oracle, update is showing in my excel sheet.But the reverse
is throwing error. when am trying to update data from excel sheet its showing

Error updating the current record.
[Microsoft] [ODBC driver manager]driver does not support this attribute/option
identifier.

Thanks in advance.
Re: connect oracle 10g with openoffice.calc [message #572720 is a reply to message #572719] Sun, 16 December 2012 10:57 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is an OpenOffice question not a Oracle database one.
I'm not sure you have chosen the correct forum to get an answer.
I move your topic from SQL to General (sub)forum as we have no forum for this (new) part of Oracle.

Anyway, I'm not sure there is some direct read/write ways to do this, that is without programming anything.

Regards
Michel
Previous Topic: UNDO tablespace is full
Next Topic: rsync - Oracle directories
Goto Forum:
  


Current Time: Fri Mar 29 07:02:18 CDT 2024