Member Avatar for pardeep3dec

Hello friends,
I need procedure for continous accessing oracle database using visual basic.
Follwing i am giving coding use by me but some time it give disconnection error

Please help for continous connectivity.

dim db as new ADODB.connection
dim rs as new ADODB.recordset

db.open "Provider=MSDAORA.1;User id=ourpro;Password=ourpro1;Persist Security info=False"

Pardeep

  • 3 Contributors
  • 2 Replies
  • 134 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by QVeen72
Member Avatar for debasisdas

is the connect getting successful ?

Member Avatar for QVeen72

Hi,

You have to give "Server" name also..
whatever service name you have given in Net Configuration :

db.open "Provider=MSDAORA.1;User id=ourpro;Password=ourpro1;Persist Security info=False; Server=MyServName"

Regards
Veena

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.