• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 149
  • Last Modified:

Need code for connect a Oracle Database

Hi, i am newbi visual basic user. need to connect a oracle database. can some one give me some code, and comments.
thanks you
0
dorosman
Asked:
dorosman
1 Solution
 
JayMerrittCommented:
Lookup HELP for "RDO" - this assumes you already have ODBC connectivity.
0
 
oak022097Commented:
what exactly you want to do? I can send u few lines of codes which might help you
0
 
dorosmanAuthor Commented:
oak,
I try to connect to a ORacle Db, call some function pass some parameters(about 3), and expect a value back. The function was wrote in ORacle.
Thank you.
0
 
seahpcCommented:
Try this

Public m_rdoConn As rdoConnection
Public m_rdoErr As rdoError
Public m_rdoResult As rdoResultset
Public m_rdoEnv As rdoEnvironment
Public m_rdoCol As rdoColumn

Set m_rdoEnv = rdoEnvironments(0)
m_rdoEnv.CursorDriver = rdUseOdbc
Set m_rdoConn = m_rdoEnv.OpenConnection(dsname:="", _
                prompt:=rdDriverComplete, _
                ReadOnly:=False, _
                Connect:="uid=sa;pwd=zaq12wsx;driver={SQL Server};" _
                & "server=Wellington;database=Auction;")
End Sub
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now