Problem with connectionstring

Can anyone help with passing the connectionstring in visual studio 2008.

I am using SQL Server 2008

this is what i am doing

Imports System.Data
Imports System.Data.OleDb
Imports System.Data.SqlClient

Dim conUser As New ADODB.Connection()
Dim cmdUser As New ADODB.Command()
Dim rsUser As New ADODB.Recordset()
Dim strConnectionString As String = ""

strConnectionString = "Provider=SQLOLEDB;Data Source=tcp:s02.Winhost.com;Initial Catalog=Databasename;User ID=my_user;Password=mypassword;Integrated Security=False;"
conUser.Open()

and then i get the following error message:
"Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."

I would appreciate anyone's help

 

Try looking at this kb article.

As a test create a simple asp test script using these codes and input the correct values in them. Then upload it to our server.

http://support.Winhost.com/KB/a688/how-to-query-sql-database-with-asp-using-dsn-less-connection.aspx