I have downloaded the rsdbcontrol and tested it with the access2000 database. But not clear as to how to connect to oracle using this. The code gives some examples like Access, mysql etc. But oracle is not given. Please help.
Guest,
For Oracle use the type that matches the driver you have installed. If you have an OLEDB or ODBC driver installed use the appropiate connection.
Most Oracle users have ODBC connections, but a DSN less (OLEDB) connection would fare better if available.
This was in the wrong section so it was moved.
BTW: Oracle is listed oin the documentation
I have created nested views three levels deep in Oracle 8i. The performance of the query on the top view is very poor. How do I get a better perfromance?
htimmerman,
Please elaborate, I imagine you are using the RSdbControl dll? How are you connected to Oracle? Where is the server located? What kind of connection are you using? Is the connection accross the internet? Etc, Etc...
I am using sql plus. The datbase server is located in our head office. We have a dedicated line SDSL 1024/1024 Kb 1:2
What is the code you are using for this?
I don't understand the word code in this connection. Sorry, I'am a starter at Oracle.
So, is your question about Oracle or the RSdbControl? If it is using the control, post some code used to accomplish this task.
I solved the problem by making two indexes on basic tables. Thanks for the answers.
Ok, great.