Welcome to www.programmer2programmer.net the for the Oracle ODBC, OLEDB, OracleClient Connection Strings


Programmer 2 Programmer

 Security Tips
 SQL Injection
 Encryption & Decryption
 Password Recovery
  
 Tips
 Connection Strings
 Interview Question
 Microsoft Certification
  
 LIVE Project
 Project #1
 Project #2
  
 Web Development
 HTML
 DHTML
 CSS
  
 Scripting
 Java Script
 VB Script
  
 Web Programming
 Cold Fusion
  
 Site Map
 Site Map
  
 Oracle Connection Strings for ODBC, OLEDB, ODP.NET standard and trusted security
Home Personal Member Forum Source Project Tips Contact  
 
 

 Largest collection of Connection Strings on Internet for -

Oracle Connection Strings

1. SQL Server 2000 Connection Strings

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

Oracle Database ODBC Standard Security Connection String, Trusted connection, OLE DB, OleDbConnection (.NET) Standard Security Connection Strings, Trusted connection String, Connecting to an remote Oracle Database , Connect via an IP address, OracleConnection (.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 Oracle
    Standard Security
     
Driver={Microsoft ODBC for Oracle};Server=myServerAddress;Uid=myUsername;Pwd=myPassword;
     
' VB.NET
Imports System.Data.Odbc
...
oConn.Open "Driver={Microsoft ODBC for Oracle};" & _
"Dbq=myDBName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"
     
 
  OLE DB, OleDbConnection (.NET) Connection String for Oracle
    Standard Security
     
Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;
     
' VB.NET
Imports System.Data.OleDb
...
oConn.Open "Provider=msdaora;" & _
"Data Source=MyOracleDB;" & _
"User Id=myUsername;" & _
"Password=myPassword"
 
    Trusted connection
     
Provider=msdaora;Data Source=MyOracleDB;Persist Security Info=False;Integrated Security=Yes;
     
 
  OracleConnection, Oracle Data Provider, ODP.NET for Oracle Database
    Standard Security
     
Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;Integrated Security=no;
       
    Using Connection Pooling
     
Data Source=myOracleDB;User Id=myUsername;Password=myPassword;Min Pool Size=10;Connection Lifetime=120;Connection Timeout=60;Incr Pool Size=5;Decr Pool Size=2;
     
    Windows Authentication
     
Data Source=myOracleDB;User Id=/;
       
    Privileged Connection
     
Data Source=myOracleDB;User Id=SYS;Password=SYS;DBA Privilege=SYSDBA;
       
       
   
Connection Strings Main  

(C) Atanu Maity, 2006-2007