Slow SQL Server connection VB6

[chapran]

In VB6 project I tried 2 connection strings:

    objConn.ConnectionString = "DRIVER=SQL Server;SERVER=(local);UID=;DATABASE=SRSNew;Trusted_Connection=Yes"

and

    objConn.ConnectionString = "Driver={SQL Server Native Client 10.0};Server=(local);Database=SRSNew;Trusted_Connection=yes;"

The first connection opens in 10 seconds on the local server on my development machine, the second one takes just a portion of second.

When I run the exe directly on the company server both connections are very fast.

I would not want to to use the second connection because MS SQL data type varchar(MAX) did not exist at the latest VB6 version and the ADODB recordset returns garbage containing non english characters instead of normal string.
I think that if on the company server both strings run very fast and on the local machine the first one is very slow then there are some differences in SQL Servers settings. What are they? Or I'm wrong suspecting settings?
My machine is pretty powerful - Xeon 2.8 GHZ processor SSD hard drives, 24 GB Ram.

Any suggestions please.

Thank you

[VictorN]

Please, don't post the same question to more than one CG forum!

[chapran]

Please, don't post the same question to more than one CG forum!

Sorry. I just would not want to get the answer on this forum something like this "Go to VB6 forum because it is not related to SQL Server" and opposite suggestion there on VB6.

[VictorN]

Didn't you read the Announsments before you have posted?
Please, do it: http://forums.codeguru.com/announcement.php?f=51

[chapran]

Didn't you read the Announsments before you have posted?
Please, do it: http://forums.codeguru.com/announcement.php?f=51

Sorry again