provider cannot be found

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tshad - 18 Apr 2007 02:47 GMT

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

Reply to this Message

dbahooker@hotmail.com - 18 Apr 2007 02:54 GMT

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_

> 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
[quoted text clipped - 6 lines]
>
> Tom

Reply to this Message

RobinS - 18 Apr 2007 07:46 GMT

First, ignore dbahooker; he's a troll.

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

Robin S.
---------------------

>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
[quoted text clipped - 6 lines]
>
> Tom

Reply to this Message

dbahooker@hotmail.com - 18 Apr 2007 22:16 GMT

stfu girl

Microsoft needs to drop the Xbox and start taking DATABASES SERIOUSLY

f.ck .NET and f.ck XML

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

ADO.net sucks balls compared to ADO classic

> First, ignore dbahooker; he's a troll.
>
[quoted text clipped - 15 lines]
>
> - Show quoted text -

Reply to this Message

tshad - 24 Apr 2007 02:26 GMT

> 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.
> ---------------------
[quoted text clipped - 8 lines]
>>
>> Tom

Reply to this Message

RobinS - 24 Apr 2007 08:12 GMT

>> 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?
[quoted text clipped - 8 lines]
> "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"
[quoted text clipped - 9 lines]
>
> 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.

Reply to this Message

provider cannot be found

Free Magazines