ORM defaults to SQL Server and ignores Oracle ConnectionString

3 posts, 0 answers
  1. DMC Helpdesk
    DMC Helpdesk avatar
    52 posts
    Member since:
    Nov 2007

    Posted 16 Jun 2010 Link to this post

    Hi,

    I applied the latest internal build (2010.1.610.1) to fix the problem described in this post.The internal build fixed it but now I have another problem.

    I am using oracle as a database, and my model is rendered on the designer, but when I try to update it using the command 'Update From Database' I get the error: a network-related or istance-specific error occurred while establishing a connection to SQL Server.The server was not found or was not accessible.

    My connection string is:

    <add name="HelpDeskConnectionString" connectionString="data source=MyDB;persist security info=True;user id=myusr;password=mypass;unicode=True"  providerName="System.Data.OracleClient" /> 

    It seems the designer is now ignoring the providerName which is oracle and not SQL Server.I am now stuck again !

    Any help will be appreciated.

  2. DMC Helpdesk
    DMC Helpdesk avatar
    52 posts
    Member since:
    Nov 2007

    Posted 16 Jun 2010 Link to this post

    I had to create another domain from oracle and then compare the rlinq files.This setting was missing:

     <BackendConfigurationSettings> 
            <BackendConfiguration> 
              <Backend>oracle</Backend> 
              <Logging> 
                <LogToConsole>False</LogToConsole> 
              </Logging> 
            </BackendConfiguration> 
          </BackendConfigurationSettings> 

    It means applying the internal build had restored the backend to default to sql server when the designer loaded for the first time.
  3. DevCraft banner
  4. Zoran
    Admin
    Zoran avatar
    534 posts

    Posted 18 Jun 2010 Link to this post

    Hi DMC Helpdesk,

     This is a side-effect to the newly introduced BackendConfiguration settings where we keep different information regarding the driver, backend as well as some connection pool or caching configuration. This information was not stored in earlier version of the designer, so I apologize for the inconvenience this might have caused you. However, we are glad that you solved it in the end. 

    Kind regards,
    Zoran
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Back to Top