Re: Connect to Remote MSSQL Server DB errors out
Brian Grellinger <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Thanks for your reply. We had run DBCC CHECKDB on the MTSALES database and it came up clean. We forgot about tempdb, but I just ran DBCC on it and it is clean too. This has been happening whenever we use this program. If we re-run it over again enough times it eventually finishes without error. On Wed, Apr 28, 2010 at 8:44 AM, Craig A. Berry <[email protected]> wrote: > > 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 > > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds > -- Brian Grellinger W +1 770 831 3451 C +1 404 569 7487