Visual Basic.NET
Visual Basic.NET

Getting an error when trying to connect using the SqlConnection

I am getting the following error when write out this line of code.

Imports System.Data
Imports System.Data.SqlClient
 Dim conStr As String = "SERVER=LMI167\DBTEST;Database =ORKA Test; trusted_connection= yes"
        Dim objcon As New SqlConnection(conStr)

Open in new window

Reference required to assembly 'System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=969db8053d3322ac, Retargetable=Yes' containing the base class 'System.ComponentModel.Component'. Add one to your project.

cmdolcetAsked: 2019-01-24

Who is Participating?

Experts Exchange Solution brought to you by

Enjoy your complimentary solution view.

Get this solution by purchasing an Individual license! Start your 7-day free trial.

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LVL 44

ste5anSenior DeveloperCommented: 2019-01-25

Check your projects properties first:

When you need .NET 2.0 as destination target, then you need to select it there.

cmdolcetAuthor Commented: 2019-01-28

I was able to find my own solution. I was adding the reference and also trying to import the namespace It seemed like that caused the problem. I removed the reference and just kept the import of the namespace and it worked as expected.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial