Re: Jet Database Driver Documentation

From: Llelan D. (NOSPAM_at_TheSnakePitDev.com)
Date: 06/15/04 

Date: Tue, 15 Jun 2004 02:18:51 -0700

Kevin Yu [MSFT] wrote:
> First of all, I would like to confirm my understanding of your issue. From
> your description, I understand that you need to get documentation of SQL
> syntax and SQL function that Jet 4 driver supports. If there is any
> misunderstanding, please feel free to let me know.
You are half correct. I also need the docs to the ODBC Microsoft Access
driver, which the MS site says is a separate driver. I need to know what the
differences are, if any, between the two.

> Based on my research, if you have Access installed on your machine, a file
> named JETSQL40.CHM will be included in the following folder: (I have Access
> 2003 installed. Please adjust according to version and language.)
I managed to find this Sunday night. That help doc actually appears in the
Access help doc, but it doesn't specify a version number. As I have Access
2000, I had thought it was for a previous version. It wasn't until I found the
  help filename that I realized it was for the current v4.

However, this does not help anyone who does not have Access. Since the driver
is a freely available download, I was looking for a download site for the doc.
This will be needed when the Jet driver is upgraded, since I never again
intend to waste money on a MS Office upgrade.

For now, it does satisfy the current need for the Jet driver, but not the ODBC
Microsoft Access driver. Does anyone know where the docs that specify the
supported SQL language and functions are for that one?

Thanks! Your help is greatly appreciated. 

-- 
--------------------------------------------------------
The Snake Pit - Development   www.TheSnakePitDev.com
Curtis Clauson                LlelanD@TheSnakePitDev.com
Proprietor
"Any sufficiently over-complicated magic is indistinguishable from 
technology." -- Llelan D.

Relevant Pages

  • Re: SQL 2005 Profiler
    ... printer Microsoft Office Document Image Writer is unknown. ... administrator to install the driver before you log in again. ... Note that if the default trace is enabled, it is directed to the SQL Server log folder. ...
    (microsoft.public.sqlserver.security)
  • Re: TDBC documentation, examples, syntax?
    ... current SQL standards. ... for variable binding at the Tcl level. ... API, I'd probably use Oracle's bound session variables and pass ... As a convenience for driver writers, ...
    (comp.lang.tcl)
  • RE: XA transactions
    ... Which driver and version are you using and where did you locate these ... | I used the following set of instructions to enable XA transactions on our ... | SQL box: ... Create a registry named-value: ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Behavior of Connection.commit()
    ... Does it say "commit" and "rollback" and other SQL commands that affect the transaction state are not allowed? ... How sure can the driver ever be about the state of the transaction? ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: SQL 7 not using all the available physical memory?
    ... uses a "driver" model for accessing extended memory. ... device driver that worked with SQL Server on Alpha. ...
    (microsoft.public.sqlserver.server)