VB Oracle Connectivity

[pardeep3dec]

Hi friends,
I know process of connectivity to oracle but i have a problem whenever i restart my computer it shows ORACLE NOT AVAILABLE .

How can i avoid this disconnection error.

Please help me.

[dspnhn]

PLease be clear.............you say restart your comp ???? it implies you have some issues regarding oracle installation......if not then simply create a module and call it in form_load
the module should establish the connectivity through use of code.

[QVeen72]

Hi,

When you re-start the computer, It takes, some time for Oracle Services to start.. So You have to wait for few minutes after Windows have started..
Also check all the Oracle Services have configured as "Automatic Start"..

Regards
Veena

[aktharshaik]

There is some issue i faced when installing Oracle 8i on Windows XP. All the oracle services are not started automatically. I used to take an alternate route to UP the database.

Try this

Go to command prompt. and type the foll commands

-------------------------------------------------------

C:\>svrmgrl [enter]
'Rem: u will the svrmgr prompt then type CONNECT INTERNAL/ORACLE and hit enter
svrmgr> CONNECT INTERNAL/ORACLE
Connected.

'After getting the connected message type STARTUP and hit enter
'you get few messages and the database mounted message at end.
'once this is done exit the svrmgr.
svrmgr> STARTUP
..
..
..
Database Mounted.

svrmgr>exit
C:\>

-------------------------------------------------------

Now try running ur project.

U may even try to get another version of the Oracle and try it out.

Regards
Shaik Akthar

[aktharshaik]

check out the documents attached

Regards
Shaik Akthar