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

Connect to an Access database in Java using NetBeans

How do I connect to an Access database in Java? I have done like this: package inspection.management.system; import java.sql.*; /** * * @author Fuhans */ public class Database { public static void DatabaseConnectivity() { try …
Kaoru
  • 2,853
  • 14
  • 34
  • 68
2
votes
4 answers

Too Many Client Task Exception in Java JDBC

I am creating a JDBC ODBC connection through JAVA programs. I have to make with this connection so many times . After some times the program throws the Too Many Client Task Exception . How can is resolve this problem . I am pasting a sample example…
adesh singh
  • 1,727
  • 9
  • 38
  • 70
2
votes
3 answers

Reading Visual Foxpro Data From Java using ODBC

I am trying to query a dbf table from my Java application. I put in reference this thread I created a system data source using the ODBC Data Source Administrator, I set the data source name to be VFPDS and set the database type to .DBC finaly i set…
user1912404
  • 386
  • 4
  • 11
  • 26
2
votes
3 answers

odbc connection

I would like to install odbc in ubuntu server 10.10 with mysql: I did sudo apt-get install libmyodbc edited odbcinst.ini [MySQL] Description = ODBC for MySQL Driver = /usr/lib/odbc/libmyodbc.so Setup = /usr/lib/odbc/libodbcmyS.so FileUsage = 1 And…
user1256477
  • 10,763
  • 7
  • 38
  • 62
2
votes
0 answers

JRuby JDBC Without Username or Password in database.yml

It it possible to use the JDBC Postgres (jRuby) driver without specifying a username and password in the database.yml file? My project database file currently is: test: &test adapter: postgresql encoding: unicode database: app_test pool:…
Stussa
  • 3,375
  • 3
  • 24
  • 35
2
votes
1 answer

java.sql.SQLException:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

I have a java application that uses access database. My PC has 64-bit Operating System, 64-bit Microsoft Office, and 64-bit JDK. I even installed the Access Database Engine x64. Basically everything on it is 64-bit. In control panel, my target is…
Lazarus
  • 49
  • 8
2
votes
1 answer

How to connect an odbc database to my java code?

I need to connect an odbc database to my java code. I know that for connecting mdb database I need to use this code but it doesn't work: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // set this to a MS Access DB you have on your machine String…
whiteberryapps
  • 1,392
  • 4
  • 16
  • 21
2
votes
1 answer

SQL Server 6.5 jdbc (jdts) incompatibility

I tried both jdts 1.2.2 and 1.2.5 (in DBVisualizer or IReport 4.5)to connect to a SQL Server 6.0. the URL is jdbc:jtds:sqlserver://localhost/mydbname;instance=;TDS=4.2 But both version (1.2.2 and 1.2.5) give me error. Please use TDS protocol…
wingkitcwk
  • 21
  • 2
2
votes
3 answers

MS ACCESS jdbc.odbc connection. data source name not found/No default driver specified?

I'm trying to study for a basic SQL test at school but unfortunately I copied the class that we are supposed to use into a project on my pc and I am getting the following error: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source…
Ross Borchers
  • 145
  • 1
  • 2
  • 11
1
vote
1 answer

jdbc-odbc bridge - import text with german umlauts does not work

I have MS Access database file with german umlauts in text fields. When i try to read them i have strings with ? characters instead of characters with umlauts. I try to set different characters set for database connection like…
Anton
  • 575
  • 2
  • 7
  • 27
1
vote
3 answers

Query returning values from Oracle and no records when run from Java

This query is returning the record with Min Create time Stamp for the Person Pers_ID when I run it in SQL Developer and the same query is not returning any value from Java JDBC connection. Can you please help? select PERS_ID,CODE,BEG_DTE from…
user549432
  • 137
  • 2
  • 8
  • 20
1
vote
6 answers

select data from last 2 rows sql

Im using an odbc-jdbc bridge in my project and I need select 2 pieces of data from the database and save the data to 2 variables on the java side of my application. Here is an example of my table. SITE_ID ------- DEV_ID ------- SCHEDULE_TIME -------…
Beef
  • 1,413
  • 6
  • 21
  • 36
1
vote
3 answers

Delete rows with conflicting times using jdbc-odbc

I wasnt quite sure how to word the title so sorry about that. I am trying to load some start and stop schedule times into a database but sometimes a start and stop time for the same system will overlap such as one time may be 5:30 to 12:30 and then…
Beef
  • 1,413
  • 6
  • 21
  • 36
1
vote
0 answers

MongoDB ODBC Connector is not able to fetch new fields/columns Into BI. currently using CData connector, it giving error

Apart from MongoDB ODBC Connector I found some third party connectors CData: https://www.cdata.com/drivers/mongodb/odbc/ devart:…
usmansharif shaik
  • 65
  • 8
1
vote
0 answers

JDBC Driver error when connecting to Snowflake through DataGrip

Sorry to reach out, I searched for an answer but I didn't see anything relating to my specific issue, sorry if I missed it. I used to connect fine to Snowflake using Datagrip with JDBC driver 3.13.5. Yesterday, in order to be able to use Snowflake…
NicolasK
  • 11
  • 1
1 2 3
…
20 21