ORACLE - VB Application Installation 1

[subhavs]

Hey ...

I am writing a VB application that reads data from an ORACLE database. This will be deployed on machines that do not have ORACLE or VB.

I am using a DSN-less connection. I am told that I cannot accomplish this unless SQL*Net is installed on every client. Is this true ?

Is there any other way around ?

Any suggestions will be appreciated.

Thanks,

- Subha

 

[culshaja]

That is coorect. To access an Oracle databse you do need SQL*Net installed on every client machine that is going to use it. You also need to Configure it with the correctdatabase connections. Unfortunately there is no way round this.
As and aside, if you are developing for Oracle it is much better to use OO4O than ADO as it is more robust, faster, and offers greater functionality.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[Ropje]

James, what is 0040??

 

[culshaja]

OO4O is Oracle Objects For OLE. Its like ADO but has been around longer and is created purely for working with Oracle. It can be installed as part of the Oracle Client software install and is documented in the Oracle documentation that is installed as part of that.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305