Previous Next

• 05-12-2008, 10:05 AM

  yanaho Joined on 05-08-2008, 6:39 PM Posts 6 yanaho

  SQL table does not exist. Help Reply Contact I have an existing table made for this select into statement.  LogParser "SELECT DISTINCT MSGID, Event-ID, Time, Recipient-Address, Sender-Address, Message-Subject INTO Emails FROM test.log WHERE Event-ID = '1028' OR Event-ID = '1020'" -i:W3c -separator:tab -o:sql -oConnString:"Driver={SQL Server};Server=intranet;db=sthunt;uid=sa;pwd=password" -ignoreIdCols:ON -createTable:OFF  When run it comes back with    Error while executing ODBC SELECT query   SQL State:     42S02   Native Error:  208   Error Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid   object name 'Emails'.   The specified table "Emails" does not exist When I change the createtable switch to on, it creates the table Emails under the Master db.  The database sthunt does exist and so does the table emails.  Can anyone help?

  Tags: table does not exist

• 05-12-2008, 2:08 PM

  In reply to

  jeff@zina.com Joined on 09-26-2003, 10:43 AM Naples, FL, USA Posts 1,251 jeff@zina.com

  Re: SQL table does not exist. Help Reply Contact Use standard SQL notation to make sure you're working in the right database and table.  As in: "SELECT..... INTO sthunt.Emails FROM..." As long as the Emails table exists in the sthunt database as you say, this should find it.  By default it's looking in Master. Jeff Look for Wrox's new book Professional IIS 7 in your local bookstore, or order now at Amazon.com

• 05-12-2008, 2:24 PM

  In reply to

  yanaho Joined on 05-08-2008, 6:39 PM Posts 6 yanaho	Re: SQL table does not exist. Help Reply Contact Thanks for the reply, I ended up using the -switches instead of -oconnectionstring which seems to be working.