Stack Overflow
Stack Overflow

Questions tagged [jdbc-odbc]

The JDBC-ODBC Bridge enables Java applications to access ODBC data sources through the JDBC interface.

The JDBC-ODBC Bridge enables Java applications to access ODBC data sources through the JDBC interface. It was created to allow access to data sources that had an ODBC driver but did not have a native JDBC driver.

Important note (from Oracle's Java SE documentation):

The JDBC-ODBC Bridge should be considered a transitional solution; it will be removed in JDK 8.

307 questions
-1
votes
1 answer

JDBC connection to MS SQL Server 2012 error

I have a server with Windows Server 2003 SP2 and third party application developed with Java SE version 5.0. This app connecting to external database server via configured ODBC source. In my ODBC sources I have configured source to external MS SQL…
Kostya
  • 141
  • 3
  • 14
-1
votes
1 answer

Java ODBC Ms Access Driver

I am using the following specifications, and I want to learn about Java to Microsoft Access, you can visit the update here However, there's 2 Files odbcad32 on my system, the first one located on system32 and the second one located on syswow64 I…
Cignitor
  • 891
  • 3
  • 16
  • 36
-1
votes
1 answer

Exception in thread "main" java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]

while trying to insert genename in ms access table through java code I am getting the error as Exception in thread "main" java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression…
Thiyagarajan
  • 1
  • 1
  • 1
-1
votes
1 answer

getting issue while conecting the MS SQL server remotely through java code

This is my code for connecting to the Server remotely. One thing more i would like to tell you guys that this code works only i am within my home network (the network in which server is installed) but i am unable to access it from other network …
gautam ..
  • 1
  • 1
-1
votes
1 answer

How to retrieve image in jsp from oracle database?

In a JSP page, I want to display an image stored in a database. How do I do this? I tried the following JSP code but it displays nothing in the browser. What am I doing wrong? <% HttpSession ses2=request.getSession(); String email2…
Ravindra Bairagi
  • 11
  • 4
-1
votes
2 answers

SQL syntax error when connecting with java and using " ' "

I have connected an access db with java applet. In it I am giving values of students and their schools when working with schools, there are two schools (supposingly): Little Flower School St. Joseph's School I have a method store and getchestname…
frunkad
  • 2,433
  • 1
  • 23
  • 35
-1
votes
1 answer

data type mismatch in criteria expression vb.net access

This My Code Public Function simpan() As Integer Dim sql As String Dim cmmd As OleDbCommand sql = "INSERT INTO disposisi (nodisposisi,noagendamasuk,idseksi,intruksi,tgldisposisi,nosurat,perihal,nama)" & _ …
user3849240
  • 1
  • 1
-1
votes
2 answers

Running java file

I have scenario below I have all my files (HW2.java and 3 jar files for JDBC/ODBC) in folder src. I am running the following commands but still getting errors but the above code runs fine in eclipse, the problem comes only when code in run via…
user3251915
  • 11
  • 1
  • 3
-1
votes
1 answer

Invalid SQL data type while storing null value using prepared statement

I am using MS-Access as database. In Ms access database I have one table with 2 columns, one is name and other one is document For name i am using Text Data Type and For Document i am using OLE Object if user not selecting any document then i am…
Android Surya
  • 544
  • 3
  • 17
-1
votes
1 answer

Why is that my java class is not reading the MS Access Database . The Application is running but login function is not working

billing.java This is the billing class and i have finish coding the system's login, it perfectly running in the Frame but one i input the usernames and password the access database is not detected. public class billing { Connection con; …
Arnni Nickard Alunahan Manuel
  • 1
-1
votes
4 answers

Connect to mySQL using eclipse

I am trying to run a JAVA program which inserts values into mySQL database. When I run the program, it says Connection refused: connect I have included mySQL jars also. What is the problem? Can anyone help me out import java.sql.Connection; …
Benny
  • 521
  • 3
  • 8
  • 21
-2
votes
1 answer

JDBC Pagination Oracle get 1000 at a time execute then get next 1000

I'm using this code to get 1000 records at a time. It works fine but how do I stop at the 1st 1000 run my job, then pick up where I left off and get the next set 1001 - 2000, run the next job and so on? Please help I'm kind of stuck. public class…
Gee
  • 155
  • 2
  • 6
  • 21
-2
votes
1 answer

Why drivers are required for JDBC-ODBC?

I am having a little confusion of what I have studied. I have studied that drivers are software programs that are required to interact external hardware devices like printers,mouse,mobiles etc. But when I connect ODBC or JDBC in Java,it requires…
HN Singh
  • 98
  • 2
  • 13
-2
votes
2 answers

I am Connecting to data Base After Making Jar File in java But "ClassNotFoundException" after making jar file Below is code

Here IS Code Any Suggestions When i am trying to access the data base it shows error after making jar file File f = new File("E:\\DB\\**\\***.mdb"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); …
Ahmad
  • 770
  • 9
  • 21
-2
votes
1 answer

validate username and password in java and ms access

import java.sql.*; import java.util.*; class Check { public static void main(String[] args) { try { String username; String password; System.out.println("Enter username…
kanivalan vp
  • 3
  • 1
1 2 3
…
20
21