BCS and Oracle: bug in connection string?

Vitaly Baum
  • BCS and Oracle: bug in connection string? Vitaly Baum

    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?

Tags
Related questions and answers
  • establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. Event 18452 Login... attempting to start and run the UPS Sync) and eventually fails: Error ID: 22 - The Forefront Identity Manager Service cannot connect to the SQL Database Server. The SQL Server could not be contacted. The connection failure may be due to a network failure, firewall configuration error, or other connection issue. Additionally, the SQL Server connection information could be configured

  • I'm writing some code against the search API in SharePoint 2007, and am seeing some interesting behaviour. I'm using the KeywordQuery 'model' rather than FullTextSqlQuery, since this matches the advanced search form our client wants. I'm using the following code to execute the search - this builds a keyword search query in the same format as the OOTB web parts: ResultTableCollection resultTables = null; using (KeywordQuery keywordQuery = new KeywordQuery(SPContext.Current.Site)) { string fullQuery = string.Empty; // TODO: refactor

  • of permissions --- {1}. Available parameters: System.ServiceModel.EndpointNotFoundException: Could not connect to http://poc-bi-sp:5725/ResourceManagementService/MEX. TCP error code 10061: No connection could...I have a new SharePoint 2010 server farm that I'm trying to configure. Installation went fine. But I'm having trouble getting the user profiles to import. I've created the User Profile service application, and the two user profile services are running. However, whenever I try to create a synchronization connection to our AD servers, I'm getting the following error: "The operation was aborted

  • I can create a CQWP for the Announcement content type, but when I export the .webpart and add <property name="CommonViewFields" type="string">Expires,Date;Body,text</property> In my ItemStyles.xsl I have added this to show all the returned fields <xsl:template name="ShowXML" match="Row[@Style='ShowXML']" mode="itemstyle"> <xsl:for-each select="@*"> <br...; But Body always comes back blank. I have two site collections; one to test and one for production. The Test collection works and returns the body of the announcement, but the Production does

  • I would like to modify the default text in Subject and Personal message, on the page: http://(sharepoint)/_layouts/aclinv.aspx Where do I change the text? Thanks :-)

  • . Parameter name: path at System.IO.DirectoryInfo..ctor(String path) at Microsoft.SharePoint.StsAdmin.SPStsAdmin.EnsureExtendedOperationMap() at Microsoft.SharePoint.StsAdmin.SPStsAdmin.EnsureFullOperationMap() at Microsoft.SharePoint.StsAdmin.SPStsAdmin.LookupOperationName(String strOperation) at Microsoft.SharePoint.StsAdmin.SPStsAdmin.Main(String[] args) I'm baffled as to why. The only significant thing to change on the server between yesterday and today was the installation of the Citrix Web Interface for SharePoint webparts. UPDATE: I also receive the following error

  • ; The connection string we are using is "Data Source=xxxx; Initial catalog=yyy; Integrated security=true;" We have tried with a small change in conneciontion string as well "Data Source=xxxx; Initial catalog

  • ; <asp:Parameter Name="Domain" Type="String" /> <asp:Parameter Name="code" Type="String" /> <asp:Parameter Name="meaning" Type="String" /> <asp:Parameter Name... to a dataset that was created (.xsd file). We have a web.config connection string that looks like: <add name="crmConnectionString" connectionString="Data Source=myservername;Initial Catalog=CRM;User Id=xyz123;Password=***************;Integrated Security=False;Connect Timeout=30;" providerName="System.Data.SqlClient" /> As I mentioned, this application works fine in VS2005, VS2008, and also

  • ), however when I try to add a web part connection in SharePoint designer I get an error dialog saying: The Search Paging Web Part does not support connections. So how can I connect these up? I cannot...This is my first time working with the search components of SharePoint in much detail so any advice would be helpful here. I have a custom search results page created to match our corporate intranet (not sharepoint.) The search query is passed in using the the query string parameter so this page is essentially an exact replica of the intranet in static html but with the required elements

Data information