Using the OLE DB provider is prefered over the ODBC connection. You skip the ODBC layer.

For the failing, it is probably caused by the protocol used to connect to SQL (probably Named Pipe). You can force to use a TCP/IP protocol by adding Network Library=dbmssocn to your connection string. See http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q238/9/49.ASP&NoWebContent=1 for details.


>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