Skip to Content.
Sympa Menu

freetds - Re: [freetds] Connect to Remote MSSQL Server DB errors out

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Craig A. Berry" <craigberry AT mac.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Connect to Remote MSSQL Server DB errors out
  • Date: Wed, 28 Apr 2010 07:44:27 -0500


On Apr 27, 2010, at 2:38 PM, Brian Grellinger wrote:

Hi,

Using FreeTDS v0.83.dev.20090104 on AIX

We have a 4GL program that extracts data from a remote MSSQL database,
extracts additional data from an Informix database, merges the 2 using
temp tables, and outputs the results to a file.

The MSSQL database is in a remote location accessed via WAN
connection, the Informix database is on the local network.
Sometimes it works OK, but most of the time we get this error:

<
Program stopped at 'o_maxfile.4gl', line number 101.
SQL statement error number -6372 (-5242).
[FreeTDS][SQL Server]An inconsistency was detected during an internal
operation in database 'tempdb'(ID:2) on page (1:5935). Please
contact technical support. Reference number 6.


That sure sounds like a problem on the server. Have you run DBCC CHECKDB to discover and/or repair problems with tempdb on that instance?
________________________________________
Craig A. Berry
mailto:craigberry AT mac.com

"... getting out of a sonnet is much more
difficult than getting in."
Brad Leithauser





Archive powered by MHonArc 2.6.24.

Top of Page