When i am trying to connect to my SQL server using the
SQLdataadapter or the OLEDBdataadapter, VB tells me that
i can not connect to it. I can not even make a new
connection. The Error is: Provider cannot be found. May
not be installed properly.
Any Ideas?

Thanks

[quoted text, click to view]

¤ When i am trying to connect to my SQL server using the
¤ SQLdataadapter or the OLEDBdataadapter, VB tells me that
¤ i can not connect to it. I can not even make a new
¤ connection. The Error is: Provider cannot be found. May
¤ not be installed properly.
¤ Any Ideas?

You may want to post a sample of each of your connection strings.

I'll assume that MDAC is installed (which OS?) on the machine from which you are attempting to
connect.


Paul ~~~ pclement@ameritech.net

[quoted text, click to view]
w/SP2. I was think it may not be with the code since now=20
i can't connect using server explorer. Any ideas?

[quoted text, click to view]

¤
¤ >-----Original Message-----
¤ >On Tue, 11 Jan 2005 08:49:32 -0800, "TOM"
[quoted text, click to view]
¤ >
¤ >¤ When i am trying to connect to my SQL server using the
¤ >¤ SQLdataadapter or the OLEDBdataadapter, VB tells me
¤ that
¤ >¤ i can not connect to it. I can not even make a new
¤ >¤ connection. The Error is: Provider cannot be found.
¤ May
¤ >¤ not be installed properly.
¤ >¤ Any Ideas?
¤ >
¤ >You may want to post a sample of each of your connection
¤ strings.
¤ >
¤ >I'll assume that MDAC is installed (which OS?) on the
¤ machine from which you are attempting to
¤ >connect.
¤ >
¤ >
¤ >Paul ~~~ pclement@ameritech.net
¤ >Microsoft MVP (Visual Basic)
¤ >.
¤ >Yes MDAC Ver 2.8 is installed and i am working on XP
¤ w/SP2. I was think it may not be with the code since now
¤ i can't connect using server explorer. Any ideas?
¤
¤ Tom

Do you get the same error when connecting from Server Explorer?

Also, posting an example of your connection string might help rule that out.


Paul ~~~ pclement@ameritech.net