Common Database Connection Strings

Common Database Connection Strings

The Field2Base Data Integration Module and Enterprise Dispatch Module use the standard Connection Strings any other Application would require to connect to your Database.

Common Database Connection Strings (all using Standard Security):
  1. SQL Server 2000, 7.0 OLE DB
    1. Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
  2. SQL Server Compact Edition OLE DB
    1. Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=myPath\myData.sdf;
  3. Access
    1. Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;
  4. Access 2007
    1. Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;
Note: You would need to replace any of the “my” variables listed above with your information.

If you are working with a Database not listed here, please look up your string at https://www.connectionstrings.com/

If you need further explanation on what a Connection String is, ConnectionStrings.com has the following article as well as other resources: https://www.connectionstrings.com/connection-strings-explained/