I had 2 connectionstrings for sqlserver connection:

1. Using ODBC
"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"

and

2. Using Oledb
"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"

my question is which better between them? or may be there is another?

I have tried to use the 2nd (using oledb) .. but it always fails when connect to large size DB.. I need advice .. many thanks in advance

Regards
Winanjaya