Solved TD-4042: Create temporary table through ODBC SQL Server 2000.

Post found bugs and possible workarounds.
flomih

TD-4042: Create temporary table through ODBC SQL Server 2000.

Post by flomih » 15 Nov 2007, 11:32

I have a question, why the next sql statement can be executed correctly through OLEDB – SQL Server 2000 but is crashed through ODBC – SQL Server 2000?


Code: Select all

SqlPrepareAndExecute(hSql, "create table ##XT65VEHO000000001111411271079 ( 
   ROWID int identity(1, 1 )  not null,
   UNITID varchar( 3 ) COLLATE SQL_SwedishStd_Pref_CP1_CI_AS null, 
   UNITNAME varchar( 50 ) COLLATE SQL_SwedishStd_Pref_CP1_CI_AS null, 
   RDATE datetime  null, 
   GSALID int  null, 
   WRKORDNO int  null, 
   CUSTNO int  null, 
   ESTDELD datetime  null, 
   SERVD datetime  null, 
   STATUS varchar( 1 ) COLLATE SQL_SwedishStd_Pref_CP1_CI_AS null, 
   STYPE varchar( 1 ) COLLATE SQL_SwedishStd_Pref_CP1_CI_AS null, 
   CUSTNAME varchar( 130 ) COLLATE SQL_SwedishStd_Pref_CP1_CI_AS null, 
   BILLD datetime  null, 
   STATSCUSTNO int  null, 
   GRECNO int  null, 
   REFE varchar( 50 ) COLLATE SQL_SwedishStd_Pref_CP1_CI_AS null, 
   EINVDATE datetime  null, 
   LICNO varchar( 20 ) COLLATE SQL_SwedishStd_Pref_CP1_CI_AS null, 
   SERIALNO varchar( 20 ) COLLATE SQL_SwedishStd_Pref_CP1_CI_AS null, 
   WARHAPPID varchar( 8 ) COLLATE SQL_SwedishStd_Pref_CP1_CI_AS null, 
   WARHDAMNO int  null, 
   WARHSTATUS varchar( 1 ) COLLATE SQL_SwedishStd_Pref_CP1_CI_AS null, 
   WARHRECON int  null, 
   SUBORDER int  null, 
   DELETED datetime  null, 
   SPINNR varchar( 20 ) COLLATE SQL_SwedishStd_Pref_CP1_CI_AS null, 
   ARECNO varchar( 20 ) COLLATE SQL_SwedishStd_Pref_CP1_CI_AS null, 
   WARCUSTNO int  null, 
   WARCUSTNAME varchar( 100 ) COLLATE SQL_SwedishStd_Pref_CP1_CI_AS null )" ) 
Thanks.



Best regards,

Florin

Jean-Marc Gemperle

Re: TD-4042: Create temporary table through ODBC SQL Server 2000.

Post by Jean-Marc Gemperle » 22 Nov 2007, 16:49

Hi Florin,



Yes it crash with the native router I mean ODBC connection and not with OLEDB. It should never crash thus it is a bug. Note it is not a TD 5.1 bug but a SQLBaseIntl bug since the crash can be reproduced using SQLTalk. I've try to set the SqlOutMessage without any luck..



I've try this with our last internal build. I will let you know the bug number



Cheers

Jean-Marc
You do not have the required permissions to view the files attached to this post.

flomih

Re: TD-4042: Create temporary table through ODBC SQL Server 2000.

Post by flomih » 23 Nov 2007, 09:59

Hello!



Thanks.



Florin

Jean-Marc Gemperle

Re: TD-4042: Create temporary table through ODBC SQL Server 2000.

Post by Jean-Marc Gemperle » 23 Nov 2007, 11:00

For nothing really

Thank you for your report and for your time reporting us this issue. The log is TD-4042



Cheers

JM

Jean-Marc Gemperle

Re: TD-4042: Create temporary table through ODBC SQL Server 2000.

Post by Jean-Marc Gemperle » 05 Dec 2007, 18:10

Hi



This issue is fixed in the coming patch



JM

flomih

Re: TD-4042: Create temporary table through ODBC SQL Server 2000.

Post by flomih » 10 Dec 2007, 15:47

Hello!

Thanks. Could you tell me an approximate date for the comming patch?

Best regards,
Florin

Return to “Bug Reports”

Who is online

Users browsing this forum: [Ccbot] and 0 guests