Connection Strings for SQL Server 2000 and 7.0

بِسْــــــــــــــــمِ اﷲِالرَّحْمَنِ اارَّحِيم

bismillaahirrahmaanirrahiim

السَّلاَمُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ

Assalamu'alaikum warahmatullahi wabarakatuh

.NET Framework Data Provider for SQL Server

Standard Security
Data Source=ServerName;Initial Catalog=DatabaseName;User Id=UserName;Password=Password;

Standard Security alternative syntax
Server=ServerName;Database=DatabaseName;User ID=UserName;Password=Password;Trusted_Connection=False;

Trusted Connection

Data Source=ServerName;Initial Catalog=DatabaseName;Integrated Security=SSPI;

Connecting to an SQL Server instance

Server=ServerName\theInstanceName;Database=DatabaseName;Trusted_Connection=True;

Trusted Connection from a CE device

Data Source=ServerName;Initial Catalog=DatabaseName;Integrated Security=SSPI;User ID=myDomain\UserName;Password=Password;

Note: This will work on a CE device only. 

Connect via an IP address

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=DatabaseName;User ID=UserName;Password=Password;

DBMSSOCN=TCP/IP.

Note: 1433 is the default port for SQL Server.

Microsoft OLE DB Provider for SQL Server

Standard Security

Provider=sqloledb;Data Source=ServerName;Initial Catalog=DatabaseName;User Id=UserName;Password=Password;

Trusted connection

Provider=sqloledb;Data Source=ServerName;Initial Catalog=DatabaseName;Integrated Security=SSPI;

Connecting to an SQL Server instance

Provider=sqloledb;Data Source=ServerName\theInstanceName;Initial Catalog=DatabaseName;Integrated Security=SSPI;

Connect via an IP address

Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=DatabaseName;User ID=UserName;Password=Password;

DBMSSOCN=TCP/IP.

This use to connect the SQL Server Database via internet connection.

Update Contact :
No Wa/Telepon (puat) : 085267792168
No Wa/Telepon (fajar) : 085369237896
Email : Fajarudinsidik@gmail.com NB :: Bila Sobat tertarik Ingin membuat software, membeli software, membeli source code, membeli hardware elektronika untuk kepentingan Perusahaan maupun Tugas Akhir (TA/SKRIPSI), Insyaallah Saya siap membantu, untuk Respon Cepat dapat menghubungi kami, melalui :

No Wa/Telepon (puat) : 085267792168
No Wa/Telepon (fajar) : 085369237896
Email: Fajarudinsidik@gmail.com

atau Kirimkan Private messanger melalui email dengan klik tombol order dibawah ini :

ٱلْحَمْدُ لِلَّهِ رَبِّ ٱلْعَٰلَمِين

Alhamdulilah hirobil alamin

وَ السَّلاَمُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ

wassalamualaikum warahmatullahi wabarakatuh

Artikel Connection Strings for SQL Server 2000 and 7.0, Diterbitkan oleh scodeaplikasi pada Rabu, 29 Juni 2011. Semoga artikel ini dapat menambah wawasan Anda. Website ini dipost dari beberapa sumber, bisa cek disini sumber, Sobat diperbolehkan mengcopy paste / menyebar luaskan artikel ini, karena segala yang dipost di public adalah milik public. Bila Sobat tertarik Ingin membuat software, membeli software, membeli source code ,Dengan Cara menghubungi saya Ke Email: Fajarudinsidik@gmail.com, atau No Hp/WA : (fajar) : 085369237896, (puat) : 085267792168.