OraFAQ Forum: Programming Interfaces » .net connection to oracle

Home » Open Source » Programming Interfaces » .net connection to oracle (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

.net connection to oracle [message #570920]

Sun, 18 November 2012 10:52

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.

Report message to a moderator

Re: .net connection to oracle [message #570922 is a reply to message #570920]

Sun, 18 November 2012 13:44

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You have to create a DSN, by yourself.

Regards
Michel

Report message to a moderator

Re: .net connection to oracle [message #570925 is a reply to message #570922]

Sun, 18 November 2012 21:42

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.

Report message to a moderator

Re: .net connection to oracle [message #570934 is a reply to message #570925]

Mon, 19 November 2012 01:25

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: .net connection to oracle [message #570935 is a reply to message #570934]

Mon, 19 November 2012 01:59

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.

Report message to a moderator

Re: .net connection to oracle [message #570937 is a reply to message #570935]

Mon, 19 November 2012 02:47

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: .net connection to oracle [message #570942 is a reply to message #570937]

Mon, 19 November 2012 03:10

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.

Report message to a moderator

Re: .net connection to oracle [message #570944 is a reply to message #570942]

Mon, 19 November 2012 03:33

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

"Any website", when Oracle is concerned, is OTN Download page.

Report message to a moderator

Re: .net connection to oracle [message #570950 is a reply to message #570944]

Mon, 19 November 2012 04:30

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.

Report message to a moderator

Re: .net connection to oracle [message #570952 is a reply to message #570950]

Mon, 19 November 2012 04:57

Littlefoot
Messages: 21823
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

Report message to a moderator

Re: .net connection to oracle [message #570953 is a reply to message #570950]

Mon, 19 November 2012 05:04

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: .net connection to oracle [message #570958 is a reply to message #570952]

Mon, 19 November 2012 05:20

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.

Report message to a moderator

Re: .net connection to oracle [message #571040 is a reply to message #570953]

Tue, 20 November 2012 06:06

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.

Report message to a moderator

Re: .net connection to oracle [message #571042 is a reply to message #571040]

Tue, 20 November 2012 06:45

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Insufficient data to compute.

Regards
Michel

Report message to a moderator

Re: .net connection to oracle [message #571044 is a reply to message #571042]

Tue, 20 November 2012 07:00

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.

Report message to a moderator

Re: .net connection to oracle [message #571045 is a reply to message #571044]

Tue, 20 November 2012 07:07

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

How could we know? Is this a timeout problem?

Regards
Michel

Report message to a moderator

Re: .net connection to oracle [message #571063 is a reply to message #571045]

Tue, 20 November 2012 22:09

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

Thanks michel , i will change the operating system to 32 bit.

Report message to a moderator

Re: .net connection to oracle [message #571071 is a reply to message #571045]

Wed, 21 November 2012 00:10

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)

Report message to a moderator

Re: .net connection to oracle [message #571098 is a reply to message #571071]

Wed, 21 November 2012 01:35

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

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

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

Thanks michel.

Report message to a moderator

Previous Topic:	Causes and prevention of computer data loss?
Next Topic:	Build DB structure based on SQL Statements

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 19 23:42:09 CST 2025