index | search | no replies | posting guidelines | help login | register
Index » Products » ASP Report Wizard v2
search this forum:
:: Microsoft Error when trying to create Report :: (4)Post a New Message | Post a Reply
Jan 21 2009, 5:00 AM
 Microsoft Error when trying to create ReportPost a Reply
 Giscoes_Sash

View this author's profile Send this author a private message

since: Jan 21, 2009
from: Pretoria, South Africa

Hi There,

Please can someone assit with the error we are recieving on a clients server. The error did not exist when the server was with me on my network. Once the server was moved back to the client the issue surfaced.

Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][SQL Native Client][SQL Server]Invalid object name 'LOOKUPS_ATTACHMENT_TYPES'.

/tshwanevaluations_test/GUI/Report/SystemReport.asp, line 30
    

Line 30 is pasted below.

Any assitance will be highly appreciated.
objWiz.Init(Application("Reports_ConnStr"))

Jan 29 2009, 9:56 AM
 Re: Microsoft Error when trying to create ReportPost a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

It seems table 'LOOKUPS_ATTACHMENT_TYPES' does not exist in your new database


-------------------------
Ghost
Jan 29 2009, 9:47 PM
 Re: Microsoft Error when trying to create ReportPost a Reply
 Giscoes_Sash

View this author's profile Send this author a private message

since: Jan 21, 2009
from: Pretoria, South Africa

Thats was our first thought as well, but the table does exist.

Feb 11 2009, 4:54 AM
 Re: Microsoft Error when trying to create ReportPost a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

Does this statement work when you run it from query analyzer?

SELECT *  FROM LOOKUPS_ATTACHMENT_TYPES



-------------------------
Ghost
Pages: (1)   [1]

search this forum: