Home » Open Source » Programming Interfaces » Excel to Ora tool (Ora 10g)
Excel to Ora tool [message #435068] Mon, 14 December 2009 02:55 Go to next message
vdsk
Messages: 41
Registered: February 2006
Location: India & UAE
Member
I have a VB utility which connects to 10g db and helps in customisation of a d2k application. It was working well, but now gives error as 'Oracle error occurred,but error message couldn't be retrived from Oracle'. I rechecked MS-ODBC for Oracle in my WinXP client but same result.
Same error in another VB utility used for importing data from Excel to Ora. Is it really anything to do with ODBC ?
Re: Excel to Ora tool [message #435074 is a reply to message #435068] Mon, 14 December 2009 03:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you install Oracle client?
Does your environment variables point to the Oracle home (ORACLE_HOME, PATH)?

Regards
Michel
Re: Excel to Ora tool [message #435082 is a reply to message #435074] Mon, 14 December 2009 04:07 Go to previous messageGo to next message
vdsk
Messages: 41
Registered: February 2006
Location: India & UAE
Member
thanks ..
My client connxn is ok..SQL+ and other applcn tools are connecting ..I am attaching even my TNSNAMES.ORA here.
But still have problm.......

  • Attachment: TNSNAMES.ORA
    (Size: 1.45KB, Downloaded 1789 times)
Re: Excel to Ora tool [message #435099 is a reply to message #435082] Mon, 14 December 2009 05:09 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
My client connxn is ok..SQL+ and other applcn tools are connecting ..

Yes, but does this one has the correct environment?

Regards
Michel
Previous Topic: HS: Oracle / PostgreSQL
Next Topic: jdbc thin client
Goto Forum:
  


Current Time: Thu Mar 28 16:05:13 CDT 2024