DNN Expert posted on August 09, 2011 05:12
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;"