Oh Yes, I forgot to add I've enabled TCP/IP and Named Pipes in the SQL Server 2005 Configuration so I know it isnt't that.
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 Dave Crozier Sent: 19 July 2006 14:37 To: 'ProFox Email List' Subject: Problems Connecting to M$SQLExpress Anyone out there got details on connecting to SQLExpress with VFP9? I have created a database and can see it on my local machine via the M$ SQL Server Management program. Gave allowed remote logins on administrator (sa) and can't seem to be able to construct a valid DSNLess connection string: My latest attempt is: cConnect="'Provider=SQLOLEDB.1; " ; +"Data Source=.\SQLExpress; " ; +"trusted_connection=false; "; +"Initial Catalog=Flexispec; " ; +"User Id=sa; " ; +"Password=sa" 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! I know I should never have been talked into this, but we have a requirement to link PDA's into SQLExpress to do auto replication whilst cradled (which I've got working fine) but now I need to feed stuff out of VFP into the SQLExpress database for onward upload to the PDA's MySQL and the standard ODBC is MUCH MUCH simpler! Dave Crozier The secret to staying young is to live honestly, eat slowly, and to lie about your age -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.1/391 - Release Date: 18/07/2006 [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com 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.
