sql 2005 connection string question

hi all,
I have a vfp8 application that works with sql2000.
now we have to use it with sql2005.
the actual connestion string is lik
Driver={SQL Server};
Server=myserver;
Database=mydb;
Uid=myuser;
PWD=mypwd;


I have read in the books that for sql2005 I have to use
Driver={SQL Native Client};

and install the component from the sql2005 cd in the client pc.

so i did and it works.
But a person that uses the same program told me that there was no need of
doing this and just keep
using the connection string
Driver={SQL Server};

I could not believed him but I tried and...it works.
so my questions are:
- do I need to change the connection string or is it the same using the old
one?
- is there a difference in using one or the other...i mean if using SQL
Server} on 2005 is
less performant or with less possibilities?

tia


.

Relevant Pages

  • Previously Functioning Date Interpreter Now Failing
    ... Dim Entry As String ... Dim Result As String ... Dim ClientElement As Variant 'Holds the extracted Client Number ... ElseIf IsNumeric= False _ ...
    (microsoft.public.excel.programming)
  • RE: Previously Functioning Date Interpreter Now Failing
    ... Dim Entry As String ... Dim Result As String ... Dim ClientElement As Variant 'Holds the extracted Client Number ... ElseIf IsNumeric= False _ ...
    (microsoft.public.excel.programming)
  • Re: Threading a server
    ... I am getting myself into a really big hole with this and the client is a little upset. ... private TcpListener tcpListener; ... private string CurrentCommand ... public string ExpectedSubject ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: WSE2005: Protection requirements in MutualCertificate11Asserti
    ... error when there is a algorithm mismatch between the client and the ... The Web service is using different security requeriments. ... my client, the response page is a browser page ... message, String messageContentType) ...
    (microsoft.public.dotnet.framework.webservices.enhancements)
  • RE: SoapHttpClientProtocol request canceled
    ... Since this is only happening on the VB client, is there any chance that the ... The VB.NET exe and the VB6 exe both use VB.NET dll to sent request/response ... > inputHeaderer, String messageControlPayload, string inputMessage) ... > Imports System.ComponentModel ...
    (microsoft.public.dotnet.framework.webservices)
Loading