Contoh-Contoh Connection String Database Access Di Visual Basic

Contoh-Contoh Connection String Database Access Di Visual Basic | Gho Blog's - Microsoft Office Access adalah sebuah program aplikasi basis data komputer relasional yang ditujukan untuk kalangan rumahan dan perusahaan kecil hingga menengah.

Salah satu keunggulan Microsoft Access dilihat dari perspektif programmer adalah kompatibilitasnya dengan bahasa pemrograman Structured Query Language (SQL); query dapat dilihat dan disunting sebagai statemen-statemen SQL, dan statemen SQL dapat digunakan secara langsung di dalam Macro dan VBA Module untuk secara langsung memanipulasi tabel data dalam Access. Para pengguna dapat mencampurkan dan menggunakan kedua jenis bahasa tersebut (VBA dan Macro) untuk memprogram form dan logika dan juga untuk mengaplikasikan konsep berorientasi objek.

Berikut ini contoh-contoh Connection String yang bisa digunakan untuk mengkoneksikan database Access dengan bahasa pemrogran Visual Basic :

Microsoft ACE OLEDB 12.0

---

Standard Security : (2007, 2010, 2013)

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb; Persist Security Info=False;

Database Berpassword : (2007, 2010, 2013)

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb; Jet OLEDB:Database Password=MyDbPassword;

Data Directory Functionality : (2007, 2010, 2013)

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\myAccessFile.accdb; Persist Security Info=False;

Network Location : (2007, 2010, 2013)

Provider=Microsoft.ACE.OLEDB.12.0; Data Source=\\server\share\folder\myAccessFile.accdb;

Standard Security (mdb file) : (1997, 2000, 2002, 2003)

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.mdb; Persist Security Info=False;

Database Berpassword (mdb file) : (1997, 2000, 2002, 2003)

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.mdb; Jet OLEDB:Database Password=MyDbPassword;

Data Directory Functionality (mdb file) : (1997, 2000, 2002, 2003)

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\myAccessFile.mdb; Persist Security Info=False;

Network Location (mdb file) : (1997, 2000, 2002, 2003)

Provider=Microsoft.ACE.OLEDB.12.0; Data Source=\\serverName\shareName\folder\myAccessFile.mdb;

Microsoft Jet OLE DB 4.0

---

Standard Security (mdb file) : (1997, 2000, 2002, 2003)

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin; Password=;

Database Berpassword (mdb file) : (1997, 2000, 2002, 2003)

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb; Jet OLEDB:Database Password=MyDbPassword;

Workgroup (system database) : (1997, 2000, 2002, 2003)

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb; Jet OLEDB:System Database=system.mdw;

Workgroup (system database) specifying username and password : (1997, 2000, 2002, 2003)

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb; Jet OLEDB:System Database=system.mdw;User ID=myUsername;Password=myPassword;

Data Directory Functionality : (1997, 2000, 2002, 2003)

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\myDatabase.mdb; User Id=admin;Password=;

Network Location : (1997, 2000, 2002, 2003)

Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\serverName\shareName\folder\myDatabase.mdb;User Id=admin; Password=;

Menggunakan RDS (MS Remote) : (1997, 2000, 2002, 2003)

Provider=MS Remote;Remote Provider=Microsoft.Jet.OLEDB.4.0; Remote Server=http://server.adress.com;Data Source=d:\myPath\myDatabase.mdf;

Exclusive : (1997, 2000, 2002, 2003)

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb; Mode=Share Exclusive;User Id=admin;Password=;

.NET Framework Data Provider for OLE DB

---

Use an OLE DB provider from .NET

Provider=any oledb provider's name;OledbKey1=someValue;OledbKey2=someValue;

Microsoft Access accdb ODBC Driver

---

Standard Security : (2007, 2010, 2013)

Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\mydatabase.accdb; Uid=Admin;Pwd=;

Workgroup : (2007, 2010, 2013)

Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\mydatabase.accdb; SystemDB=C:\mydatabase.mdw;

Exclusive : (2007, 2010, 2013)

Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\mydatabase.accdb; Exclusive=1;Uid=admin;Pwd=;

Enable admin statements : (2007, 2010, 2013)

Untuk mengaktifkan fungsi tertentu pemrograman admin seperti CREATE USER, CREATE GROUP, ADD USER, GRANT, REVOKE and DEFAULTS (ketika membuat pernyataan CREATE TABLE) menggunakan connection string ini.

Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\mydatabase.accdb; Uid=Admin;Pwd=;ExtendedAnsiSQL=1;

Specifying locale identifier : (2007, 2010, 2013)

Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\mydatabase.accdb; Locale Identifier=2057;Uid=Admin;Pwd=;

Standard connection : (1997, 2000, 2002, 2003)

Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\mydatabase.mdb;

Microsoft Access ODBC Driver

---

Standard Security : (1997, 2000, 2002, 2003)

Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;

Workgroup : (1997, 2000, 2002, 2003)

Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb; SystemDB=C:\mydatabase.mdw;

Exclusive : (1997, 2000, 2002, 2003)

Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1; Uid=admin;Pwd=;

Enable admin statements : (1997, 2000, 2002, 2003)

Untuk mengaktifkan fungsi tertentu pemrograman admin seperti CREATE USER, CREATE GROUP, ADD USER, GRANT, REVOKE and DEFAULTS (ketika membuat pernyataan CREATE TABLE) menggunakan connection string ini.

Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=; ExtendedAnsiSQL=1;

Specifying locale identifier : (1997, 2000, 2002, 2003)

Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb; Locale Identifier=2057;Uid=Admin;Pwd=;

.NET Framework Data Provider for ODBC

---

Use an ODBC driver from .NET

Driver={any odbc driver's name};OdbcKey1=someValue;OdbcKey2=someValue;

Sekian dulu posting kami yang berjudul Contoh-Contoh Connection String Database Access Di Visual Basic. Semoga bermanfaat buat sobat semua. [Sumber]