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.

  • Jeroen Breuer 4908 posts 12265 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

  • 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.

  • Jeroen Breuer 4908 posts 12265 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

  • 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/

Please Sign in or register to post replies

Write your reply to:

Draft