vb 6 connection problem with sql 2005

[coolminded]

dear all,
i used to connect vb6 with sql server 2000, it worked great.now i just connected vb6 with sqlserver 2005, but it generates the error.

object variable or With block variable not set.

i use the connection string

conn.Open "Provider=SQLNCLI.1;Integrated Security=SSPI;Password=pwd ;Persist Security Info=True;User ID=administrator;Initial Catalog=dtbs;Data Source=192.168.1.99


what might be the problem?? please can any one figure it out?

thanx in advance

[debasisdas]

Please find the Connection strings for SQL Server 2005 here.

The error seems to be more related to the code than connection string.

[coolminded]

thanx for ur quick response.
i just went through the site.

but now i got next problem.
now i connect the database in a network.
the ip of the server is 192.168.1.100
the name of the computer is comp1
the database is dtbs

i use the connection string :
conn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Password=pwd ;Persist Security Info=True;User ID=administrator;Initial Catalog=dtbs;Data Source=192.168.1.100:\comp1\sqlexpress

but now it shows the error:
[DBNETLIB][ConnectionOpen (ParseConnectParams()).]Invalid connection

how should i define the data source here.
TIA