Referencing

[Phreak]

How do I get VB.NET to know that this is defined:

Dim sqlConn As SqlConnection = New SqlConnection("server=" & ServIP & _
";uid=" & UID & ";pwd=" & Pass & ";database=" & DBName)

So I dont have to type things like this out:

Dim sqlConn As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection("server=" & ServIP & _
";uid=" & UID & ";pwd=" & Pass & ";database=" & DBName)

Because it keeps underlining "SqlConnection" and saying that it isnt defined. I have System.Data in my references. What else do I have to do?

 

[Anis]

Try out
Imports System.Data.SqlClient

 

[Anis]

Or check this link http://www.able-consulting.com./ADO_Conn.htm#OLEDBManagedProvider

 

[Phreak]

Where would I put that in the code?

Thanks for the reply btw.

 

[Anis]

At the top. Have you seen the link i have posted in above post?

 

[Phreak]

Yep... just figured it out! Thanks a ton!