aman0711
asked on
How to create Oracle ODBC connection in Windows
Hi experts,
I am working with Oracle 10g and XMLspy and for that I need to make an ODBC connection with my Oracle 10g database.
Can someone please guide me with a step by step instructions.
Thanks
I am working with Oracle 10g and XMLspy and for that I need to make an ODBC connection with my Oracle 10g database.
Can someone please guide me with a step by step instructions.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I meant, I have to install Oracle client lol
Yes, though you can get the instant client that is much smaller.
There are full Oracle ODBC drivers available that don't require the client, but I don't know that any are free.
There are full Oracle ODBC drivers available that don't require the client, but I don't know that any are free.
ASKER
hi mrjoltcola,
Lets start step by step :-) So I finished first two steps.
Installed Oracle Client, and ran tns ping.. it gave me all the connection details with OK status code.
Lets start step by step :-) So I finished first two steps.
Installed Oracle Client, and ran tns ping.. it gave me all the connection details with OK status code.
So you are good, now proceed to step 3 to get ODBC setup
ASKER
Done :-)
Thanks mrjoltcola :-)
I have another question, though I can post it in another thread, just want some light from you.
What is the easiest way to build tables for data coming in XML file
Thanks mrjoltcola :-)
I have another question, though I can post it in another thread, just want some light from you.
What is the easiest way to build tables for data coming in XML file
ASKER
Thanks :)
There are many ways, including external loading tools as well as Oracle's very good XML support inside the database. I recommend asking another question in both Oracle + XML zones, and you'll get better response. I will also keep an eye out for your questions and contribute.
ASKER