Solved

connection

Posted on 2002-05-30
10
138 Views
Last Modified: 2010-05-02
How i can get connected with VB and ORACLE database
0
Comment
Question by:shaibu_aug
10 Comments
 
LVL 18

Expert Comment

by:bobbit31
Comment Utility
0
 
LVL 1

Expert Comment

by:pit__
Comment Utility
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
 

Expert Comment

by:laws
Comment Utility
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
 
LVL 18

Expert Comment

by:bobbit31
Comment Utility
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
 

Expert Comment

by:laws
Comment Utility
Bobbit31,
   Thanks,I see.
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 1

Expert Comment

by:nikelsh
Comment Utility
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
 
LVL 1

Expert Comment

by:Moondancer
Comment Utility
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
 
LVL 1

Expert Comment

by:kodiakbear
Comment Utility
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
 
LVL 16

Expert Comment

by:twalgrave
Comment Utility
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
 

Accepted Solution

by:
SpideyMod earned 0 total points
Comment Utility
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now