Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Value of DriverID

6 views
Skip to first unread message

krisrajz

unread,
Nov 16, 2003, 11:35:44 PM11/16/03
to
My application is going to use either MS-Access 2000 or MS-
Access 97 database. I'm using DSNless ODBC Driver
connection string using MDAC 2.1 version. What is the
DriverID for MS-Access 2000 and MS-Access 97. My database
is password secured. I don't want to opt for OLEDB.

Dmitri Ivanov

unread,
Nov 17, 2003, 10:50:01 AM11/17/03
to
Hello krisrajz,
"krisrajz" <anon...@discussions.microsoft.com> wrote:

k> My application is going to use either MS-Access 2000 or MS-
k> Access 97 database. I'm using DSNless ODBC Driver
k> connection string using MDAC 2.1 version. What is the
k> DriverID for MS-Access 2000 and MS-Access 97. My database
k> is password secured. I don't want to opt for OLEDB.

I welcome your decision not to opt for OLEDB despite of propaganda :-)

DriverID is of no value. All you need is SQLDriverConnect with attributes
DBQ=<database pathname> and DRIVER="Microsoft Access Driver (*.mdb)".

If you wanted to differentiate among Access 97 and 2000, you would needed a
distinct DNS for 97. For more detail, see Q244040 - "Have Your ODBC Jet 3.5
and 4.0 Applications Co-exist". BTW this approach fails on Windows 2000.
--
Sincerely,
Dmitri Ivanov
Common Lisp ODBC interface - www.ystok.ru


0 new messages