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/
