JDBC and MSAccess-Databases

JDBC and MSAccess-Databases

Post by Michael Henninge » Thu, 08 May 1997 04:00:00



I would like to connect to a Access-File (*.mdb)with the
JDBC-ODBC-Bridge.
The Accessfile is located on an Web-Server (Microsoft Informationserver
WinNT4.0).
What should i do to connect?

How does the URL look like ?  (JDBC:ODBC:????)

Who could give me an example for an URL.

Thank U

Michael

 
 
 

JDBC and MSAccess-Databases

Post by Michael Che » Sat, 10 May 1997 04:00:00


I suggest that you use a type-3 JDBC driver instead of ODBC-Bridge.
Take a look at IDS Server and IDS JDBC Driver:

   http://www.idssoftware.com/

--Michael



Quote:> I would like to connect to a Access-File (*.mdb)with the
> JDBC-ODBC-Bridge.
> The Accessfile is located on an Web-Server (Microsoft Informationserver
> WinNT4.0).
> What should i do to connect?

> How does the URL look like ?  (JDBC:ODBC:????)

> Who could give me an example for an URL.

> Thank U

> Michael


 
 
 

1. Problem with JDBC and MsAccess database

I have a weird problem...when I trace it in the debugger (F10), it works
fine, but when I execute or run it in the debugger without tracing it,
getColumns returns no columns for the second table and rs.next() returns
false:

rs = metaData.getColumns(catalog, schema, table, null);

 columns = new ObjectList();

while(rs.next()) columns.add(rs.getString(4));

Does someone have an idea ?

2. Need Help...Program for anyone who can help.

3. JDBC, J2EE, MSAccess - connection problems

4. How to define Level Naming Template(Parent Child) in a LocalCube????

5. JDBC-Driver 4 MSAccess

6. (PDXJOBS) QA Engineers in the Portland a

7. MSAccess JDBC-ODBC and Timestamp

8. SQLNET x NET8 x LONG field - Help PLLLLLEEEEEAAAASSSSSEEEEE

9. JDBC-ODBC MsAccess

10. JDBC/MSAccess Insert Timing problem?

11. slow JDBC to MSAccess

12. How to connect to MSAccess using JDBC:ODBC

13. GIF Images, MSAccess and JDBC