error occurred while trying to connect oracle through VB? click for more?

Question

hi!
i got error msg while i try to connet oracle which is running on the other system in the same network(LAN). i configured TNSServer and created the DSN.

i got error msg like..
error -2147467259(80004005)
oracle error occurred but the error msg is not retrived from the oracle.

i need to retrive data from the server through my vb application. it's a clent server application.

is there any other way to connect the oracle in server from our client vb application.
thanks

Answer 1

Oracle connectivity through ADODC
We are having Emp_mast table in our oracle database for storing Employee
master details records. Following exercise is to connect this table with our Form.
ADODC control
Step I – Design the form like the given image.
Step II – You will not get ADODC control in your Toolbox.
To add this control > Click on “Project” option from MenuBar > Select
“Components” > Select “Microsoft ADO Data control 6.0 (OLEDB) > Ok. {Now
one control will add in your Toolbox}
Step III – Take ADODC control on your Form.
Step IV – Set following properties of ADODC control
Connectionstring = General > User connection string > Build > Enter a server
name “NIAOIC” > Username & Password > Click on Test Connection > Ok
Recordsource = CommandType “2- adCmdTable” > Table or Stored Procedure
Name “EMP_MAST” >Ok

Answer 2

i'm afraid i will't answer your question, yet I actually have the very similar situation! My cam used to artwork surely high quality, now immediately that's declaring "waiting to reconnect" and then "A community blunders got here about even as attempting to attach with the server"... If i'm getting an answer to my question, i will inform you instantly! it really is a bloody nuisance.