Error while SQL Server connection to Java

Ads

 
 

Share on Google+Share on Google+

Deepika Thota
Error while SQL Server connection to Java
0 Answer(s)      5 years and 2 months ago
Posted in : SQL

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.

Ads
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
Database connection sql server 2005 - JDBC
Database connection sql server 2005  Hi all i am developing an application in struts and i need to connect database for that application using sql server 2005.. can anyone tell me how to make database connection ..plz help me
error while compiling - Java Beginners
error while compiling  i am facing problem with compiling and running a simple java program, can any one help me, the error i am getting is javac is not recognised as internal or external command  Check if you JAVA_HOME
Error While Compiling - Java Beginners
Error While Compiling  Hi All I Am a beginner and i face the following problem while compiling can anyone help me. C:\javatutorial\example> javac HelloWorld.java 'javac' is not recognized as an internal or external
java oracle connection problem - SQL
java oracle connection problem  I have successfully made connection with the oracle10g database that i am using and also able to put in data using JSP. But the codes that i have tried for fetching the data are not working even
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
Java Compilation error - SQL
Java Compilation error  ava.lang.NullPointerException at beanUtils.SaleHeaderUtility.getFullRemainPatientList(SaleHeaderUtility.java:754) at forms.ProcessDialog.updatePatientBalances(ProcessDialog.java:119
connection error - WebSevices
connection error   while conncting a tool(jet profiler for my sql 1.0 released) with my running application ,it reflects following error: connected,but failed to login,read time out
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
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
error while running the applet - Java Beginners
error while running the applet  import java.applet.Applet; import java.awt.*; import java.awt.event.*; class MyFrame extends Frame { boolean...); ++num; } } } } i have problem while running the code , error
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 - SQL
connection  how can i establish connection between netbean_ide6.9 with mysql or oracle  Hi Friend, Please visit the following link: http://www.roseindia.net/jsf/visual-jsf.shtml Hope that it will be helpful
errors while run - Java Server Faces Questions
errors while run  I,ve download the SimpleHelloByEnteringName jsf intoduntion sample project and tried to run this application following the steps narrated in roseindia jsf tutorial. But i found the fillowing error:(My
DataBase connection with sql - Struts
DataBase connection with sql  How to connect sql and send db error in struts? what are the tag should i code in struts-confic.xml
ftp connection error php
ftp connection error php  Getting a ftp connection error in php
database connection - SQL
to connect sql server to my eclipse editer how to connect and where i have to write code... the tables. Thanks in advance.  Hi Friend, Do you want to use java-database connection in eclipse IDE? Thanks
Java error reached end of file while parsing
Java error reached end of file while parsing       Java Error reached end... an error i.e java error reached end of file while parsing as the class closing braces
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
Java servlet sql connectivity error - JSP-Servlet
Java servlet sql connectivity error  Hi, I have been trying... successful so far. However when i try to connect to sql through a normal java program... to store data into sql database the connection does not get established. I am
syntax error in SQL Insert Statement - Java Beginners
syntax error in SQL Insert Statement  Dear Sir ,I have write following code to save data into access databse, but code gives following error code...)values(?,?)"); Error: java.sql.SQLException: [Microsoft][ODBC Microsoft
Error - Java Server Faces Questions
""; } But In eclipse i am getting Error Like This, import org.apache.log4j.Logger cannot... Is the Error. Thanks. Puppy   Hi friend, Very simple problem
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 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
java and sql server NOT Mysql - JSP-Servlet
java and sql server NOT Mysql  Hi guys. Thank you all for the various helps you render to everyone. Please the question I asked the last time... image from MS SQL server NOT MySQL. Or is it not possible to do it in MS SQL server
SQL Server
SQL Server  Hii, What is SQL Server ?   hello, SQL Server is a DBMS system provided by Microsoft
SQL Error - SQL
SQL Error  Invalid character value for cast specification on column number 5 (Designation) Whats this error about this if the field i specified in programming error. ie DB fields in above question

Ads

 
Advertisement null

Ads