sql server connect: I have a Linked server from Sql05 64 bit to Oracle.
I am using the Oracle OleDb driver because their is no MS to Oracle Provider
for 64 bit SQL databases.

If I am in management studio I can query the Oracle database.
However, if I am in a .net 2.0 web application the Oracle connection will
periodically time out.

I can have Mgmt Studio up at the same time as the Web App and the Web App
will be timing out and the Mgmt Studio connection will be connecting.

The link only allows the use of a specified username/pswd.
Their are no connection limits on the Oracle account.

Hi Chuck,
I understand that you found that your .NET 2.0 Web Application which used
Oracle OLEDB Provider (x64) will periodically disconnect from the Oracle
database server. However this issue does not occur if you connect your
Oracle database in SSMS.
If I have misunderstood,please let me know.

After I looked at Oracle website, I think that your current Oracle provider
is the provider from this URL:
http://www.oracle.com/technology/tech/windows/ole_db/index.html

This issue seems related to .NET data provider. I would like to know if you
install their current 64-bit ODP.NET beta version from this URL:
http://www.oracle.com/technology/tech/windows/odpnet/index.html
If not, please install it and see if it still happens.

Since OracleConnection does not support a ConnectionTimeout property in
NET 2.0, there is no way to control the timeout value in your .NET code.
If this issue persists, immediately and effectively I recommend that you
contact Oracle for the best support. Sorry for bringing you any
inconvenience and appreicate your understanding on this.

If you have any other questions or concerns, please feel free to let me
know. Have a good day!

Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications

If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.


Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

We are not using the ODP.
In SQL server we have a sproc that
has
select * from OracleLink..tableName

In .Net we use the sql provider to access the sproc on sql05.
Provider is OraOLEDB.Oracle

I am not sure if the Oracle Data Provider for .NET would work within SQL
Server since it's not a .Net Environment?

On SQL Server I did:

Install the 64 bit Oracle Client
Install Oracle10g Release 2 ODAC 64 Bit
Don't install the net tools, don't install the 32 bit client
Restart SQL Server (get provider to show up)
Right click on Linked Server Provider OraOLEDB.Oracle
select allow in process.

EXEC sp_addlinkedserver 'tnsName', 'Oracle', 'OraOLEDB.Oracle', 'tnsName'
EXEC sp_addlinkedsrvlogin 'tnsName', false,null, 'username', 'password'

Hi Chuck,
I am sorry for misunderstanding your issue.
So actually your web application should use SqlConnection to connect to
your SQL Server 2005 database and you use SqlCommand to execute the query
"select * from OracleLink..tableName", right?

If so, ODP.NET is indeed irrelevant to this issue. The default value of the
property ConnectionTimeout of SqlConnection is 15 seconds. Could you please
check if your timeout period was about 15 seconds? If so, I recommend that
you try setting the ConnectionTimeout to 0 (no limit) or a larger value
than 15 seconds to see if this issue persists.

You can set the connection timeout property in your SQL connection string,
such as:
"Data Source=(local);Initial Catalog=AdventureWorks;Integrated
Security=SSPI;Connection Timeout=0"

If this method does not work, I am afraid that it is indeed a provider
issue. Due to our newsgroup resource limitation, to track the root cause of
such issue, it is recommended that you contact Microsoft Customer Support
Services (CSS) via telephone or Oracle company for the best support.

To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.

If you have any other questions or concerns, please feel free to let me
know. It is my pleasure to be of assistance.

Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications

If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.


Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

Given that Oracle's drivers, historically have been unusable and MS isn't
really ready for 64 bit computing, what do most people do to connect to
Oracle when using 64bit SQL server. Are their good 3rd party drivers. I've
been talking with Oracle tech support for 4 days, no resolution yet.

Hi Chuck,
Thanks for your response.

Appreciate your understanding that this is a provider issue which may need
Microsoft and Oracle's cooperation to track the root cause. I think that
Microsoft is ready for 64 bit computing since Microsoft SQL Server 64 bit
has been applied in many enterprise production environment.

As I mentioned before, you may also contact Microsoft CSS via telephone for
the best support.

Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications

If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.


Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================