table not found

Discussion in 'Databases' started by cjcody, Nov 30, 2006.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. cjcody

    cjcody

    I've upload my Mojoportal database to the MySQL database recently provisioned at DASP. I can query against it. When I try to access my site (at the alternate URL since the name servers haven't caught up yet), I get the message "#42S02Table 'MYSQLDB_999999.mp_Sites' doesn't exist", yet I can see the table and query the single row in it via SQLyog. Any suggestions on where to look?

    I am using the MySQL.Data.dll data provider and the it is located in my bin directory.
     
    cjcody, Nov 30, 2006
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    i am not too familiar with this data provider. I suspect you may be accessing another database on the server??


    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Dec 2, 2006
    #2
  3. cjcody

    cjcody

    The problem turned out to be related to case sensitivity. My table names on the host site needs to be capitalized.
     
    cjcody, Dec 2, 2006
    #3
  4. Bruce

    Bruce DiscountASP.NET Staff

    Ah.. right..


    Our mySQL server is hosted on a UNIX box and is case sensitive.


    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Dec 5, 2006
    #4
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page