Welcome to www.programmer2programmer.net for the SQL Server 2000  ODBC, OLEDB, SQLClient Connection Strings

programmer2programmer.net

 Tips
 Microsoft Certification
 Final Year Project Idea
 Connection Strings
 Password Recovery
 SQL Injection
 Encryption & Decryption
  
 LIVE Academic Project
 Project #1 - VB6, Access
  Project #2 - VB.Net, SQL
 Project #3 - ASP, Access
 Project #4 - ASP.NET, C#
 Project #5 - VB6, SQL
 Project #6 - Stegano
 Project #7 - C
 Project #8 - C++
 Project #9 - JAVA, MySQL
 Project #10- PHP, MySQL
 Project #11- JSP, Oracle
 Project #12- C# Face Exp
 Project #13- Mobile Bank
 Download MBA Project
 MBA Project Topic
 Project Viva Question
  2017 New Projects
 Project Synopsis Download
  
 University Question Paper, Assignment and Projects
 SMU - Question Paper
 SMU - Assignment
 SMU - Synopsis Projects
 SCDL - Assignment
 IGNOU - Synopsis Projects
 Welingkar - Projects
 Project Report Formats
  
 Interview Question Answer
 General & HR Round
 Visual Basic 6
 VB.Net & C#
 ASP.Net
 SQL Server
  Oracle and DBA
 My SQL
  

100% Tested
Ready Academic IT Projects

BE, ME, BTech, BCA, MCA, MBA, Bsc-IT, MS, BIT, ADIT, DOEACC, IGNOU, SMU
readymadeproject.com
 Microsoft SQL Server 2000 Connection Strings for OLEDB, ODBC, SQLClient standard and trusted security
Home Personal Member Forum Source Project Tips Contact
 

 Largest collection of Connection Strings on Internet for -

SQL Server 2000 Connection Strings

1. SQL Server 2000 Connection Strings

2. SQL Server 2005 Connection Strings
3. SQL Server 2005 CE Connection Strings
MS SQL Server 2000 Connection Strings including ODBC, OLE DB and SQL Client Connection Strings. 4. Oracle Connection Strings
5. MySQL Connection Strings
This is the complied and tested collection of Microsoft SQL Server 2000 Connection strings including

MS SQL Server 2000 ODBC Standard Security Connection String, Trusted connection, OLE DB, OleDbConnection (.NET) Standard Security Connection Strings, Trusted connection String, Connecting to an SQL Server instance , Connect via an IP address, SqlConnection (.NET), Standard Security, Trusted Connection String
6. Postgree SQL Connection Strings
7. MS Excel Connection Strings
8. MS Excel 2007 Connection Strings
9. Text/CSV File Connection Strings
10.MS Access Connection Strings
11.MS Access 2007 Connection Strings
12.VisualFoxPro/FoxPro 2.6 CS
13.DBF Connection Strings
   
 
  ODBC Connection String for SQL Server 2000
    Standard Security
     
Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
     
' VB.NET
Imports System.Data.Odbc
...
Dim oODBCConnection As OdbcConnection
Dim sConnString As String = _
"Driver={SQL Server};" & _
"Server=MySQLServerName;" & _
"Database=MyDatabaseName;" & _
"Uid=MyUsername;" & _
"Pwd=MyPassword"
oODBCConnection = New Odbc.OdbcConnection(sConnString)
oODBCConnection.Open()
 
    Trusted connection
     
Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Trusted_Connection=Yes;
     
 
  OLE DB, OleDbConnection (.NET) Connection String for SQL Server 2000
    Standard Security
     
Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
     
' VB.NET
Imports System.Data.OleDb
...
Dim oOleDbConnection As OleDbConnection
Dim sConnString As String = _
"Provider=sqloledb;" & _
"Data Source=myServerName;" & _
"Initial Catalog=myDatabaseName;" & _
"User Id=myUsername;" & _
"Password=myPassword"
oOleDbConnection = New OleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()
 
    Trusted connection
     
Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;
       
    Connecting to an SQL Server instance
     
Provider=sqloledb;Data Source=myServerName\theInstanceName;Initial Catalog=myDataBase; Integrated Security=SSPI;
       
    Connect via an IP address and Port
     
Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
     
 
  SqlConnection (.NET) Connection String for SQL Server 2000
    Standard Security
     
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername; Password=myPassword;
       
    Trusted connection
     
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;
     
Imports System.Data.SqlClient
...
Dim oSQLConn As SqlConnection = New SqlConnection()
oSQLConn.ConnectionString = _
"Data Source=(local);" & _
"Initial Catalog=myDatabaseName;" & _
"Integrated Security=SSPI"
oSQLConn.Open()
 
    Connecting to an SQL Server instance
     
Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=True;
       
    Connect via an IP address and Port
     
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
       
       
   
Connection Strings Main  

(C) Atanu Maity, 2006-2017