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 1612 posts 7258 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
Please Sign in or register to post replies

Write your reply to:

Draft