| Microsoft ODBC for Oracle [message #125074] |
Thu, 23 June 2005 02:49  |
udayk
Messages: 2
Registered: June 2005
Location: India
|
Junior Member |
|
|
i want to create microsoft odbc driver for oracle.. but it's giving error message..
Oracle (tm) client and networking components not installed.. etc.
how do i solve this error ?
where do i find this install ?
|
|
|
|
| Re: Microsoft ODBC for Oracle [message #125079 is a reply to message #125074] |
Thu, 23 June 2005 03:19  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
before using odbc for connectivity with oracle, oracle client needs to be installed on this machine. By doing this, you will be installing all netwoirk related componenets required by oracle for connectivity purpose.
Regds
Girish
|
|
|
|
| Re: Microsoft ODBC for Oracle [message #125081 is a reply to message #125079] |
Thu, 23 June 2005 03:29 |
udayk
Messages: 2
Registered: June 2005
Location: India
|
Junior Member |
|
|
i already have oracle client installed on my machine,
but not able to solve the error of odbc...
i need this to import data from oracle to excel
can u tell me any alternate solution for this ?
|
|
|
|
|
|
 Re: Microsoft ODBC for Oracle [message #129492 is a reply to message #125081] |
Mon, 25 July 2005 08:11 |
ramesh_leadersoft
Messages: 3
Registered: July 2005
|
Junior Member |
|
|
hai
simple method i will tellu,
say example if u want to export table aclled employee, then
sql>set heading off
sql> spool c:\xfile.xls
sql> select * from employee;
sql> spool off;
ur file is ready in the location described.
if u r not satisfied , try otherway round like 3rd party tool from the web.
the first one is the easier one.
bye!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
