Versi java yang dipakai J2SDK1.4.2
Driver JDBC yang dipakai Service Pack 3
Source code yang dibuat:
import java.sql.*;
public class Test2 {
public static void main(String[] args) {
try {
// Get connection
DriverManager.registerDriver(new
com.microsoft.jdbc.sqlserver.SQLServerDriver());
String url="jdbc:microsoft:sqlserver://<nama
komputer>;DatabaseName=<nama database>";
Connection conn=DriverManager.getConnection
(url,"<user>","<password>");
Statement stmt=conn.createStatement();
DatabaseMetaData meta = conn.getMetaData();
if (conn != null) {
System.out.println();
System.out.println("Successfully connected");
System.out.println();
// Meta data
System.out.println("\nDriver Information");
System.out.println("Driver Name: " + meta.getDriverName());
System.out.println("Driver Version: " + meta.getDriverVersion());
System.out.println("\nDatabase Information ");
System.out.println("Database Name: " + meta.getDatabaseProductName
());
System.out.println("Database Version: " +
meta.getDatabaseProductVersion());
}
} catch(SQLException se) { System.out.println("ERROR: " +
se.getMessage()); }
}
}
Trus ternyata pesan errornya:
ERROR: No suitable driver
Ada yang bisa ngasih solusinya gak?
Sebelumnya makasih banyak....
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
:: Hapus bagian yang tidak perlu (footer, dst) saat reply! ::
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##
$$ Iklan/promosi : www.itcenter.or.id/sponsorship $$
[@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/