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: Brian Grellinger <brian.grellinger AT gmail.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 09:10:58 -0400

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 <craigberry AT mac.com> 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:craigberry AT mac.com
>
> "... getting out of a sonnet is much more
>  difficult than getting in."
>                  Brad Leithauser
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



--
Brian Grellinger
W +1 770 831 3451
C +1 404 569 7487




Archive powered by MHonArc 2.6.24.

Top of Page