On Tue, May 6, 2008 at 3:43 PM, Grigore Dolghin <[EMAIL PROTECTED]> wrote:
> I am using that form every day to connect to SQL Server 2005. The 2005
> form
> uses SQL Native Client instead ODBC and I have found it to be slower, but
> it
> may be my personal experience only.
>
---------------------------
Do you mean instead of a DSN?
Now what is slower? the initial connection or fetching of data?
> ----- Original Message -----
> From: "Stephen Russell" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, May 06, 2008 4:04 PM
> Subject: Re: Help! VFP and SQL Named instances.
>
>
> > On Mon, May 5, 2008 at 11:58 PM, Grigore Dolghin <[EMAIL PROTECTED]>
> > wrote:
> >
> >> Hi
> >>
> >> 1. Yes. Connection string looks like this one: Driver={SQL
> >>
> >>
> Server};Server=myServerAddress\myInstanceName;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
> >>
> >> 2. Yes. http://msdn.microsoft.com/en-us/library/ms144259.aspx
> >>
> >
> --------------------------------------------------------------------------------------------------------
> >
> >
> > That looks like a 2000 db conn string.
> >
> > http://www.connectionstrings.com/?carrier=sqlserver2005
> >
> > This will show you the Driver you need. It will also show the various
> > setups that you can use.
> >
> > --
> > Stephen Russell
> > Sr. Production Systems Programmer
> > Mimeo.com
> > Memphis TN
> >
> > 901.246-0159
> >
> >
> > --- StripMime Report -- processed MIME parts ---
> > multipart/alternative
> > text/plain (text body -- kept)
> > text/html
> > ---
> >
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
