ODBC Error Code = 37000

andy4444 posted this at 03:24 — 13th December 2000.

Joined: Oct 2000

Does anyone have an idea of why this error comes about on SQL 7:

Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)

[Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate new page for database 'tempdb'. There are no more pages available in filegroup DEFAULT. Space can be created by dropping objects, adding additional files, or allowing file growth.

The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (165:3) to (165:119).

Date/Time: 12/12/00 22:19:19
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)
Remote Address: 210.55.236.14
HTTP Referer: http://shoptaranaki.co.nz/directory.htm
Template: E:\Inetpub\1dollardownload.com\etoon\server_tools\loadetoon2.cfm
Query String: siteid=257&etoonzwidth=495&userid=14983

Please let me know if this happens when you run out of space.?

Thanks

Peter J. Boettcher posted this at 16:33 — 13th December 2000.

They have: 812 posts

Joined: Feb 2000

Andy,

I can't find that error number, but it sounds maybe either:

1) The tempdb hasn't been set to automatically grow. Go into it's properties and set both the data and log files on automatic grow.

2) You ran out of hard drive space. Try shrinking both the data and log files, truncate your log files, or move your data files to a larger hard drive.

3) The memory on the SQL Server machine has become corrupted, try a reboot.

PJ | Are we there yet?
pjboettcher.com