Best way to connect MS Access 2007 to Oracle 8 database?

#11

On Sun, 23 Dec 2007, dlee (AT) adsi-sc (DOT) com wrote:

Quote:

On Dec 23, 9:37*am, Galen Boyer <galen_bo... (AT) yahoo (DOT) com> wrote:
On Sat, 22 Dec 2007, d... (AT) adsi-sc (DOT) com wrote:
On Dec 22, 4:08*pm, Galen Boyer <galen_bo... (AT) yahoo (DOT) com> wrote:
On Thu, 20 Dec 2007, d... (AT) adsi-sc (DOT) com wrote:
Anyone else have any thoughts?

Don't know the OLE driver, but why can't you install the oracle
client? *That really shouldn't be a factor, unless all those on
the road are in need of it as well. *Just install it and connect
MSAccess through and ODBC connection. *Should work quite nicely.

--
Galen Boyer

Thannks Galen. *Will the 9i client work ok?

Should be. *Why not install it and give it a go? *You originally
posted on Dec 19th. *Its Dec 23rd. *You could have easily figured it
all out by now. *The install should take a few moments. *Connections
should take a few moments. *In an hour, you could have figured this
out.

--
Galen Boyer

The reason I asked is I have no experience with Oracle so I do not
know if using the wrong client can damage the database. I have many
things on my plate in life so it may be several more days before I can
actually try it.

Will using the wrong Oracle client damage the Oracle database?
TD

Yes. It is very dangerous to use the Oracle client against an Oracle
database.

--
Galen Boyer

#12

Quote:

Will using the wrong Oracle client damage the Oracle database?

A server side process should reject incoming connections if there's
something wrong. Hence, the Oracle database service will reject
client connections it cannot work with or that send malformed
commands.

It should be safe to use the Oracle 9 client.

--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

#13

On Dec 26, 2:01*pm, "Martijn Tonies" <m.ton... (AT) upscene (DOT) removethis.com>
wrote:

Quote:

Will using the wrong Oracle client damage the Oracle database?

A server side process should reject incoming connections if there's
something wrong. Hence, the Oracle database service will reject
client connections it cannot work with or that send malformed
commands.

It should be safe to use the Oracle 9 client.

--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productionshttp://www.upscene.com
My thoughts:http://blog.upscene.com/martijn/
Database development questions? Check the forum!http://www.databasedevelopmentforum.com

Obviously someone didn't see the humour in Galen'scommentary.

Shame, I thought it quite amusing. <g>

David Fitzjarrell

#14

Quote:

Obviously someone didn't see the humour in Galen'scommentary.

Although I sometimes miss these things, I did find this one humorous :-)

Quote:

Shame, I thought it quite amusing. <g

I figured I should explain it in more detail to the OP.

--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Best way to connect MS Access 2007 to Oracle 8 database?

comp.databases.oracle.misc comp.databases.oracle.misc

Re: Best way to connect MS Access 2007 to Oracle 8 database? - 12-23-2007 , 11:20 AM

Re: Best way to connect MS Access 2007 to Oracle 8 database? - 12-26-2007 , 02:01 PM

Re: Best way to connect MS Access 2007 to Oracle 8 database? - 12-26-2007 , 02:34 PM

Re: Best way to connect MS Access 2007 to Oracle 8 database? - 01-02-2008 , 10:57 AM