Re: MS Access databases

From: nos (nos_at_nospam.com)
Date: 11/07/03

  • Next message: Bjorn Abelli: "Re: MS Access databases" 
    Date: Thu, 06 Nov 2003 23:47:03 GMT

    thanks i'll try it out

    "Bjorn Abelli" <DoNotSpam.bjorn_abelli@hotmail.com> wrote in message
    news:boemd1$1ca0dq$1@ID-73292.news.uni-berlin.de...
    >
    > "nos" wrote...
    > > Correct that it is only one way to do it.
    > > I would have liked to have used JDBC,
    > > but didn't know how at the time and only ODBC is
    > > available on my pc.
    >
    > Just to clarify things, you *are* using JDBC in your example, but you're
    > using the internal JDBC-ODBC-bridge for access to Access...
    >
    > > If anyone knows of a JDBC driver for MS Access
    > > or MS Works please let me know.
    >
    > My last comment was on the question on how to change the connection to
    > SQL-Server instead of MS Access, and in the case of SQL-server i pointed
    to
    > a place where the JDBC-driver can be downloaded.
    >
    > http://tinyurl.com/twlb
    >
    > AFAIK there exists no JDBC-driver of type 4 (native access) for MS Access.
    > There are some drivers for Access of type 2 and 3 (additional software
    > besides the driver has to be installed) listed on Sun's site:
    >
    > http://tinyurl.com/qhu4
    >
    > NB! The list says that BCS has drivers of type 4, but that's only for SQL
    > Server, not MS Access...
    >
    > // Bjorn A
    >
    >
    >

  • Next message: Bjorn Abelli: "Re: MS Access databases"

    Relevant Pages

    • RE: BUG: JDBC connection disconnected, cant reconnect
      ... SQL 2005 Standard ... Windows Server 2003, Service Pack 2 ... SQLServer JDBC driver 1.2 ... Sun JDK 1.6 ...
      (microsoft.public.sqlserver.jdbcdriver)
    • RE: Cannot connect to my SQL 2005 server using JDBC - can any dia
      ... Do you have any references on which version of the Microsoft JDBC driver ... is talking about doesn't talk to UDP 1434 to retrieve the port automatically. ... I have seen some scenarios where not every JDBC drivers handles problems with the UDP broadcast from the SQL Browser service ... Cannot connect to my SQL 2005 server using JDBC - can any diagnostic tool tell me what the problem is? ...
      (microsoft.public.sqlserver.jdbcdriver)
    • Re: Using MARS with JDBC Driver
      ... To be clear I am talking about the MICROSOFT SQL SERVER 2005 JDBC DRIVER ... > connection and opted for client ...
      (microsoft.public.sqlserver.jdbcdriver)
    • Re: Behavior of Connection.commit()
      ... transaction count on the server is what we expect at that point in time.... ... Does anyone know what the JDBC ... >> should the driver throw an error? ... > doesn't say what happens if the JDBC driver sends "shutdown" SQL to the ...
      (microsoft.public.sqlserver.jdbcdriver)
    • JDBC connection Issues
      ... I am very new to JDBC. ... could be with the server... ... Am I really using a type 4 driver? ... An appropriate license file db2jcc_license_*.jar for this target ...
      (comp.lang.java.programmer)