Darren D
darren at activebilling.com.au
Mon Nov 26 19:43:21 CST 2007
Hi Charlotte SQL Server 2000 The odd thing is - when I sent the text... "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\isqlw.exe" -S MyServer -d MydB -E To my colleague (With real dB details) - it worked on her machine So I think something has changed on my machine or I have dowloaded some MS security patch that stops command line access to SQL Server - I dunno Darren ----------------- T: 1300 301 731 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Tuesday, 27 November 2007 10:45 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] A2003:Command line to start SQL QA No longer works And which version of SQL Server are you using? Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren D Sent: Monday, November 26, 2007 3:28 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] A2003:Command line to start SQL QA No longer works Hi All Cross posted to DBASQL >From an Access 2003 APP - I use a command line - built from a string - >to spark up Query Analyser It used to work - Now it no longer works - I get the error [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQLServer does not exist or access is denied When I click OK - I get another error message. Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()) The general syntax I use to spark up QA is. "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\isqlw.exe" -S MyServer -d MydB -E This has worked in the past and just 'stopped' in the last few days - not sure why I did delete all my old - no longer used - DSN's form the DSN folder - That's all I can recall (I have since recreated a few - still no joy) Any clues? - Many thanks in advance Darren -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com