Hello,

I need to formulate a query with temporary tables and pass it to a DW to replace the original source. I am using the SNC client (Provider='SQLNCLI11')

For example

SELECT im_item
INTO #temp 
FROM im
WHERE im_type='07' 
 

SELECT a.im_item,im_title 
FROM im, #temp a
WHERE im.im_item = a.im_item

I use Autocommit=True but I get a weird behavior with StaticBind parameter. When I set it to 0 PB17 crashes, while when I set it to 1 the DW does not return any results.

The above works perfectly with the SYC client. We need to migrate all our applications from ASE to SQL Server.

Any help would be much appreciated.

Regards,

Lucas