Error while SQL Server connection to Java

Ads
 

Error while SQL Server connection to Java

import java.sql.*; public class OdbcSqlServerConnection { public static void main(String args[]) throws Exeption { Connection con=null; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

con=DriverManager.getConnection("jdbc:odbc:SQL_SERVER;user=DTHOTA;password= "); System.out.println("First Connection ok."); con.close();

java.util.properties prop = new java.util.properties(); prop.put("user", "DTHOTA"); prop.put("password", " "); con=DriverManager.getConnection("jdbc:odbc:SQL_SERVER", prop); System.out.println("Second Connection ok."); con.close(); } catch (Exception e) { System.out.println("Exception: " + e.getMessage()); } } }

}

After writing this code, i am getting an error as

OdbcSqlServerConnection.java:29: class,interface or enum is expected How to fix it.

View Answers

Ads









Related Tutorials/Questions & Answers:
Error while SQL Server connection to Java
Error while SQL Server connection to Java  import java.sql.*; public..."); con=DriverManager.getConnection("jdbc:odbc:SQL_SERVER;user=DTHOTA;password...("password", " "); con=DriverManager.getConnection("jdbc:odbc:SQL_SERVER", prop
Error while SQL Server connection to Java
Error while SQL Server connection to Java  import java.sql.*; public..."); con=DriverManager.getConnection("jdbc:odbc:SQL_SERVER;user=DTHOTA;password...("password", " "); con=DriverManager.getConnection("jdbc:odbc:SQL_SERVER", prop
Advertisements
SQL connection error in android
SQL connection error in android  hi, i am android developer . recently i made one application connect with sql server 2005 using jtds...:sql:Exception : BUFFERDIR connection property invalid. if you have any answer
Java to SQL Server Connectivity
Java to SQL Server Connectivity  Hi, heres my code private void... with sql server connectivity at the background to save the data. Now, after...("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conn = DriverManager.getConnection
error of HTTP Status 404 while running servlet on apache tomcat server
error of HTTP Status 404 while running servlet on apache tomcat server ... the apache tomcat page. It mean that my tomcat server is up and running. but whn i... here, the browser responds "HTTP Status 404 - /java_mail/hello" wht could
JDBC Connection code to connect servlet with SQL Server 2008
JDBC Connection code to connect servlet with SQL Server 2008  Please... sqljdbc4.jar but the output is SEVERE: Java Runtime Environment (JRE) version 1.6... connection code is static Connection con; static Statement st; static
Java servlet with jsp on sql server
Java servlet with jsp on sql server  How to delete a user by an admin with check box in Java Servlet with jsp on Sql Server?   Here...;/tr> <%try{ Connection conn = null; Class.forName("com.mysql.jdbc.Driver
connection proxy error in hibernate
connection proxy error in hibernate  while we get connection through hibernate we arise an error connection proxy error while we are using multiple connection's
PHP SQL close connection
,$connection) or exit("Sql Error".mysql_error()); echo "... PHP SQL close connection       PHP SQL close connection is used to close a connection between the PHP
Sql Connection is not creating
Sql Connection is not creating  Hi i am developing an web application... type 1 driver.And when i am running through eclipse using apache tomcat server it is creating sql connection and allwoing me to access excel but when i am
ftp connection error php
ftp connection error php  Getting a ftp connection error in php
connection proxy error in hibernate
connection proxy error in hibernate  while we get connection through hibernate we arise an error connection proxy error while we are using multiple error message is like below statements SEVERE: Servlet.service() for servlet
error oracle database connection?
error oracle database connection?  hi now i am trying to connect...; PreparedStatement stmt=null; Connection con =null; ResultSet rs=null...); out.println("inserted1"); //String sql="insert into userdetails values
error in driver connection
error in driver connection  String driver = "org.gjt.mm.mysql.Driver"; Class.forName(driver).newInstance(); //error at this line Connection con=null; ResultSet rst=null; Statement stmt=null
connection database error
connection database error  import java.awt.EventQueue; // import...{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection...;which type of error occurs? Specify it. Is NWIND is your dsn
PHP SQL Connection
,$connection) or exit("Sql Error".mysql_error()); $sql_num=mysql... PHP SQL Connection       PHP SQL Connection is used to access and return the records from PHP
correct the sql error
correct the sql error  i am getting a SQL Error while retriving data...(null,"Please enter the Student ID to Search","Error",0); } else { try...("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc
JSP SQL Error
JSP SQL Error  Hi While trying to execute the below code i'm getting the following error "java.sql.SQLException: Io exception: Got minus one from...("oracle.jdbc.driver.OracleDriver").newInstance(); Connection con=DriverManager.getConnection("jdbc
SQL Error Version 5.5.15
SQL Error Version 5.5.15  SQL Error Version 5.5.15
error : not an sql expression statement
error : not an sql expression statement  hii I am gettin followin error in connecting to database SQLserver 2005 in Jdeveloper,i m usin struts... { Connection conn = DatabaseManager.getConnection(); Statement stmt
Java FTP Connection
Java FTP Connection  I am learning to develop a program in Java. As a learning process I want to make a connection to the FTP server just to check if it works? How to make Java FTP Connection to FTP server hosted in my network
java connection leak
java connection leak  How to check the connection leak in Java
while executing a java program
while executing a java program  while iam executing a simple java program after i type "java simple.java" there was a an error occuring.the error is "exception in thread "main" java.lang.noclassdeffounderror:simple" what thus
sql syntax error help
sql syntax error help  this query show syntax error .. i am unable to figure it out insert into order (orderdate, dpname, paymethod, tamount...') where is the error ?   Please send the error details and the datatype
connection retry in java
connection retry in java  How to retry the connection automatically once it get disconnect..?   Connection connection = null; while (connection == null) { try { connection = DriverManager.getConnection(url
getting error while inserting values in database
getting error while inserting values in database  AddUser.java...) { out.println("An Error Had occurred while accessing the database..."); Connection con = null; Statement st1 = null
SQL QUERY ERROR
SQL QUERY ERROR  Im writing a query which shows error of INVALID... THE FORM IS THROWING THE ERROR OF INVALID CHARACTER BUT THE SAME QUERY IS RUNNING..._value'. . .); For more information, visit the following link: SQL Queries
Java error
Java error  class WhileLoopMethod{ public static void main(String args[]){ new Hello(); } } class Hello{ int a = 5, b = 88; while(a } //it is giving compile time error .....illegal start
Java error
Java error  class WhileLoopMethod{ public static void main(String args[]){ new Hello(); } } class Hello{ int a = 5, b = 88; while(a } //it is giving compile time error .....illegal start
Wamp server error
Wamp server error  Whenever i am executin program of database connectivity using php i am getting error to the following statement: $q="select password from login where username=".$uid; while($row=mysqlfetcharray($q)) I am
sql connectivity through java
sql connectivity through java  i want an example for java db through sql connection. Thanks in advance

Ads