provider cannot be found

  • Thread starter Thread starter tshad
  • Start date Start date
T

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
 
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_
 
First, ignore dbahooker; he's a troll.

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

Robin S.
 
stfu girl

Microsoft needs to drop the Xbox and start taking DATABASES SERIOUSLY

**** .NET and **** XML

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

ADO.net sucks balls compared to ADO classic
 
RobinS said:
First, ignore dbahooker; he's a troll.
Huh?

Second, does your SQLServer have both Windows Security and SQLServer
security enabled?
Click to expand...

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
 
tshad said:
Huh?
Click to expand...

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


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;"
Click to expand...


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
Click to expand...


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.
 
Back
Top