Charlotte Foust
cfoust at infostatsystems.com
Mon Nov 26 17:45:29 CST 2007
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