Do you have a SAMPLE ORACLE DB?

[christywarner]

Hi,

One of my clients would like to modify my Access
software to link to his Oracle db. I have found
some useful code to link to the db, but have no
db to practice on. Does anyone have a sample
Oracle db that they could email me so I could
practice my connection?

Thanks,
Christy.

 

[Tranman]

Christy,
If your customer has an instance of Oracle running, you can try to connect to the test data (if they installed it), by using UID=Scott and PWD = tiger. There are some tables associated with this user (EMP and SALES are two of them).

This is junk practice data, and you should be able to do about anything you want with it, including connecting through Access, without hurting anything. If the test data is not installed, the customer's DBA's should be able to install it without much trouble in order to give you something to play with.

The first thing I'd try to do is to connect to the test data with SQL*PLUS.

Unfortunately, Oracle is not like Access. You can't just copy an Oracle file out to a hard drive and connect to it. You need SQL*NET running on the server, Oracle Client running on your workstation, an ODBC Driver and/or the oleDB layer; etc.

Connecting Access to Oracle is a pretty simple proposition, but you have to have all of the Oracle pieces in place before you can do it. If you get everything in place, and still need some help getting hooked up, just respond to this thread and I'll give you any pointers you may need.

Good luck,
Tranman

 

[mikeyb540]

Or if you really have time on your hands, you can download the Oracle Server and install it on your Windows NT 4 or 5 Server PC.

http://otn.oracle.com/software/products/8i_personal/content.html

 

[mikeyb540]

Oops ... previous thread's link prompts you for an Oracle log in.

Try this one instead

http://otn.oracle.com/software/content.html