Home » Infrastructure » Windows » VB code to connect to oracle unix
VB code to connect to oracle unix [message #99712] Wed, 27 February 2002 13:22 Go to next message
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
Re: VB code to connect to oracle unix [message #99740 is a reply to message #99712] Tue, 12 March 2002 23:42 Go to previous messageGo to next message
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
Re: VB code to connect to oracle unix [message #99963 is a reply to message #99712] Fri, 31 May 2002 00:04 Go to previous messageGo to next message
Vinod
Messages: 76
Registered: April 1999
Member
can u help me to connect vb to oracleunix
vinod yadav
Re: VB code to connect to oracle unix [message #100195 is a reply to message #99712] Mon, 02 September 2002 03:30 Go to previous message
eko_purwoko
Messages: 1
Registered: September 2002
Junior Member
it's very sample. i need very detail
Previous Topic: Fatal error - Oracle Migration Assistant for MS Access
Next Topic: Oracle 9i Installer Failure/Problem
Goto Forum:
  


Current Time: Thu Mar 28 05:51:08 CDT 2024