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.
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;
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.
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
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;
Can't get past this bit as umbraco does not like my connection string.
Sorry I'm not familiar with the datastor for forms part. Mabye those video's can help.
Jeroen
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/
is working on a reply...