Provider Error with Oracle Instant Client

[aramsumair]

Hello everyone,

I am researching using the Oracle Client for the developers who write our software. I am not a developer so I have basic understanding of VB and am trying to assist with the Oracle part of our project.

Currently our software uses a full client install of Oracle 10gr2 Client. This creates registry keys for the client and a path environment variable. Our current version is designed to look for these entries.

So in testing out the 11G Instant Client I need to find out if we can have our VB6 developed software connect to Oracle using just the client files without Registry Keys or Enviroment Variables. This way we can package the Oracle client files in our installer for our software.

What I would need from you all is to find out if there is a way to specify that folder as a path in VB6 and then call the OLEDB/ODBC provider from the same folder without using the registry.

Thanks for the help.

Amith

 

[PatrickIRL]

Not sure if this is what you need, if not post back.

http://www.connectionstrings.com/oracle

Patrick

 

[mdav2]

We're just in a process of installing some new financial applications and they can use one of two methods to connect. Both of which roll up the application oracle connection into the application so there is no oracle install required on the cleint. One of these uses the easyconnect from Oracle. You'd probably be best to look at the easyconnect (ezconnect) that is in the URL that PatrickIRL pointed you to. There should be loads of other references, the one below is one from oracle.

http://download.oracle.com/docs/html/B10131_02/glossary.htm

I am not a DBA but you may need to speak to your Oracle DBA who can probably help out explaining how easyconnect works. The issue you will probably have is how to integrate this into VB5/6. This would probably fit well into VB.NET so you may have issues.

Good luck

Mark Davies
Warwickshire County Council

 

[aramsumair]

Thanks for the answers guys .. I knew about the connections strings but that link explains in better detail the usage so thanks for that. (I assist the DBA here with Oracle issues)

What i need to know is the developer side of the issue. How do they make the calls from VB6 and how will it know where the Oracle client files are?

I need working examples and some links showing how to implement this in VB6.

Basically I have to prove to them it works before they will consider looking into it.

Thanks,

Amith