User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 423,083 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,341 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums
Views: 503 | Replies: 2
Reply
Join Date: Jul 2008
Posts: 34
Reputation: pardeep3dec is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 0
pardeep3dec pardeep3dec is offline Offline
Light Poster

Visual Basic 6.0 to Oracle 8i connectivity

  #1  
Jul 15th, 2008
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
Last edited by Tekmaven : Jul 15th, 2008 at 11:41 am. Reason: Code tags
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,270
Reputation: debasisdas is on a distinguished road 
Rep Power: 4
Solved Threads: 80
debasisdas's Avatar
debasisdas debasisdas is offline Offline
Nearly a Posting Virtuoso

Re: Visual Basic 6.0 to Oracle 8i connectivity

  #2  
Jul 15th, 2008
is the connect getting successful ?
Share your Knowledge.
Reply With Quote  
Join Date: Nov 2006
Posts: 712
Reputation: QVeen72 is an unknown quantity at this point 
Rep Power: 3
Solved Threads: 97
QVeen72's Avatar
QVeen72 QVeen72 is offline Offline
Master Poster

Re: Visual Basic 6.0 to Oracle 8i connectivity

  #3  
Jul 16th, 2008
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
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb Visual Basic 4 / 5 / 6 Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Other Threads in the Visual Basic 4 / 5 / 6 Forum

All times are GMT -4. The time now is 5:43 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC