Assalamu'alaikum Wr. Wb.
Dengan Rahmad Allah Yang maha kuasa lagi maha penyayang kami telah mempublikasikan web blog yang sangat sederhana ini semoga semua ini dapat bermanfaat sebagai alat komunitas kita dalam mengembangkan seatu kreasi diri kita terhadap perkembangan jaman dimasa kini.dan dengan ini kami ingin sekali mendapatkan saran dan kritik dari teman - teman semua agar kita dapat mengevalusi diri, sehingga kita dapat lebih memberikan manfaat yang sebaik - baiknya. i love my self. ^_^
Live Music
Visual Basic 6.0
Semua Tentang VB - Connection String
1. SQL Server
ODBC Standard Security: “Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;” Trusted connection: “Driver={SQL Server};Server=Aron1;Database=pubs; Trusted_Connection=yes;” Prompt for username and password: oConn.Properties(”Prompt”) = adPromptAlwaysoConn.Open “Driver={SQL Server};Server=Aron1;DataBase=pubs;”
OLE DB, OleDbConnection (.NET) Standard Security: “Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;” Trusted Connection: “Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;” (use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000) Prompt for username and password: oConn.Provider = “sqloledb”oConn.Properties(”Prompt”) = adPromptAlwaysoConn.Open “Data Source=Aron1;Initial Catalog=pubs;” Connect via an IP address: “Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;” (DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))
SqlConnection (.NET) Standard Security: “Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;” - or - “Server=Aron1;Database=pubs;User ID=sa;Password=asdasd;Trusted_Connection=False” (both connection strings produces the same result) Trusted Connection: “Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;” - or -”Server=Aron1;Database=pubs;Trusted_Connection=True;” (both connection strings produces the same result) (use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000) Connect via an IP address: “Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;” (DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default)) Declare the SqlConnection: C#:using System.Data.SqlClient;SqlConnection oSQLConn = new SqlConnection();oSQLConn.ConnectionString=”my connection string”;oSQLConn.Open(); VB.NET: Imports System.Data.SqlClientDim oSQLConn As SqlConnection = New SqlConnection()oSQLConn.ConnectionString=”my connection string”oSQLConn.Open()
Data Shape MS Data Shape”Provider=MSDataShape;Data Provider=SQLOLEDB;Data Source=Aron1;Initial Catalog=pubs;User ID=sa;Password=asdasd;”
2. SQL Server 2005
3. Access
4. Oracle
5. MySQL
6.Interbase
7.IBM DB2
8.Sybase
9.Informix
10. Ingres
11. Mimer SQL
12. Lightbase
13.PostgreSQL
14. Paradox
15. DSN
16. Firebird
17. Excel
18. Text
19. DBF / FoxPro
20. AS/400 (iSeries)
21. Exchange
22. Visual FoxPro
23 Pervasive
24. UDL
Kurang jelas kasih comment pasti dibantu dechhh ... ^_^
1. SQL Server
ODBC Standard Security: “Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;” Trusted connection: “Driver={SQL Server};Server=Aron1;Database=pubs; Trusted_Connection=yes;” Prompt for username and password: oConn.Properties(”Prompt”) = adPromptAlwaysoConn.Open “Driver={SQL Server};Server=Aron1;DataBase=pubs;”
OLE DB, OleDbConnection (.NET) Standard Security: “Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;” Trusted Connection: “Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;” (use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000) Prompt for username and password: oConn.Provider = “sqloledb”oConn.Properties(”Prompt”) = adPromptAlwaysoConn.Open “Data Source=Aron1;Initial Catalog=pubs;” Connect via an IP address: “Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;” (DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))
SqlConnection (.NET) Standard Security: “Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;” - or - “Server=Aron1;Database=pubs;User ID=sa;Password=asdasd;Trusted_Connection=False” (both connection strings produces the same result) Trusted Connection: “Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;” - or -”Server=Aron1;Database=pubs;Trusted_Connection=True;” (both connection strings produces the same result) (use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000) Connect via an IP address: “Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;” (DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default)) Declare the SqlConnection: C#:using System.Data.SqlClient;SqlConnection oSQLConn = new SqlConnection();oSQLConn.ConnectionString=”my connection string”;oSQLConn.Open(); VB.NET: Imports System.Data.SqlClientDim oSQLConn As SqlConnection = New SqlConnection()oSQLConn.ConnectionString=”my connection string”oSQLConn.Open()
Data Shape MS Data Shape”Provider=MSDataShape;Data Provider=SQLOLEDB;Data Source=Aron1;Initial Catalog=pubs;User ID=sa;Password=asdasd;”
2. SQL Server 2005
3. Access
4. Oracle
5. MySQL
6.Interbase
7.IBM DB2
8.Sybase
9.Informix
10. Ingres
11. Mimer SQL
12. Lightbase
13.PostgreSQL
14. Paradox
15. DSN
16. Firebird
17. Excel
18. Text
19. DBF / FoxPro
20. AS/400 (iSeries)
21. Exchange
22. Visual FoxPro
23 Pervasive
24. UDL
Kurang jelas kasih comment pasti dibantu dechhh ... ^_^
Forum Chat
Kamis, 03 Juli 2008
Langganan:
Postingan (Atom)
Alamat Yang Anda Gunakan ^_^
