connection

How i can get connected with VB and ORACLE database
shaibu_augAsked:
Who is Participating?
 
SpideyModCommented:
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0
 
bobbit31Commented:
0
 
pit__Commented:
The easiest way would be to just make a DSN to point to the Oracle database.  i.e. In the Data Sources under the Control Panel, make a DSN using 'Oracle ODBC Driver' (which comes with Oracle Client 7.2 and higher I believe).  Then in VB, simply set the ConnectionString property of an ADODB.Connection object to the DSN...

i.e.

Dim ADOConn As ADODB.Connection
Dim ADORS As ADODB.Recordset

ADOConn.ConnectionString="DSN=MyOracleDSN;UID=user;PW=pass"
Set ADORS = ADOConn.Execute("SELECT ......
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
lawsCommented:
The first,You may make a System DSN to link the Oracle database in ODBC DATA SOURCE from WINDOWS CONTROL-PANEL.Then:

Dim ADOConn As ADODB.Connection
dim rs As ADODB.Recordset
ADOConn.open "Your DSN's name"
rs.open Sqlstring,ADOConn,.......

0
 
bobbit31Commented:
laws,

welcome to ee... please see the recommended policy on posting solutions (most experts here only post comments).
Once proposing an answer you lock the question out for other experts to view. In addition, your comment is very similar to pits.

Tips on Comments and Answers
Comments
Comments are intended to be used as a collaboration tool. Many Experts choose to post their solutions as comments only.

Answers
An answer is a specific solution to a question and should be submitted if it will solve the questioner's problem and doesn't duplicate a previous comment.

Comment Vs. Answer
If you are unsure of your solution, post it as a comment. Members can accept comments as solutions and award you Expert Points for them.

 
0
 
lawsCommented:
Bobbit31,
   Thanks,I see.
0
 
nikelshCommented:
use this

set objConn=createobject("adodb.connection")
   objConn.Open ="Provider=OraOLEDB.Oracle;" & _
             "Data Source=rnd;" & _
          "User Id=ndsnl;" & _
                "Password=ndsnl;" & _
          "SERVER=nt_niklesh;"
   
set objrs=createobject("adodb.recordset")

this connection string is my existing prog string just change with our DataSource,userid,passowrd,server.

nikelsh
0
 
MoondancerCommented:
Greetings.

This question has been locked with a Proposed Answer, and remains open today.

If the Proposed Answer did not serve your needs, please reject it and comment with an update.  If the Proposed Answer helped you, please accept it to grade and close this question.  If you need help splitting points between multiple experts, please comment here with details so we can help you.

EXPERTS ->  Please guide me here in terms of closing recommendations if the Asker does not respond in 4 days.

Thanks to all,
Moondancer - EE Moderator
0
 
kodiakbearCommented:
Dear laws
I've rejected your proposed answer as Experts Exchange holds an experiment to work without the answer button.

See: <http://www.experts-exchange.com/jsp/communityNews.jsp>
Paragraph: Site Update for Wednesday, November 06, 2002

By this rejection the Asker will be notified by mail and hopefully he will take his responsibility to finalize the question or post an additional comment.
The Asker sees a button beside every post which says "Accept This Comment As Answer" (including rejected answers) -- so if he/she thinks yours is the best, you'll be awarded the points and the grade.

EXPERTS: I will return in seven days to close this question.
Please leave your thoughts and recommendations here

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Thanks !

kodiakbear
Experts Exchange Moderator
0
 
twalgraveCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
- PAQ'd and points NOT refunded
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

twalgrave
Cleanup Volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.