Interested to Buy Any Domain ? << Click Here >> for more details...
dear friends
I have made connection with SQLSERVER where the following
code is compiling properly but giving error at the runtime .
I think error in this line where i am sending the value
through string
Connection connection = DriverManager.getConnection
( "jdbc:microsoft:sqlserver://localhost:1433","sa","");
import java.sql.*;
//import mssqlserver.*;
public class TestSQLCON
{
public TestSQLCON() throws Exception
{
// Get connection
DriverManager.registerDriver(new
com.microsoft.jdbc.sqlserver.SQLServerDriver());
System.out.println();
System.out.println("Successfully connected one");
System.out.println();
Connection connection = DriverManager.getConnection
( "jdbc:microsoft:sqlserver://localhost:1433","sa","");
if (connection != null)
{
System.out.println();
System.out.println("Successfully connected");
System.out.println();
// Meta data
DatabaseMetaData meta = connection.getMetaData();
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());
}
}
public static void main (String args[]) throws Exception
{
TestSQLCON test = new TestSQLCON();
}
}
so please help me
- 2 Answers
- 5237 Views
- I also Faced
- E-Mail Answers
Answer Posted / cheemu
Looks like you forgot to mention the database name in your
database URL
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is sqlwarning and discuss the procedure of retrieving warnings?
Why do we need jdbc?
Does the JDBC-ODBC Bridge work with Microsoft J++?
Result set’s index starts with 0 or 1?
Does jdbc use odbc?
What is jsp and jdbc?
What are the advantages of collection pools?
What is benefit of using preparedstatement in java?
Where can I find info, frameworks and example source for writing a JDBC driver?
what happen if we set JDBC string to NULL?
code to insert values/rows into oracle database from a java swing textfield when a button is pressed(using preparedstatements)
Briefly tell about the jdbc architecture.
What is DML?
What is the major difference between java.util.date and java.sql.date data type?
What is an SQL Locator?
