Data Connection to SQL Server

  • Thread starter Thread starter TOM
  • Start date Start date
T

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


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
 
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.
Click to expand...
Provider not found can mean that you are misspelling the
source name you want to connect to.
 
Back
Top