VB.Net Connecting to a SQL Server Database

[ftpdoo]

Hi..

I've just installed VB.Net and SQL Server.. I've got the microsoft sample database Northwind and have added it to SQL Server.

To connect to this database do I still need to setup an ODBC connection? Or can I go direct?

I keep getting the error "test connection failed because of an error in initialzing provider"

Any ideas what I'm doing wrong?

Sorry if this is really basic.. Just struggling to get this up and going.

Thanks,
Jonny

 

[gmmastros]

Take a look here:

http://www.connectionstrings.com/

It show the best connection string to use. You should go direct. ODBC is just another (unnecessary) layer between vb and the database.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom