Monday, May 24, 2010

Contoh Connection String

Ke MS Access menggunakan OLEDB
SQLConnect("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;”);

Ke MSSQL Server menggunakan OLEDB
SQLConnect("Provider=SQLOLEDB.1;User ID=UserIDStr; Password=PasswordStr;Initial Catalog=DatabaseName;Data Source=ServerName;" );

Ke Oracle menggunakan Oracle OLEDB
SQLConnect(ConnectionId, "Provider=MSDAORA; Data Source=OracleServer; User ID=SCOTT; Password=TIGER;");

Ke MySQL menggunakan ODBC
SQLConnect(ConnectionId,“DSN=MySQLDB;DB=Sample;User ID=root;Password=root123");