ODBC访问 Access数据库

来源：互联网发布：哈希算法编辑：程序博客网时间：2024/06/05 17:02

try {Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");try {Connection conn=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=\\192.168.1.108/db/EyeTest.mdb");} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();}

ODBC访问Paradox数据库（如果遇到连接不同设置编码问题设置language driver 为需要的语言）更改语言需要 database Desktop 查看器更改

try {Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");try {Connection conn=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Paradox Driver (*.db )};DriverID=538;Fil=Paradox 5.x;DefaultDir=\\192.168.1.138/db;Dbq=\\192.168.1.138/db;CollatingSequence=ASCII");} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();}}

0 0