While this isn't a definitive guide on connection strings, we wanted to give you a few examples of connection strings that may be used. Most of our servers are running MSSQL 2012, although newer servers are probably running MSSQL 2016.
Additionally, the following resources may help you as well - https://www.connectionstrings.com/sql-server-2012/
.NET Framework Data Provider for SQL Server
Standard Security
Server=localhost;Database=myDatabase;User Id=myUsername;Password=myPassword;Connection to a SQL Server instance
Server=localhost\sqlexpress;Database=myDataBase;User Id=myUsername;Password=myPassword;
Microsoft Access ODBC Driver
Standard Security
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;
Some additional connection string examples
<add name="strConn" connectionString="Data Source=localhost;Initial Catalog=myDatabase;User ID=myDatabaseUer;Password=myPassword" />
<add name="strConn" connectionString="Data Source=localhost\sqlexpress;Initial Catalog=myDatabase;User ID=myDatabaseUer;Password=myPassword" />
DSN_1 = "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\HostingSpaces\yourUser\yourDomain.com\data\yourDatabase.mdb;"
If you have any issues getting your application connected to our database server, please don't hesitate to contact support and we'll be happy to take a look.
Looking for reliable Windows hosting with Award Winning Customer Support?
Grab your hosting today with a 20% discount. All plans come with our 60 Money Back Guarantee!
Check out our plans & promotions on our website -- https://www.peopleshost.com/
