Connection String

[chamilz]

I am very new to vb.net (2005). I developed a small application which retrives data from the SQL table and used the following connection string. my application works for user who have admin rights to access SQL server.

Conn = New SqlClient.SqlConnection("Data Source=CA-TNET01;Initial Catalog=Transnet;Integrated Security=True”)

But others who don’t have admin right can not run the application. So that I used the following connection string but it gives me an error “Keyword not supported: 'provider'.”

Conn = New SqlClient.SqlConnection("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=CA-TNET01")

Your reccomendation greatly appriciated.

 

[earthandfire]

These should help:

http://www.connectionstrings.com/

http://www.carlprothman.net/Default.aspx?tabid=86#SQLClientManagedProvider