MySQL-ASP.NET Connection Print

  • 5

MySQL and MSSQL servers are installed on your Web server.

Just take 'localhost' for MySQL and '.\SQLExpress' for MSSQL.
Your Web server address is also the address for your database servers (MySQL/MSSQL)

--------------------------------
Connection String for MSSQL Server
--------------------------------
         connectionString="Data Source=.\SQLExpress;
                                       Initial Catalog=DatabaseNameHere;
                                       User ID=DatabaseUserNameHere;
                                       Password=PasswordHere"
         providerName="System.Data.SqlClient" />




--------------------------------
Connection String for MySQL Server
--------------------------------
         connectionString="Data Source=localhost;
                                       Database=DatabaseNameHere;
                                       User ID=DatabaseUserNameHere;
                                       Password=PasswordHere"
         providerName="MySql.Data.MySqlClient" />


Was this answer helpful?

« Back