Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, UK, Berkshire, England
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linking Oracle tables (Any)

    I was reading the latest Smart Access and there was a comment that Jet and ODBC are basically old tech as far as Microsoft were concerned, i.e. no more development, and the future was likely to be (especially with Access XP) Project linked to SQL Server/MSDE using ADO
    But this is limited to SQL Server/MSDE, what about e.g. Oracle ??
    Is it possible to link Oracle tables via ADO, rather than ODBC ??

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Linking Oracle tables (Any)

    Hi Steve,
    You can't, as far as I'm aware (and I would love to know different!) link Oracle tables using ADO, but you can certainly connect to them using ADO and OLE DB, either via the MS Oracle OLEDB provider or via Oracle's own provider. As with ODBC you need to have SQL*Net or Net8 (not sure if there's a different one for Oracle 9) installed on the relevant machine.
    ADO and OLEDB is certainly, in my experience, faster than ODBC and is the way to go if you don't need to use local Access tables. You do need to write all your SQL in syntax that Oracle understands rather than Access, but it's reasonably straightforward. I also use this method quite a lot from Excel.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Linking Oracle tables (Any)

    I would add to Rory's comment that the Microsoft party line is that Jet and ODBC will go away. But in point of fact they are very much alive and well in Access XP, and I very much expect that they will be in the next generation too. There is too much legacy stuff (that works pretty well, thank you) for it to be abandoned completely. And there are still some things that are either very awkward or impossible with ADO that are a breeze using DAO. Access XP does has ADO capabilities that are significantly better than Access 2000. I haven't had any experience with the MSDE (it has a new name and is based on SQL Server 2000), but in 2000 the Jet engine gave better performance in a 5 to 10 user environment. Is Jet going way? Yes, but slowly.
    Wendell

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Linking Oracle tables (Any)

    Actually, neither Jet nor ODBC is going away. What Microsoft has said is that, like DAO, they won't be developed any further.
    Charlotte

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, UK, Berkshire, England
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking Oracle tables (Any)

    Does that mean they will still be supporting Jet / ODBC, and that bugs will be fixed ? <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Linking Oracle tables (Any)

    Bugs? What bugs? <img src=/S/innocent.gif border=0 alt=innocent width=20 height=20>

    I suppose it means that, like DAO, it's there but it won't be updated any more. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

Posting Permissions

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