Improve company productivity with a Business Account.Sign Up

x
?
Solved

How to connect oracle in vb6.0?

Posted on 2004-03-23
5
Medium Priority
?
3,066 Views
Last Modified: 2010-05-18
Would anyone tell me how can i connect to the oracle in VB6.0?
Thanks
0
Comment
Question by:MicLam
  • 2
3 Comments
 
LVL 53

Accepted Solution

by:
Dhaest earned 600 total points
ID: 10656665
See http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForOracleFromOracle for more information.

OLE DB Provider for Oracle (from Microsoft)
oConn.Open "Provider=msdaora;" & _
           "Data Source=MyOracleDB;" & _
           "User Id=myUsername;" & _
           "Password=myPassword"
For more information, see: Microsoft OLE DB Provider for Oracle
(http://msdn.microsoft.com/library/en-us/ado270/htm/pg_ado_providers_7.asp)
To view Microsoft KB articles related to OLE DB Provider for Oracle, click here
(http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=mdac&Query=msdaora&Queryc=msdaora&REF=false&srchstep=0&KeywordType=PHRASE&Titles=false&numDays=&maxResults=100)


OLE DB Provider for Oracle (from Oracle)
For Standard Security

oConn.Open "Provider=OraOLEDB.Oracle;" & _
           "Data Source=MyOracleDB;" & _
           "User Id=myUsername;" & _
           "Password=myPassword"

For a Trusted Connection

oConn.Open "Provider=OraOLEDB.Oracle;" & _
           "Data Source=MyOracleDB;" & _
           "User Id=/;" & _
           "Password="
' Or
oConn.Open "Provider=OraOLEDB.Oracle;" & _
           "Data Source=MyOracleDB;" & _
           "OSAuthent=1"
Note: "Data Source=" must be set to the appropriate Net8 name which is known to the naming method in use. For example, for Local Naming, it is the alias in the tnsnames.ora file; for Oracle Names, it is the Net8 Service Name.

For more information, see: Oracle Provider for OLE DB Developer's Guide
(http://download-west.oracle.com/docs/cd/B10501_01/win.920/a95498/using.htm#1004833)
0
 

Author Comment

by:MicLam
ID: 10673535
Thanks Dhaest

But do u have any sample vb program should be provided for me as reference?

0

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

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.

Join & Write a Comment

What do responsible coders do? They don't take detrimental shortcuts. They do take reasonable security precautions, create important automation, implement sufficient logging, fix things they break, and care about users.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Progress
Screencast - Getting to Know the Pipeline

584 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