Re: Connect to Remote MSSQL Server DB errors out
"Craig A. Berry" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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:[email protected] "... getting out of a sonnet is much more difficult than getting in." Brad Leithauser