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

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





"Jie" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
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

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
"Jie" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
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


"Jie" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
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

On Mon, 8 Mar 2004 10:33:37 -0500, "Jie" <(E-Mail Removed)> wrote:

¤ 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 Removed)
Microsoft MVP (Visual Basic)

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


"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:%23OCPM%(E-Mail Removed)...
> 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
> "Jie" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> 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
>
>
> "Jie" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> 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
>
>

I figured it out. Thanks for help.

"Jie" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>
> "Miha Markic [MVP C#]" <miha at rthand com> wrote in message
> news:%23OCPM%(E-Mail Removed)...
> > 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
> > "Jie" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > 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
> >
> >
> > "Jie" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > 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
> >
> >
>
>

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

(E-Mail Removed)


Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com