> 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. _______________________________________________ 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.
