Conecting to Oracle vi ADO in VB6

[WildWill]

Could some one pleas help.

I am having problems connect to an Oracle8 via ADO in VB6. It works OK on any development machine but when I try to role out the app' it fails to connect.

I have configured and tested the connection vi Oracles easy config. Thats OK

I have tried Via ODBC from Access that Is OK.

But I still cannot get by VBA to work.

Is there anything extra I need to distribute with my App'

For reference the concoction string I am using is:

    With cmdOracle
        .ActiveConnection = "Provider=MSDAORA.1;Password=WMSVIEW;User ID=WMSVIEW;Data Source=WEAR;Persist Security Info=false"
        .CommandText = strSumRS
        Set rs = .Execute
    End With

Billy H

bhogar@acxiom.co.uk

 

[woyler]

What is the error?

 

[WildWill]

it is:

'-2147467259(800004005)'
Oracle error occured, but error message could not be rerieved from Oracle

x-) Billy H

bhogar@acxiom.co.uk

 

[woyler]

You have tested the same driver(version numbers match) on both the Oracle client software and through ACCESS?

 

[WildWill]

The Access Connection was acomplished via ODBC, but the VB is trying to use ADO (Microsoft OLE DB Provider for Oracle).

Both these should connect using the setting from Oracles Net8 easy Config Billy H

bhogar@acxiom.co.uk

 

[woyler]

Try dropping the .1 from the provider in your connection string. Just use:
.ActiveConnection ="Provider=MSDAORA;Password=WMSVIEW;User ID=WMSVIEW;Data Source=WEAR;Persist Security Info=false"