OraFAQ Forum: Windows » VB code to connect to oracle unix

Home » Infrastructure » Windows » VB code to connect to oracle unix

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

VB code to connect to oracle unix [message #99712]

Wed, 27 February 2002 13:22

d
Messages: 18
Registered: October 2000

Junior Member

Hi:

I am trying to connect to oracle unix via excel. Assuming I have all of my ODBC drivers etc. set up, does anybody have a vb code snippet I can use that will make the connection?

Thanks,

Derek

Report message to a moderator

Re: VB code to connect to oracle unix [message #99740 is a reply to message #99712]

Tue, 12 March 2002 23:42

WH
Messages: 3
Registered: March 2002

Junior Member

Here you go. Hope you find it useful!

Dim conn As Connection
Dim rs As Recordset
Dim strConn As String

Set conn = New Connection
Set rs = New Recordset

strConn = "DSN=dsn;Uid=xxxxx;Pwd=xxxxxxxx;"

conn.Open connStrg

If conn Is Nothing Then Exit Sub

Report message to a moderator