Copied to clipboard

Flag this post as spam?

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


  • neelesh 9 posts 99 karma points
    Jan 24, 2018 @ 10:34
    neelesh
    0

    Having problem in Umbraco forms connectivity with database

    enter image description here

    What should I write in Connection string? I am using Microsoft SQL Server 2012

  • Mark 91 posts -18 karma points
    Jan 24, 2018 @ 10:47
    Mark
    0

    Your connection string should look something like this:

    server=SQLServerName;database=MyDatabaseName;Integrated Security=True

    You may need to add your username and password for the database if it isn't a local database

    server=SQLServerName;database=MyDatabaseName;user id=MyUserName;password=MyPassword

  • neelesh 9 posts 99 karma points
    Jan 24, 2018 @ 13:50
    neelesh
    0

    enter image description here

    This is the error occurring from your solution

  • Nik 1625 posts 7295 karma points MVP 7x c-trib
    Jan 24, 2018 @ 13:55
    Nik
    100

    Hi Neelesh,

    This website is great for helping construct connection string:

    https://www.connectionstrings.com/sql-server-2012/

    Looking at your screen shot if you scroll down that page to the SQL Server Native Client 11.0 OLE DB Provider it gives you a variety of examples that should help you construct your connection string :-)

    The site is great for various different types of connection and database types.

    Thanks,

    Nik

  • neelesh 9 posts 99 karma points
    Jan 24, 2018 @ 14:00
    neelesh
    1

    Hi Nik,

    Great Solution and it works.

    Thanks

  • neelesh 9 posts 99 karma points
    Jan 24, 2018 @ 14:10
  • 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