Announcement

Collapse
No announcement yet.

MSSQL Database Connection String

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • MSSQL Database Connection String

    MSSQL Database Connection String


    Usando DSN

    <%

    'Your connection here
    set conn = server.createobject("ADODB.Connection")
    conn.open "DSN=your-dsn; UID=sqldbuser; PWD=sqldbpass"
    set rs = server.createobject("ADODB.recordset")

    %>

    Standard Security

    Driver={SQL Native Client};Server=SQL-Server-Address;Database=your-sql-db;Uid=sqldbuser;Pwd=sqldbpass;



    Visual Studio ASP.Net Connection String

    <connectionStrings>
    <add name="SampleConnectionString" connectionString="Data Source=sql-server;Initial Catalog=sql-database;User ID=dbuser;Password=dbpassword" providerName="System.Data.SqlClient" />
    </connectionStrings>


    Para verificar los detalles de SQL Server, por favor entra WebsitePanel, vaya a "Hosting Space", seleccione "View Space Summary" en el menú de la derecha.
Working...
X