Post reply

Invalid object name

  • November 11, 2005 at 3:29 pm

    #364162

    I imported a database.

    Datasource checks out, Coldfusion datasource checks out.

    Query analyzer works.

    When I use the old programs and just change the dsn  I get the error 208 :Invalid object name"

    What am I doing wrong????

    Thanks

  • November 11, 2005 at 6:59 pm

    #603537

    Check the permissions of the users accessing the objects.

  • November 13, 2005 at 10:06 am

    #603572

    All the database and table permissions seem to be the same in the two databases. All are "Public".

  • November 14, 2005 at 3:35 am

    #603605

    What's the format of your object name in the dsn?

  • November 14, 2005 at 7:21 am

    #603638

    Double check the (default) database name in the coldfusion administrator. 

    Also, I've seen an issue in coldfusion MX where the connection gets stuck in the wrong database.  I didn't have time to research the issue on my end so I just changed the sql statements to reference the database name.  (i.e.  SELECT EmpFirstName, EmpLastName FROM EmpDB.dbo.Emploee WHERE EmpID = 1)

  • November 29, 2005 at 2:19 am

    #606344

    HI Jack,

    Plerase let me know if you were able to resolve the issue and what was the solution.

    Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply