provider cannot be found

[tshad]

I am trying to connect to my Sql Server 2000 database from my VS 2003
program and get the "provider cannot be found" when I try to connect to the
database. It sees the Server fine but when I tell it to connect using the
Windows NT Integrated Security it gives me the message.

What would cause that?

Thanks,

Tom

[dbahooker]

uh probably the fact that NT (integrated) security for SQL Server is
'too buggy for real world use'

and MS is too busy making bloatware to fix real problems in SQL Server
authentication

M$ needs to stop playing Xbox and start taking databases seriously
_SERIOUSLY_

On Apr 17, 6:47 pm, "tshad" <[e-mail]:

I am trying to connect to my Sql Server 2000 database from my VS 2003
program and get the "provider cannot be found" when I try to connect to the
database. It sees the Server fine but when I tell it to connect using the
Windows NT Integrated Security it gives me the message.

What would cause that?

Thanks,

Tom

[RobinS]

First, ignore dbahooker; he's a troll.

Second, does your SQLServer have both Windows Security and SQLServer
security enabled?

Robin S.
---------------------
"tshad" <[e-mail] in message
news:%2******************@TK2MSFTNGP02.phx.gbl...

>I am trying to connect to my Sql Server 2000 database from my VS 2003
program and get the "provider cannot be found" when I try to connect to
the database. It sees the Server fine but when I tell it to connect using
the Windows NT Integrated Security it gives me the message.

What would cause that?

Thanks,

Tom

[dbahooker]

stfu girl

Microsoft needs to drop the Xbox and start taking DATABASES SERIOUSLY

fuck .NET and fuck XML

Microsoft needs to put a lot more effort into the database world.

ADO.net sucks balls compared to ADO classic

On Apr 17, 11:46 pm, "RobinS" <[e-mail]:

First, ignore dbahooker; he's a troll.

Second, does your SQLServer have both Windows Security and SQLServer
security enabled?

Robin S.
---------------------"tshad" <[e-mail] in message

news:%2******************@TK2MSFTNGP02.phx.gbl...

I am trying to connect to my Sql Server 2000 database from my VS 2003
program and get the "provider cannot be found" when I try to connect to
the database. It sees the Server fine but when I tell it to connect using
the Windows NT Integrated Security it gives me the message.

What would cause that?

Thanks,

Tom- Hide quoted text -

- Show quoted text -

[tshad]

"RobinS" <Ro****@NoSpam.yah.nonewrote in message
news:ZP******************************@comcast.com. ..

First, ignore dbahooker; he's a troll.

Huh?

Second, does your SQLServer have both Windows Security and SQLServer
security enabled?

Yes, I do. And my websites and applications have no problem. Here is a
piece of code using VS 2003 that works fine:

Dim sTemp As String
Dim iTemp As Integer
Dim dbReader As SqlDataReader
Dim ConnectionString As String = _
"Persist Security Info=False;Data Source=Server;Initial Catalog=ft;User
ID=xxx;Password=yyyy;"
Dim objConn As New SqlConnection(ConnectionString)
Dim CommandText As String = "AddEmployees"
Dim objCmd As New SqlCommand(CommandText, objConn)
objCmd.CommandType = CommandType.StoredProcedure
objConn.Open()

Not sure what it means when it says provider cannot be found. The Server
Explorer Pane shows the Server, the Services that are running and the Sql
Server but shows it with a red X.

Thanks,

Tom

>
Robin S.
---------------------
"tshad" <[e-mail] in message
news:%2******************@TK2MSFTNGP02.phx.gbl...

>>I am trying to connect to my Sql Server 2000 database from my VS 2003
program and get the "provider cannot be found" when I try to connect to
the database. It sees the Server fine but when I tell it to connect using
the Windows NT Integrated Security it gives me the message.

What would cause that?

Thanks,

Tom

[RobinS]

"tshad" <[e-mail] in message
news:OP****************@TK2MSFTNGP02.phx.gbl...

"RobinS" <Ro****@NoSpam.yah.nonewrote in message
news:ZP******************************@comcast.com. ..

>First, ignore dbahooker; he's a troll.

Huh?

dbahooker responded to your post. He has a bunch of aliases (susiedba,
todos menos, larry linson (jr), aaron kempf, to start with), and is a known
troll in this group.

http://en.wikipedia.org/wiki/Internet_troll

>Second, does your SQLServer have both Windows Security and SQLServer
security enabled?

Yes, I do. And my websites and applications have no problem. Here is a
piece of code using VS 2003 that works fine:

Dim sTemp As String
Dim iTemp As Integer
Dim dbReader As SqlDataReader
Dim ConnectionString As String = _
"Persist Security Info=False;Data Source=Server;Initial Catalog=ft;User
ID=xxx;Password=yyyy;"

If you are using Windows Integrated security, this should look more like
this:

Data Source=sqlservername;Initial Catalog=ft;Integrated Security=True

The connection string you are using is for SQLServer security. Maybe that's
the problem.

Dim objConn As New SqlConnection(ConnectionString)
Dim CommandText As String = "AddEmployees"
Dim objCmd As New SqlCommand(CommandText, objConn)
objCmd.CommandType = CommandType.StoredProcedure
objConn.Open()

Not sure what it means when it says provider cannot be found. The Server
Explorer Pane shows the Server, the Services that are running and the Sql
Server but shows it with a red X.

Thanks,

Tom

I used to get "provider cannot be found" when I was running against Access,
and I didn't have the MDAC components installed. I'm assuming you are
including references to the appropriate .Net components, System.Data, and
maybe System.Data.SqlClient?

Robin S.