Linking Oracle tables (Any)

Topic

New Reply

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 ??

Reply | Quote

Replies

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.

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

Does that mean they will still be supporting Jet / ODBC, and that bugs will be fixed ?

Reply | Quote

Bugs? What bugs?

I suppose it means that, like DAO, it’s there but it won’t be updated any more.

Reply | Quote