Yep just changed it - that option was greyed out(not chosen) so I ticked and selected my DB on that SQLServer.
Should I restart now perhaps??? -----Original Message----- From: Knott, Brian [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 March 2003 4:03 PM To: CFAussie Mailing List Subject: [cfaussie] RE: SQL error in MX Are you switching databases. In the ODBC control panel when you connect to an SQL server you also choice the database. The default of the master database. Have you changed this. Brian -----Original Message----- From: Hickman, Matt [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 March 2003 3:00 PM To: CFAussie Mailing List Subject: [cfaussie] RE: SQL error in MX But it's not an Access DB??? My user DSN on this machine has verified AOK using SQLServer driver and pointing to this remote machine. Then my datasource in CFMX using ODBC Socket verify's ok also???? Next step?? -----Original Message----- From: Knott, Brian [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 March 2003 2:04 PM To: CFAussie Mailing List Subject: [cfaussie] RE: SQL error in MX Its saying its trying to use an Access drive not SQL Server. Brian -----Original Message----- From: Hickman, Matt [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 March 2003 1:02 PM To: CFAussie Mailing List Subject: [cfaussie] SQL error in MX Hopefully a quick one you can answer before I start looking around elsewhere: I've got a new laptop and have setup my datasource in MX to point at our web server which the db sits on (SQLServer2000) SQLServer has been setup to give me machine access rights to this db and tables I develop locally on my laptop using the "live" data rather than replicate on this machine yadda yadda I get this error: Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'TABLESTORY'. Make sure it exists and that its name is spelled correctly. This table does exist and is spelt correctly. Any ideas, clues??? matt **********************************************************************" This correspondence is for the named person's use only. It may contain confidential or legally privileged information or both. " No confidentiality or privilege is waived or lost by any " mistransmission. If you receive this correspondence in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or rely on any part of this correspondence if you are not the intended recipient. Any views expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the views of Vodafone. This email has been checked for viruses. **************************************************************************** ****************** --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
