anda pakai sql server versi apa?
jdk v1.4.2 ideal dipakai di v7/2000.
Pastikan jdbc-nya terinstall dengan baik.
jika tidak bisa juga gunakan di variable url port
server ms.sql-nya, ex 1433 (default).
saran saya pastikan dulu jdbcnya jalan, jangan
terburu2 update ke sp3.
sukses!
--- Eka Putri [EMAIL PROTECTED] wrote:
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
Rgds,
Marthen
Pesan Global
http://www.pesanglobal.com
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
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/
