Weird SQL Connection String problem?

[Job Lot]

I am connecting to my SQL database using following connection string

Dim strSQL = "Persist Security Info=False;Integrated
Security=False;database=myDA;server=myServerNane;U ser ID=;Password="
Dim conn As New SqlConnection(strSQL)

conn.Open()
conn.Close()

The above code works fine, even if User ID and password are blank? How is it
possible?

[Chris Dunaway]

On Tue, 5 Oct 2004 06:29:03 -0700, Job Lot wrote:

I am connecting to my SQL database using following connection string

Dim strSQL = "Persist Security Info=False;Integrated
Security=False;database=myDA;server=myServerNane;U ser ID=;Password="
Dim conn As New SqlConnection(strSQL)

conn.Open()
conn.Close()

The above code works fine, even if User ID and password are blank? How is it
possible?

Perhaps it's defaulting to a trusted connection or your SQL Server is set
to allow Windows authentication?

Just a guess.

--
Chris

dunawayc[AT]sbcglobal_lunchmeat_[DOT]net

To send me an E-mail, remove the "[", "]", underscores ,lunchmeat, and
replace certain words in my E-Mail address.

[Morten Wennevik]

Hi Job,

You use the integrated Sql Security to connect (no windows authentication)
and I assume the Sql Server has a guest account enabled (anonymous). You
may be able to connect, but the guest account quite often has no database
access rights.

--
Happy Coding!
Morten Wennevik [C# MVP]

[Nick Malik]

If you don't actually perform a SQL Command in between the Open and the
Close, you would never know.

ADO will not actually attempt to acquire a connection object until you need
one. From the code you posted below, you don't need one.

Put in a command object to do something trivial. Then your connection
string will be validated.

--- Nick

"Job Lot" <Jo****@discussions.microsoft.com> wrote in message
news:A9**********************************@microsof t.com...

I am connecting to my SQL database using following connection string

Dim strSQL = "Persist Security Info=False;Integrated
Security=False;database=myDA;server=myServerNane;U ser ID=;Password="
Dim conn As New SqlConnection(strSQL)

conn.Open()
conn.Close()

The above code works fine, even if User ID and password are blank? How is it possible?

[Morten Wennevik]

Hi Job,

You use the integrated Sql Security to connect (no windows authentication)
and I assume the Sql Server has a guest account enabled (anonymous). You
may be able to connect, but the guest account quite often has no database
access rights.

--
Happy Coding!
Morten Wennevik [C# MVP]