solve the problem in connection of SQLSERVER 2003 WITH JAVA

Newbie Member
8Apr2007,14:12   #1
rajeev85's Avatar
WHEN I CONNECT THE SQLSERVER2003 WITH NETBEAN IDE
IT OCCURED A PROBLEM THAT URL IS NOT SPECIFIED.



I M INSTALL SQL Server 2000 Driver for JDBC Service Pack 3.AND SET THE CLASSPATH IN ENVIRONMENT VARIABLES,

THE SPECIFIED URL IS

jdbc:microsoft:sqlserver://<host>:<port>[;DatabaseName=<DB>]

SO PLZ SOLVE THE PROBLEM
Newbie Member
10Apr2007,01:16   #2
rajeev85's Avatar
the database server is SQLSERVER 2000
Go4Expert Member
25Jan2008,18:00   #3
venkatesanj@hcl.in's Avatar
The path should be

jdbc:microsoft:sqlserver:Your Ip address:1433;Your Database Name

Regards,
Venkatesan Prabu. J