Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004

    Unanswered: Use MS Access to Link tables from Oracle without having an Oracle Client

    Is there a way to connect to an Oracle database using MS Access without actually installing an Oracle client? I think the Microsoft ODBC for Oracle driver (MSORCL32) needs SQL*NET , which is part of Oracle Client to configure the DSN settings.

    Im trying to find a configuration similar to TSNNAMES.ora of Oracle but i could not find it.

    Replies are appreciated. thanks
    Last edited by igel_x; 08-26-04 at 08:20. Reason: wrong spelling

  2. #2
    Join Date
    Sep 2004
    A traditional ODBC driver always need SQL*net = must install Oracle client. But I think Merant developed a driver of some kind that allows you to skip the SQL*net part. Merants drivers is to my knowledge "state of the art" drivers they are at least much better than MS's drivers. Btw Merant has changed name to DataDirect read more here.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts