Connection string problem

See more:

VB

I am trying to connect to mssql server from many days and i searched in google also many times but continuously i am failing to connect to sql server using connection string.
When i connect using ms sql server studio then it works fine but when i connect to mssql server using connection string then it fails to connect. Website where i am registerd provided me this connection string

"workstation id=chattha.mssql.somee.com;packet size=4096;user id=rizwan;pwd=censored;data source=chattha.mssql.somee.com;persist security info=False;initial catalog=chattha".

I tried these connection strings in my code

con.Open( _
        "Provider = sqloledb;" & _
        "Data Source=mssql.chattha.somee.com;" & _
        "Initial Catalog=chattha;" & _
        "User ID=rizwan;" & _
         "Password=censored;")

I also tried this connection string also

con.Open("Provider=SQLOLEDB.1;Persist Security Info=False;User ID=rizwan;Password=censored;Initial Catalog=chattha;Data Source=chattha.mssql.somee.com")

Above all i tried but any of them is not working.
I tried below code also but it also did not worked.

Dim dbconn, sql, dbcomm, dbread
            'dbconn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & Server.MapPath("AddressBook.mdb"))
            'dbconn = New OleDbConnection("Provider = sqloledb;user id=rizwan;pwd=censored;data source=chattha.mssql.somee.com;persist security info=False;initial catalog=chattha")
            dbconn = New OleDbConnection("Data Source=chattha.mssql.somee.com ;Initial Catalog='chattha';USE='rizwan';PWD='censored'")
            dbconn.Open()
        sql = "SELECT * FROM Table1"
        dbcomm = New OleDbCommand(sql, dbconn)
            dbread = dbcomm.ExecuteReader()
        Table1.DataSource = dbread
        Table1.DataBind()
        dbread.Close()
        dbconn.Close()

For experiment i added gridview and set sqlDataSource and it works fine and show records in gridview correctly. But i am failing to use connection string in code.
Note: I added this reference and working with it "Microsoft ActiveX Data Objects Library 6.1 Library.
Please help me.