I am trying to connect Netbeans to a SQL server 2000 database . I downloaded the JDBC drivers and added to my CLASS_PATH. but when I try to connect to the databse using the runtime connection tool in netbeans, I get a blinking icon at the base of netbeans saying
java.lang.NoClassDefFoundE
rror: com/microsoft/jdbc/base/Ba
seDriver
at java.lang.ClassLoader.defi
neClass1(N
ative Method)
at java.lang.ClassLoader.defi
neClass(Cl
assLoader.
java:620)
at java.security.SecureClassL
oader.defi
neClass(Se
cureClassL
oader.java
:124)
at java.net.URLClassLoader.de
fineClass(
URLClassLo
ader.java:
260)
at java.net.URLClassLoader.ac
cess$100(U
RLClassLoa
der.java:5
6)
at java.net.URLClassLoader$1.
run(URLCla
ssLoader.j
ava:195)
at java.security.AccessContro
ller.doPri
vileged(Na
tive Method)
at java.net.URLClassLoader.fi
ndClass(UR
LClassLoad
er.java:18
8)
at java.lang.ClassLoader.load
Class(Clas
sLoader.ja
va:306)
at java.lang.ClassLoader.load
Class(Clas
sLoader.ja
va:251)
at java.lang.ClassLoader.load
ClassInter
nal(ClassL
oader.java
:319)
at java.lang.Class.forName0(N
ative Method)
at java.lang.Class.forName(Cl
ass.java:2
42)
at org.netbeans.modules.db.ex
plorer.DbD
riverManag
er.getDriv
erInternal
(DbDriverM
anager.jav
a:190)
at org.netbeans.modules.db.ex
plorer.DbD
riverManag
er.getConn
ection(DbD
riverManag
er.java:80
)
at org.netbeans.modules.db.ex
plorer.Dat
abaseConne
ction$2.ru
n(Database
Connection
.java:498)
at org.openide.util.RequestPr
ocessor$Ta
sk.run(Req
uestProces
sor.java:4
93)
[catch] at org.openide.util.RequestPr
ocessor$Pr
ocessor.ru
n(RequestP
rocessor.j
ava:926)
I try to connect from the NetBeans connection window adding this database url
jdbc:microsoft:sqlserver:/
/localhost
;DatabaseN
ame=Test
my classpath is
.;C:\derby\lib\derby.jar;C
:\derby\li
b\derbytoo
ls.jar;C:\
MSSQLJDBC\
lib;C:\MSS
QLJDBC\lib
\msbase.ja
r;C:\MSSQL
JDBC\lib\m
sutil.jar;
C:\MSSQLJD
BC\lib\mss
qlserver.j
ar
please ignore the derby part... it works.. I only have problems with MSSQL
I am trying to connect from the "netbeans runtime database connection wizard" using this URL
jdbc:microsoft:sqlserver:/
/localhost
: 1433 ;DatabaseName=Test
I also trid to Telnet, but I get this
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\brillante>telnet localhost 1433
Connecting To localhost...Could not open connection to the host, on port 1433: C
onnect failed
C:\Documents and Settings\brillante>
but the SQL istance is definetly running on my system
Is since yesterday night that I am trying to find something on the Net regarding Netbeans and SQL server issues.. but I did not found anything