Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Devistator

  1. Devistator

    Help with Error "Invalid object name"

    i know, the forum policy forbid posting email addresses and personal info, but i can't find way of sending PM
  2. Devistator

    Help with Error "Invalid object name"

    Guys, it's like talking greek to me. If you agree I'm ready to send you my login info for both SQL Server and webhost to take a look. I don't have what to loose. Please advise Thanks
  3. Devistator

    Help with Error "Invalid object name"

    something i don't understand running: select * from information_schema.tables where table_name like 'C%' order by table_name i didn't get all the tables from sql server just starting with "Company" ??????????? i'm lost
  4. Devistator

    Help with Error "Invalid object name"

    I'm sorry, it should have been: Set rsTest = Conn.Execute("select @@Servername + ' -- ' + db_name()") Response.Write(rsTest(0)) Response.End Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near '='.
  5. Devistator

    Help with Error "Invalid object name"

    amcan,dbo,Companies,BASE TABLE amcan,dbo,Companies$,BASE TABLE amcan,dbo,CompanyAwards,BASE TABLE amcan,dbo,CompanyAwards$,BASE TABLE amcan,dbo,CompanyContacts,BASE TABLE amcan,dbo,CompanyContacts$,BASE TABLE amcan,dbo,CompanyCustomers,BASE TABLE amcan,dbo,CompanyCustomers$,BASE TABLE...
  6. Devistator

    Help with Error "Invalid object name"

    After running: Set rsTest = Conn.Execute("select @@Servername + ' -- ' + db_name()) Response.Write(rs(0)) Response.End got this message: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near '='. Msg 105, Level 15, State 1, Line 1 Unclosed quotation mark before the character string...
  7. Devistator

    Help with Error "Invalid object name"

    Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'table'.
  8. Devistator

    Help with Error "Invalid object name"

    qmmastros here is the line Provider=MSDASQL.1;Extended Properties="DSN=amcan2;UID=------;PWD=------;APP=Microsoft(R) Windows (R) 2000 Operating System;WSID=DEDI279" sqldenis table does exist Thanks
  9. Devistator

    Help with Error "Invalid object name"

    Not a professional. Lost my db guru and having problems with ms sql. Help will be appreciated. this is one of the errors i'm receiving, but actually the db is not getting read or updated by the asp. "Microsoft OLE DB Provider for ODBC Drivers error '80040e37' [Microsoft][ODBC SQL Server...
See more

Part and Inventory Search

Back
Top