Data Connection to SQL Server

[TOM]

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
Tom

[Philip Korolev]

can you send the code you are using to get to it. Provider not found can mean that you are misspelling the source name you want to connect to.
"TOM" <tb***@yahoo.com> wrote in message news:1a****************************@phx.gbl...
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
Tom

[Morten Wennevik]

Hi Tom,

Ensure your connection string is correct. This page is a good resource in
that area:

http://www.connectionstrings.com
--
Happy Coding!
Morten Wennevik [C# MVP]

[TOM]

imports system.data.odbc
dim oODBCConnection as OdbcConnection
dim sConnString as String= _
"driver={SQL Server}; & _
"server=server;" & _
database=Northwind;" & _
"Uid=myusername;" & _
"Pwd=mypassword"

oODBCConnection = New Odbc.OdbcConnection(sConnString)
oODBCConnection.Open()

I think it might be something else then the code because
i can not connect to the server in the server explore view

Tom

-----Original Message-----
can you send the code you are using to get to it. Provider not found can mean that you are misspelling the
source name you want to connect to.

"TOM" <tb***@yahoo.com> wrote in message news:1a****************************@phx.gbl... 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
Tom