Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT ACCESS
how to interact with ms-access(type4 driver) using jdbc
ramakrishna adipuram
2006-04-14 02:45:16.0
plz tell me ,
how to interact with ms-access using type 4 driver
plz send className,url of type for driver.
plz send links ,it requries any software to connect the ms-access using type 4 driver
Re:how to interact with ms-access(type4 driver) using jdbc
HXTT Support
2006-04-14 03:01:42.0
Connecting to the Database
className: com.hxtt.sql.access.AccessDriver
HXTT Access is a pure Java driver which needn't MS Access or ODBC, and can run on Linux/Uninx.

1.jdbc url: jdbc:access:///c:/mdbffiles/Northwind.mdb
insert into aTableName (columnName1,...) values(value11,...)

2.jdbc url: jdbc:access:////sys/data/mdbffiles/
insert into Northwind.aTableName (columnName1,...) values(value11,...)

how to create connection pooling in tomcat5.0.28(see this problem)
ramakrishna adipuram
2006-04-14 23:38:59.0
i get the error like:

org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null', cause:
java.sql.SQLException: No suitable driver
my server.xml code:

type="javax.sql.DataSource"/>



factory
org.apache.commons.dbcp.BasicDataSourceFactory


driverClassName
sun.jdbc.odbc.JdbcOdbcDriver


url
jdbc:odbc:ebsi


maxActive
20


maxIdle
10


maxWait
-1



my web.xml:

Oracle Datasource example
jdbc/myaccess
javax.sql.DataSource
Container


my class:

Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/myaccess");
con = ds.getConnection();
Re:Re:Re:how to interact with ms-access(type4 driver) using jdbc
HXTT Support
2006-04-14 23:44:08.0
>driverClassName:sun.jdbc.odbc.JdbcOdbcDriver
>url: jdbc:odbc:ebsi
You should change those setting. Please read How to set up HXTT Access with Tomcat4.1 as PoolableConnection?.
where to download type4 driver(ms-access) software
ramakrishna adipuram
2006-04-15 03:08:06.0
where to download type4 driver(ms-access) software to interact with ms-acces.
plz how set classpath and all procedures.
Re:Re:Re:Re:Re:how to interact with ms-access(type4 driver) using jdbc
HXTT Support
2006-04-15 03:46:23.0
HXTT Access is the only type 4 driver for MS Access. You can download it from HXTT Access. You can more about classpath in Installation
Re:Re:Re:Re:Re:Re:how to interact with ms-access(type4 driver) using jdbc
hhh
2006-04-22 02:09:49.0
hhh

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap