Connection string for Oracle Managed Data Provider from Microsoft.

[Jie]

Hi,
I am using Managed Data Provider from Microsoft. There is a sample codes in the help document:
Public Sub CreateOracleConnection()
Dim myConnString As String = _
"Data Source=Oracle8i;Integrated Security=yes"
Dim myConnection As New OracleConnection(myConnString)
myConnection.Open()
MessageBox.Show("ServerVersion: " + myConnection.ServerVersion _
+ ControlChars.NewLine + "DataSource: " + myConnection.DataSource)
myConnection.Close()
End Sub

I am surprised to see that Oracle also has Integrated Security. But I don't know how to set it up. Can you also tell me how to specify the Data Source? I believe it is not just Oracle8i as specified in the connection string above. Thanks.

Note: I am running Oracle 8i for Windows.


Jie

 

[Jie]

It works if I set up the connecting with the user id and password.

Dim myConnString1 As String = "Data Source=Devdata;User ID=testdb;Password=testdb;"



But I really want to know how to use Integrated Security=yes. It also indicates in the microsoft help file that uses Integrated Security=yes for improved security.



Thanks





Hi,
I am using Managed Data Provider from Microsoft. There is a sample codes in the help document:
Public Sub CreateOracleConnection()
Dim myConnString As String = _
"Data Source=Oracle8i;Integrated Security=yes"
Dim myConnection As New OracleConnection(myConnString)
myConnection.Open()
MessageBox.Show("ServerVersion: " + myConnection.ServerVersion _
+ ControlChars.NewLine + "DataSource: " + myConnection.DataSource)
myConnection.Close()
End Sub

I am surprised to see that Oracle also has Integrated Security. But I don't know how to set it up. Can you also tell me how to specify the Data Source? I believe it is not just Oracle8i as specified in the connection string above. Thanks.

Note: I am running Oracle 8i for Windows.


Jie

 

[Miha Markic [MVP C#]]

Hi Jie,

Never used integrated security with Oracle - it is an improved security in
the sense that current windows logged user is used for authentication
against oracle thus no need to use username & password.
I think you have to configure Oracle to work with integrated security.

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com
It works if I set up the connecting with the user id and password.

Dim myConnString1 As String = "Data Source=Devdata;User
ID=testdb;Password=testdb;"

But I really want to know how to use Integrated Security=yes. It also
indicates in the microsoft help file that uses Integrated Security=yes for
improved security.

Thanks


Hi,
I am using Managed Data Provider from Microsoft. There is a sample codes in
the help document:
Public Sub CreateOracleConnection()
Dim myConnString As String = _
"Data Source=Oracle8i;Integrated Security=yes"
Dim myConnection As New OracleConnection(myConnString)
myConnection.Open()
MessageBox.Show("ServerVersion: " + myConnection.ServerVersion _
+ ControlChars.NewLine + "DataSource: " + myConnection.DataSource)
myConnection.Close()
End Sub

I am surprised to see that Oracle also has Integrated Security. But I don't
know how to set it up. Can you also tell me how to specify the Data Source?
I believe it is not just Oracle8i as specified in the connection string
above. Thanks.

Note: I am running Oracle 8i for Windows.


Jie

 

[Paul Clement]

¤ Hi,
¤ I am using Managed Data Provider from Microsoft. There is a sample codes in the help document:
¤ Public Sub CreateOracleConnection()
¤ Dim myConnString As String = _
¤ "Data Source=Oracle8i;Integrated Security=yes"
¤ Dim myConnection As New OracleConnection(myConnString)
¤ myConnection.Open()
¤ MessageBox.Show("ServerVersion: " + myConnection.ServerVersion _
¤ + ControlChars.NewLine + "DataSource: " + myConnection.DataSource)
¤ myConnection.Close()
¤ End Sub
¤
¤ I am surprised to see that Oracle also has Integrated Security. But I don't know how to set it up. Can you also tell me how to specify the Data Source? I believe it is not just Oracle8i as specified in the connection string above. Thanks.
¤
¤ Note: I am running Oracle 8i for Windows.

Since this sounds like a database administrator question you may want to post to
comp.databases.oracle.server or try the Oracle MetaLink site (http://metalink.oracle.com/).


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Jie]

Thanks, Miha. This is the first time I see there is integrated security in
Oracle though I have taken the Oracle 8i database administration courses.
Does anyone ever use this feature Microsoft provides? Would you please tell
me how to configure Oracle to use integrated security? Thanks


Jie

 

[Jie]

I figured it out. Thanks for help.

Thanks, Miha. This is the first time I see there is integrated security in
Oracle though I have taken the Oracle 8i database administration courses.
Does anyone ever use this feature Microsoft provides? Would you please tell
me how to configure Oracle to use integrated security? Thanks


Jie

Hi Jie,

Never used integrated security with Oracle - it is an improved security in
the sense that current windows logged user is used for authentication
against oracle thus no need to use username & password.
I think you have to configure Oracle to work with integrated security.

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com
It works if I set up the connecting with the user id and password.

Dim myConnString1 As String = "Data Source=Devdata;User
ID=testdb;Password=testdb;"

But I really want to know how to use Integrated Security=yes. It also
indicates in the microsoft help file that uses Integrated Security=yes for
improved security.

Thanks


Hi,
I am using Managed Data Provider from Microsoft. There is a sample codes in
the help document:
Public Sub CreateOracleConnection()
Dim myConnString As String = _
"Data Source=Oracle8i;Integrated Security=yes"
Dim myConnection As New OracleConnection(myConnString)
myConnection.Open()
MessageBox.Show("ServerVersion: " + myConnection.ServerVersion _
+ ControlChars.NewLine + "DataSource: " + myConnection.DataSource)
myConnection.Close()
End Sub

I am surprised to see that Oracle also has Integrated Security. But I don't
know how to set it up. Can you also tell me how to specify the Data Source?
I believe it is not just Oracle8i as specified in the connection string
above. Thanks.

Note: I am running Oracle 8i for Windows.


Jie

 

[rajeshf]

Can you post what you did to make it work?
thanks
Raj

(e-mail address removed)