Sample Connection Strings

Oracle: "Provider=MSDAORA; Data Source=ORACLE8i7;Persist Security Info=False;Integrated Security=yes"

Microsoft Access: "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\bin\LocalAccess40.mdb"

SQL Server (Integrated Security): "Provider=SQLOLEDB; Data Source=MySQLServer; Integrated Security=SSPI"

SQL Server: "Provider=SQLOLEDB; Data Source=myServerAddress; Initial Catalog=myDataBase; User Id=myUsername; Password=myPassword"

MySQL: "Provider=MySQLProv; Server=myServerAddress; Database=myDataBase; Uid=myUsername; Pwd=myPassword;"

IBM AS/400: "Provider=SNAOLEDB; DataSource=myServerAddress; UserID=myUsername; Password=myPassword; DataCompression=True;"