October 25, 2002 at 1:25 pm
Can anyone help?
I have an ASP page written in JScript which returns a SQL Server error which states:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]The identifier that starts with 'SELECT TOP 1000 convert(varchar, IceEvents.StartTime, 120), IceEvents.EventId, IceEvents.IssueId, IceEvents.IssueName, ' is too long. Maximum length is 128.
/soc/buildTable.asp, line 210
The offending line reads:
rsRec = dbConn.Execute(strSQL, 3, 1);
I have not done anything to the SQL database except bump up the memory. If anyone can help I would greatly appreciate it.
October 25, 2002 at 2:09 pm
UPDATE: It is now working!
I did a response.write on my execute statement and pasted it into query analyzer (the query was actually running a stored proc) and ran it. I received the same error. I uncommented PRINT statements in the SP and ran it again.
It was successful. So, I commented out the PRINT statements and it continues to work fine.
I did howver, notice that during the error messages SQL Server was running some background service or something (task manager showed significant activity). Once this stopped my trouble went away.
Still, if anyone knows what may cause this error to produce I would surely value your insight, in case this should happen again.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply