Stephen, I installed it automatically with Visual Studio 2K5. I can see the server within 2K5 no problems but not from VFP and to set up a data source. I might just uninstall the whole lot and start again but it's a 3-4 hour job!
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 [EMAIL PROTECTED] Sent: 19 July 2006 16:18 To: ProFox Email List 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 need to use SQL Native Client, that is the 2005 version. I just made one and can use it in Excel. Who installed the SQL? Did you open it up for use? Did you allow TCP/IP? You see the new version comes locked down and you have to actually open up what and how to connect to it. Secondly, how are you connecting? Goes back to last Q, in that how was the server configured? Just because it's not easy doesn't mean it's not working. It may be working according to the current install plan. No users or connections until someone defines what they will be. HTH. [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.
