Newsgroups: comp.lang.pascal
From: Andy@revenant.demon.co.uk (Andy Rogers)
Subject: Re: ODBC Links (MS Access)
Date: Thu, 20 Apr 1995 10:56:12 +0000

Ok after a bit of digging, ok on Compuserve <sigh>, I found the root of 
my problems, you should have the correct odbcjt16.dll !

To quote the article on Compuserve
 Read the following and then post any further questions that you might have.

 The ODBC driver provided with Access 2.0 (ODBCJT16.DLL with a file
 size of <65k) is designed to work only within the Microsoft Office
 environment. To work with ODBC/Access in Delphi, you need the
 Microsoft ODBC Desktop Driver (ODBCJT16.DLL with a file size of approx 260k)
 kit, part# 273-054-030 available from Microsoft Direct for $10.25US
 (post on WINEXT for where to get it in your country if you are not
 in the US). It is also available on the Jan. MSDN, Level 2 (Development
 Platform) CD4 \ODBC\X86 as part of the ODBC 2.1 SDK. Be aware that
 your redistribution rights for the Desktop Drivers are pretty
 restricted by Microsoft. For info on (and objections to) the
 restrictions post on the WINEXT forum.

 You also need the following ODBC files.

 Minimum:
  ODBC.DLL       03.10.1994, Version 2.00.1510
  ODBCINST.DLL   03.10.1994, Version 2.00.1510
  ODBCINST.HLP   11.08.1993
  ODBCADM.EXE    11.08.1993, Version 1.02.3129

 Better:
  ODBC.DLL       12.07.1994, Version 2.10.2401
  ODBCINST.DLL   12.07.1994, Version 2.10.2401
  ODBCINST.HLP   12.07.1994
  ODBCADM.EXE    12.07.1994, Version 2.10.2309

 The following steps will get you started in Delphi

  1. Using the ODBC Administrator, set-up a datasource for your
     database. Be sure to specify a path to your mdb file. For the
     purposes of this explanation we'll say that the datasource name
     is MYDSN.

  2. Load the BDE Configuration utility.

  3. Select New Driver.

  4. Give the driver a name (call it ODBC_MYDSN).

  5. In the driver combo box select, "Microsoft Access Driver (*.mdb)

  6. In the name combo box select MYDSN

  7. Go to the Alias page.

  8. Select New Alias.

  9. Enter MYDSN for name.

 10. For Alias Type, select ODBC_MYDSN.

 11. In Delphi, drop a DataSource, Table, and DBGrid on your form.

 12. Set DBGrid1.DataSource to DataSource1.

 13. Set DataSource1.DataSet to Table1.

 14. Set Table1.DatabaseName to MYDSN.

 15. In the TableName property in Table1, click the downarrow, you
     will see the "Login" dialog. Press OK, after a short pause you
     will see a dropdown list with all your table names. Select
     one.

 16. Set the Active property in Table1 to True, the data from your
     table will be displayed in the grid.


 Regards - Ralph -
 Herrsching, Germany @ 14-Apr-1995, 09:07:30 CEDT

Now I'm not so sure about the MSDN location, but the dll most people
seem to have is the on that came with MS Office, which will only
talk to MS Office, no use to us !

I hope this helps, when I get the dll, I'll post the outcome, though if 
anyone beats me to it, please post first.


-- Andy Rogers
--No Sig Zone--

