Hi!
I am writing an application using vb6 and sql server 2005. I want to know whether I should use Microsoft OLE DB Provider for SQL SERVER or SQL Native Client, to connect to databse.
e.g.
Set cn = New ADODB.Connectio n
cn.ConnectionSt ring = "Provider=SQLOL EDB.1;Integrate d Security=SSPI;P ersist Security Info=False;Init ial Catalog=test1;D ata Source= COMP1"
OR
cn.connectionst ring = '"Provider=SQLN CLI.1;Integrate d Security=SSPI;P ersist Security Info=False;Init ial Catalog=test1;D ata Source=COMP1"
I have added an adodc object on my vb6 form and built the connection from that. From there I obtained above connection strings.
Thanks.
I am writing an application using vb6 and sql server 2005. I want to know whether I should use Microsoft OLE DB Provider for SQL SERVER or SQL Native Client, to connect to databse.
e.g.
Set cn = New ADODB.Connectio n
cn.ConnectionSt ring = "Provider=SQLOL EDB.1;Integrate d Security=SSPI;P ersist Security Info=False;Init ial Catalog=test1;D ata Source= COMP1"
OR
cn.connectionst ring = '"Provider=SQLN CLI.1;Integrate d Security=SSPI;P ersist Security Info=False;Init ial Catalog=test1;D ata Source=COMP1"
I have added an adodc object on my vb6 form and built the connection from that. From there I obtained above connection strings.
Thanks.