Access and Oracle DB

[Guest]

Hello!

I working with Access 2003 and have 'played' a bit with SQL Server 2005
Express and now I'm looking to getting 'familiar' with connecting to an
Oracle DB and working with it. I'm looking at the Oracle 10g Express
Edition... Will this work or should I look at a different Oracle DB? Also,
are there problems forseened that I should be aware of??

 

[Arvin Meyer [MVP]]

Oracle 10g Express is a free download from Oracle. What you will also need
is either an OLEDB driver to work with ADO, or an ODBC driver. Try this
shortcut to the Oracle forums:

http://forums.oracle.com/forums/thread.jspa?messageID=1447409

 

[Guest]

Hello!

Thanks for the info...! Also, will I need something like the SQL Server
Management Studio Express with SQL Server 2005 Express for this Oracle DB??

--
Thanks!
Soddy

Oracle 10g Express is a free download from Oracle. What you will also need
is either an OLEDB driver to work with ADO, or an ODBC driver. Try this
shortcut to the Oracle forums:

http://forums.oracle.com/forums/thread.jspa?messageID=1447409

 

[Arvin Meyer [MVP]]

No, SQL-Server cannot be used with Oracle, except with Access mdb's (ODBC
usually) and the Access Jet engine. With Access, you can usually connect to
SQL-Server without any additional drivers (most of them are built in to the
install) SQL-Server 2005 Express, however may need a driver, since it wasn't
out yet when the latest version of Access was brought out. I use the full
version of SQL-Server 2005 and the driver is there
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Hello!

Thanks for the info...! Also, will I need something like the SQL Server
Management Studio Express with SQL Server 2005 Express for this Oracle
DB??