Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Ayo Adesina 445 posts 1059 karma points
    Feb 09, 2015 @ 11:39
    Ayo Adesina
    0

    Using Umbraco forms 7.2

    Hi guys, I'm just trying to set up a simple form using the in 7.2 Umbraco Forms feature (not CONTOUR)

    I want the form entries to end up in a MS SQL db, When I try and a new data-source using this connection string

    Provider=System.Data.SqlClient;Server=111.111.111.111;Database=testdb;Uid=usernamehere; Pwd=passwordhere;

    When I click save I get the following error message:

    Datasource failed to save: The 'System.Data.SqlClient' provider is not registered on the local machine.

    Currently I don't have a licence, but just want to test it out locally on my computer, is this the reason I am getting the error message as the db is not on my local machine.

    Can someone please help me out with a working example connection string.

    Copy Link
  • Jeroen Breuer 4909 posts 12266 karma points MVP 5x admin c-trib
    Feb 09, 2015 @ 12:12
    Jeroen Breuer
    0

    Hello,

    Do you only get this error when you try to use Umbraco Forms? There are some training video's which might help: http://umbraco.tv/videos/umbraco-v7/implementor/extending/umbraco-forms/

    Jeroen

    Copy Link
  • Ayo Adesina 445 posts 1059 karma points
    Feb 09, 2015 @ 12:16
    Ayo Adesina
    0

    Hi Jeroen,

    Well I am only trying out the features as we might use it for a few up-coming projects.

    My current set up is;

    1. Install Umbraco from Nuget
    2. Select Starter Kit
    3. Install forms from back office
    4. Try and set up a datastore for forms

    Can't get past this bit as umbraco does not like my connection string.

    Copy Link
  • Jeroen Breuer 4909 posts 12266 karma points MVP 5x admin c-trib
    Feb 09, 2015 @ 12:20
    Jeroen Breuer
    0

    Sorry I'm not familiar with the datastor for forms part. Mabye those video's can help.

    Jeroen

    Copy Link
  • ibrahim TUNC 55 posts 133 karma points
    Apr 13, 2015 @ 00:22
    ibrahim TUNC
    1

    Try it if it meets which of the following...

    before MS SQL Server 2012 (2008, 2005, 2000, SQL Serve 7.0)
    Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

    For MS SQL Server 2012 - 2014
    Provider=SQLNCLI11;Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;


    http://www.connectionstrings.com/sql-server-native-client-10-0-oledb-provider/

    http://www.connectionstrings.com/sql-server-native-client-11-0-oledb-provider/

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies