solve the problem in connection of SQLSERVER 2003 WITH JAVA

rajeev85's Avatar, Join Date: Feb 2007
Newbie Member
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
rajeev85's Avatar, Join Date: Feb 2007
Newbie Member
the database server is SQLSERVER 2000
venkatesanj@hcl.in's Avatar
Go4Expert Member
The path should be

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

Regards,
Venkatesan Prabu. J