Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12170: TNS:Connect timeout occurred Description: An unhandled exception occurred during the ex

user4477082May 5 2015 — edited May 6 2015

HI

i deployed a simple asp.net application in a sharepoint wfe server

installed oracle 12 32 bit client

32-bit Oracle Data Access Components (ODAC)
with Oracle Developer Tools for Visual Studio

configured sql alias 32 & 54 bit in all sharepoit servers to connect to sql server

sharepoint farm working fine

asp.net application  connecting to sql server and oracle dbs to get and show the data

in iis asp.net application enabled 32 bit and run under asp.net 4.0 version

when i connect to sql server  and get data from a database it shows below error

ORA-12170: TNS:Connect timeout occurred

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: ORA-12170: TNS:Connect timeout occurred

Source Error:

Line 4142: Dim da2 As New OleDbDataAdapter(sqlStr2, conStr2)
Line 4143: Dim ds2 As New DataSet
Line 4144: da2.Fill(ds2)
Line 4145:
Line 4146: DropDownList38.DataSource = ds2

Source File: C:\inetpub\wwwroot\wss\VirtualDirectories\lxxxx\xxx.ascx.vb Line: 4144

Stack Trace:
This post has been answered by unknown-951199 on May 5 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 3 2015
Added on May 5 2015
#general-database-discussions
10 comments
3,093 views