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
- 5362 Views
- I also Faced
- E-Mail Answers
Answer Posted / ignatiuesarun
jdbc:sqlserver://SERVERNAME(\\SQLEXPRESS):(port);databaseName=dbname;user=sa;password=***;
Just try this code, I hope it will help, make sure it
whether TCP/IP listening the default port 1433 or
not,otherwise, you have to give the correct TCP dynamic
port, you can get it from
start->programs->MicrosoftSqlServer2005->configuration
tools->Sqlserver configuration manager->expand SqlServer2005
Network configuration->(click)Protocols for SqlExpress->(on
right hand side)make surec it TCP/IP enabled and right click
on it->properties->TCP dynamic port(this is port no here
your machine TCP/IP listen)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is jdbc database independent?
Once I have the Java 2 SDK, Standard Edition, from Sun, what else do I need to connect to a database?
What is jdbc databasemetadata interface?
What is jdbc connection string?
Write a program JDBCcode forfetching student database with SQL.
What is JDBC DataSource and what are it’s benefits?
Why are we using blob datatypes in jdbc?
What are drivers available?
What is a jdbc connection pool?
What are the advantages of using preparedstatement in java?
Does the database server have to be running Java or have Java support in order for my remote JDBC client app to access the database?
What is ojdbc14 jar?
What is JDBC Driver interface?
How to update a resultset programmatically?
What is an SQL Locator?
