Ted, I can't get a DSN connection as it errors out with SQL Server Error 2 : Named Pipes Provider: Could not open a connection to SQL Server
I've enabled the following Client Protocols: Shared Memory Named pipes TCP/IP In that order of priority and stopped/restarted the damned thing endless times with all possible combinations. Why does the SQL Server Management Software see everything though when I can't - a conspiracy perhaps? I Battle onwards. Oh and the documentation (at least what I have found) is just awful. Dave Crozier The secret to staying young is to live honestly, eat slowly, and to lie about your age -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ted Roche Sent: 19 July 2006 14:59 To: [email protected] Subject: Re: Problems Connecting to M$SQLExpress On 7/19/06, Dave Crozier <[EMAIL PROTECTED]> wrote: > > If I try and create a connection within the VFP DBC I get two possible > choices "SQL Server" and "SQL Native Client", both of which don't seem > to work either so I guess there is little hope with a DSNless attempt! > You may want to try to make a DSN connection first. If that works, you can use VFP's internal functions to let you know what IT is using internally as a connectionstring: liHandle = SQLConnect("YourDSNName") ? SQLGetProp(liHandle, "ConnectString") (from memory, may need a bit of debugging) > I know I should never have been talked into this, what we do for money... > > MySQL and the standard ODBC is MUCH MUCH simpler! > Well, sure! -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com [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 ** 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.
