How to connect to oracle using OdbcConnection

[sjh]

Hi,
I am using OdbcConnection to connect to a oracle database. cboODBC is a dropdown list that contains the DSNs. If the selected value is an Oracle DB, do I need to prompt the user for userid and password to connect to the database? Or is this done automatically by the system?

Thank you! - Susie

Dim myConn As New OdbcConnection
myConn.ConnectionString = "DSN=" & cboODBC.Text & ""
Try
myConn.Open()
Catch ex As Exception
MsgBox(ex.Message)
End Try

 

[bduke]

Are you using a dataAdapter to do this connection.. if not you would have to supply the UserId,Password, and you might even have to supply the server name... If you give me more information I might be able to help more...