Connectting SQL 2005 with VB6

[Hack]

Try http://www.connectionstrings.com/

[getusama]

thanks

i've tried this

Provider=SQLNCLI;Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=yes;

but what should i put in the place of a provider..??

[getusama]

Set cn = New ADODB.Connection
    cn.ConnectionString = "Provider=SQLNCLI.1;Integrated Security=SSPI;" & _
        "Persist Security Info=False;" & _
        "AttachDBFileName= C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\bank.mdf;Data Source=KONG-DCCEC8B2B4\sql2005"

    cn.Open
        Set rs = New ADODB.Recordset
        rs.Open "Select * from orders", cn
    cn.Close

i've used te above code but it keeps giving different errors. now its telling me that i've already got that databse existing and therefore i cannot use cn.open