Home » Open Source » Programming Interfaces » .net connection to oracle (oracle 10g)
.net connection to oracle [message #570920] Sun, 18 November 2012 10:52 Go to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

i am unable to connect one vb.net connection to oracle database 10g using odbc as its not working with 64bit as i dont see any odbc datasource when i am trying to connect , can someone help me where i can get this client connectivity tool.
Re: .net connection to oracle [message #570922 is a reply to message #570920] Sun, 18 November 2012 13:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to create a DSN, by yourself.

Regards
Michel
Re: .net connection to oracle [message #570925 is a reply to message #570922] Sun, 18 November 2012 21:42 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

thanks michel , but the problem is i am trying to choose a driver , there is no oracle option comming, what could be the problem do i need to create a new registry key, by any other means.
Re: .net connection to oracle [message #570934 is a reply to message #570925] Mon, 19 November 2012 01:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
there is no oracle option comming


Because you didn't install it.
So, reexecute OUI and choose the option to install ODBC.

Regards
Michel
Re: .net connection to oracle [message #570935 is a reply to message #570934] Mon, 19 November 2012 01:59 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

where to install this OUI from, where i can download it from.
Re: .net connection to oracle [message #570937 is a reply to message #570935] Mon, 19 November 2012 02:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You should have OUI in your Windows menu -> Oracle/your Oracle home/Oracle Installation Products/Universal Installer.
You also have it in any Oracle distribution, for instance the client one you need to install Oracle ODBC driver.

Regards
Michel
Re: .net connection to oracle [message #570942 is a reply to message #570937] Mon, 19 November 2012 03:10 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

Thanks michel , i do have the client for that , i will install it and see,can we download that client from any website.
Re: .net connection to oracle [message #570944 is a reply to message #570942] Mon, 19 November 2012 03:33 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
"Any website", when Oracle is concerned, is OTN Download page.
Re: .net connection to oracle [message #570950 is a reply to message #570944] Mon, 19 November 2012 04:30 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

littlefoot i was able to download only 32 bit version of client , where i can get 64 bit client for oracle 10g.
Re: .net connection to oracle [message #570952 is a reply to message #570950] Mon, 19 November 2012 04:57 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Here.
Oracle

Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64) win64_11gR2_client.zip (615,698,264 bytes) (cksum - 2947608743)

Contains the Oracle Client Libraries. Download if you want the client libraries only
Re: .net connection to oracle [message #570953 is a reply to message #570950] Mon, 19 November 2012 05:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I'm afraid that 10g products are no more available online, you have to open a SR to Oracle to get it.
What prevent you from using the 11g client?

Regards
Michel
Re: .net connection to oracle [message #570958 is a reply to message #570952] Mon, 19 November 2012 05:20 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

Thanks michel and littlefoot, i am downloading the 11g client and will try to use that.Thanks for the great help.
Re: .net connection to oracle [message #571040 is a reply to message #570953] Tue, 20 November 2012 06:06 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

Dear Michel , i downloaded the 11g client and installed it on one of client pc, the odbc configueration was ok but i was not able to link the table ,i am getting an ODBC Call failed error.
Re: .net connection to oracle [message #571042 is a reply to message #571040] Tue, 20 November 2012 06:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Insufficient data to compute.

Regards
Michel
Re: .net connection to oracle [message #571044 is a reply to message #571042] Tue, 20 November 2012 07:00 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

do i neet to change anything such as timeout or suggest me what i can do.
Re: .net connection to oracle [message #571045 is a reply to message #571044] Tue, 20 November 2012 07:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How could we know? Is this a timeout problem?

Regards
Michel
Re: .net connection to oracle [message #571063 is a reply to message #571045] Tue, 20 November 2012 22:09 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

Thanks michel , i will change the operating system to 32 bit.
Re: .net connection to oracle [message #571071 is a reply to message #571045] Wed, 21 November 2012 00:10 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

Hi michel , the exact message that i am getting while linking the table is as below

Quote:
ODBC--call failed

[Microsoft][ODBC Driver Manager]The specified DSN contains an architecture mismatch between the Driver and Application(#0)
Re: .net connection to oracle [message #571098 is a reply to message #571071] Wed, 21 November 2012 01:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So you now use a Windows driver and not an Oracle one; why do you hide this information?

A simple search on Google copying and pasting your error message:
http://www.google.com/#hl=fr&output=search&sclient=psy-ab&q=%22The+specified+DSN+contains+an+architecture+mismatch+betwee n+the+Driver+and+Application%22
gives me at first link:

Quote:
The specified DSN contains an architecture mismatch between the Driver and Application
To resolve this error, use the 32-bit odbcad32.exe to configure or remove the DSN.


Regards
Michel

[Updated on: Wed, 21 November 2012 01:36]

Report message to a moderator

Re: .net connection to oracle [message #571104 is a reply to message #571098] Wed, 21 November 2012 01:56 Go to previous message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

Thanks michel.
Previous Topic: Causes and prevention of computer data loss?
Next Topic: Build DB structure based on SQL Statements
Goto Forum:
  


Current Time: Thu Mar 28 11:43:53 CDT 2024