gelorup
asked on
Oracle and ADO and Newbie
I have been speculatively asked to write a frontend that will access a mega-large Oracle database. At first it will be read only and a small table may/will be split off for local use, but I think a dial-up connection will eventually be required. I want to use VB5 and ADO. My question/s are;
1.Where can I get a small Oracle db to use locally for testing to come up to speed.
2. Do I have to own a copy of Oracle?
2. Is it difficult to use ?, I am very familiar with Access/VB5 and some ADO etc ?
3. Any good sources of information of how to do this
1.Where can I get a small Oracle db to use locally for testing to come up to speed.
2. Do I have to own a copy of Oracle?
2. Is it difficult to use ?, I am very familiar with Access/VB5 and some ADO etc ?
3. Any good sources of information of how to do this
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry to say, but you can't treat Oracle like you would Access.
You are right, Oracle is expensive and can be difficult to administrate and tune. I have not used the NT product as yet, perhaps it is a little more friendly.
To get a feel ADO programming, you can use Access as an ADO/ODBC provider. It is terribly inefficient, but it gives you the concepts without the expense...
You are right, Oracle is expensive and can be difficult to administrate and tune. I have not used the NT product as yet, perhaps it is a little more friendly.
To get a feel ADO programming, you can use Access as an ADO/ODBC provider. It is terribly inefficient, but it gives you the concepts without the expense...
ASKER