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
3
votes
2 answers

JDBC driver installed but exception

I am using a software that requires jbdc driver (for sql server 2005), my java version is 1.5.0_16. When I want to start the application, it throws me this exception : java.sql.SQLException: java.lang.ClassNotFoundException:…
Wael
  • 71
  • 5
3
votes
1 answer

specified DSN contains an architecture mismatch between the Driver and Application. JAVA

I'm trying to connect to a database made by MS Access using Java, but I cannot seem to manage. I am using JDBC ODBC bridge and I'm getting this exception: java.sql.SQLException: [Microsoft][ODBC Driver Manager] The specified DSN contains an…
Pradeep.PG
  • 189
  • 1
  • 1
  • 10
3
votes
0 answers

getString() does not retrieve String bigger than 255 characters

Data are in my excel sheet which contains several cols and rows. When I read the data using ResultSet string truncated 255 char. Connection xlsConn = DriverManager.getConnection("jdbc:odbc:driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm,…
laksys
  • 3,228
  • 4
  • 27
  • 38
3
votes
0 answers

IO exception: Size Data Unit (SDU) mismatch. Vendor code 17002

I am connecting through VPN to school site to access DB. I use SQL developer 3.0.04 to connect this database. But if I try to connect it this exception is thrown: "IO exception: Size Data Unit (SDU) mismatch. Vendor code 17002" Does anybody have…
exeq
  • 379
  • 1
  • 5
  • 15
3
votes
2 answers

Data base update query exception handling error

String Query="insert into sms (Jobno, Mobilenumber, MStatus, ReceivedTime, AmountDeducted, Message, DoneTime) values ("+jobnum +","+mobilenum+","+ smsstatus+",'"+ rxtimestamp+ "',"+ amt+",'"+smstxt+"','"+timedone1+"')"; Note: Through the…
Karthik Kolla
  • 29
  • 2
3
votes
1 answer

odbc excel java

I am using JDBC-ODBC DSN-less connection to connect to ms-excel file. I was able to query the excel file using query of form SELECT * FROM [Sheet1$] However this requires me to know the name of the Sheet in excel file (which may not always be…
Aditya Jain
  • 1,077
  • 1
  • 12
  • 25
2
votes
0 answers

Data inserting as ASCII Values using JDBC 2.0 Result set Updater methods

I am trying to insert the data using JDBC 2.0 with Resultset update methods with Type 1 Driver. But I am checking in the table, it inserted data as ASCII values. I mention the code below: try { stmt =…
user1127214
  • 3,109
  • 7
  • 26
  • 30
2
votes
2 answers

unicode supported jdbc connection with sqlserver using Data source name

Case 1: I am trying to connect to the sql-server 2005 database which is situated on the remote server using Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); connection =…
Nishit Jain
  • 1,549
  • 8
  • 21
  • 33
2
votes
3 answers

Java cannot retrieve Unicode (Lithuanian) letters from Access via JDBC-ODBC

i have DB where some names are written with Lithuanian letters, but when I try to get them using java it ignores Lithuanian letters DbConnection(); …
Edgar Buchvalov
  • 257
  • 2
  • 12
  • 22
2
votes
2 answers

com/microsoft/sqlserver/jdbc/SQLServerDriver has been compiled by a more recent version of the Java Runtime

I has db in MS SQL Server 2005 I has java project write on java 8. My project is on Windows 7 Professional's machine (64 bit). I use this jar: sqljdbc4.jar to connect to MS SQL Server 2005. But when I start my app I get error: [java] log4j: setFile…
Alexei
  • 14,350
  • 37
  • 121
  • 240
2
votes
1 answer

Using UCanAccess instead of the JDBC-ODBC Bridge for working with DBF files

I'm using NetBeans IDE 8.2 and would like to make a connection with UCanAccess to access my database files. Initially I was using jdbc:odbc but I found that Java 8 onward no longer supports this method Here is my initial coding…
Question asker
  • 45
  • 8
2
votes
1 answer

Connect to MS access databases in java

I am trying to input some data into a microsoft access database, but I always get the same error. Here is my code: import java.sql.Connection; import java.sql.DriverManager; public class testDDB { public static void main(String[] args) { try{ …
Nefarious62
  • 161
  • 1
  • 5
  • 15
2
votes
0 answers

Hue 3.10.0 not connecting to custom JDBC server (An error occurred while calling z:java.sql.DriverManager.getConnection)

I am able to connect to my custom JDBC server able to handle SQL queries via source code import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import…
fun2code
  • 19
  • 1
2
votes
2 answers

Troubles with JDBC-ODBC, DSN-less connection strings, and 64-bit Windows 7

I'm dealing with an issue that has arisen for an application I've been working on which connects to a Access file via JDBC-ODBC. On other Windows platforms, this issue hasn't been encountered, but on Windows 7 64-bit boxes, attempting to connect…
DJScythe
  • 51
  • 1
  • 5
2
votes
1 answer

No Data found exception while assigning the result set

I'm writing a code to get the count of values in a column and using this result I need to create a jtable in my swing. Right now when I print my result directly with a sysout there are no issues, the data is getting printed directly. But when I…
Rakesh
  • 564
  • 1
  • 8
  • 25
1 2
3
…
20 21