3

I am trying to connect from BCS directly to Oracle, but there is an error:

Keyword not supported: 'connect timeout'.

I think that the connection string formed for Oracle is in an incorrect format for the method: 

protected virtual string CreateConnectionString(INamedPropertyDictionary lobSystemInstanceProperties){}

Type: Microsoft.SharePoint.BusinessData.SystemSpecific.Db.DbConnectionManager

Assembly: Microsoft.SharePoint, Version=14.0.0.0.

Has anyone encountered a similar problem? Are there any solutions?

Improve this question
4
  • how did you setup your BCS definition?
    – Jaap Vossers
    Feb 3, 2010 at 13:34
  • <Property Name="AuthenticationMode" Type="System.String">RdbCredentials</Property> <Property Name="DatabaseAccessProvider" Type="System.String">Oracle</Property> <Property Name="RdbConnection Data Source" Type="System.String">oracleds</Property> <Property Name="SsoApplicationId" Type="System.String">OracleDb</Property> and thats all about connection, I don't specify "connect timeout" manually
    – Vitaly Baum
    Feb 3, 2010 at 20:20
  • Did you successfully setup a SSO application called SsoApplicationId?
    – Jaap Vossers
    Feb 4, 2010 at 11:16
  • Yes, of course, but the problem isn't in the SSS
    – Vitaly Baum
    Feb 4, 2010 at 11:43

1 Answer 1

Reset to default
2

Unlike other .NET Framework data providers (SQL Server, OLE DB, and ODBC), System.Data.OracleClient's OracleConnection does not support Connection Timeout property. If you remove it from your connection string, it should work.

Improve this answer
1
  • Connection string generates at runtime into method above and this parameter hardcoded into. I dont specify "connect timeout" own.
    – Vitaly Baum
    Feb 3, 2010 at 20:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.