affecting globally

Please Just go through the following error which is generated while accessing asp page...

Ifxoledbcerro r ' 80040e14 '


ES 0001 : ( - 310 ) Table ( prodn_t ) already exists in database. / online / xyz.asp, line 36

explanation is given below....



Explaination :

I have informix database on unix server & IIS on Win2k. I am accessing unix server (database) from windows 2k server through ODBC using ASP server scripting.

Problem is ... In informix coding there is a concept of creating temproary tables at runtime.this concept we use to generate reports to get the data in our format..... these tables will not affect globally... means ...these tables effects only that session, that user, that computer only. means if more than one user is accessing same program from different pc's at the same time...for each user it creates temproary table...it drops that table after completion of that program or session.... table created by one user will not affect other user..... this how temp table concept works in informix programming...

Same concept I used in ASP to get data.... Yes, I could able to get data.

Problem is.... temproary tables created to get data are getting affected to all programs, all users globally. assume that I have created a report ASP in which I have created one temproary table ' prodn_t ' . if more than one users are accessing the same report at the same time from different PC's.... Ist user will get the data ... remaining users... are getting above mentioned error ...

what could be the problem.....

Whatever the process I do in the report generation should affect to that programm , that session, that user, that pc only... It should not affect globally...

What I should take to avoid the above problem.....

Please help

Thanks in advance


sample code is given below...

<%
set cmd=Server.CreateObject("ADODB.Command")
set conn=Server.CreateObject("ADODB.Connection"

cmd.ActiveConnection.begintrans

sql = "create temp table prodn_t ( cast_cd integer, cast_desc char(25), prod_nos integer, prod_mt decimal(9,2), rej_nos integer, rej_mt decimal(9,2), net_nos integer, net_mt decimal(9,2)) with no log;"
cmd.commandtext = sql
cmd.execute

sql = "insert into prodn_t select a.cast_cd,b.cast_desc1[1,25]," & _ " sum(a.prod_num),sum(a.blk_tonnge),0,0,0,0 " & _ " from 'iis'.cast_prod a, 'iis'.cast_mast b " & _ " where prod_dt between '"& from_date &"'and'" & to_date & "'" & " and a.cast_cd = b.cast_cd group by 1,2,5,6,7,8"

cmd.commandtext = sql
cmd.execute

sql = "select cast_cd,cast_desc,sum(prod_nos) as prod_nos, sum(prod_mt) as prod_mt, " & _ "sum(rej_nos) as rej_nos, sum(rej_mt) as rej_mt, sum(prod_nos - rej_nos) as net_nos," & _ " sum(prod_mt - rej_mt) as net_mt from prodn_t group by 1,2 order by 1 " set

set rs=Server.CreateObject("ADODB.Recordset")
rs.Open sql,conn

Printing statements goes here... using HTML.....
then....

cmd.ActiveConnection.rollbacktrans

conn.Close
set conn=Nothing

%>