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

[flomih]

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]

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

[flomih]

Hello!

Thanks.
Florin

[Jean-Marc Gemperle]

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]

Hi

This issue is fixed in the coming patch

JM

[flomih]

Hello!

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

Best regards,
Florin