Access and Oracle DB

  • Thread starter Thread starter Guest
  • Start date Start date
G

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


Soddy said:
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??
Click to expand...
 
Back
Top