temporary tables don't work with freetds?

Michal Seliga <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
hello list

I am using FreeTDS 0.82. i found problem with temporary tables, it shows when
using qt (using QTDS driver) and also when using iodbctest. everything works
properly when using tsql. I am using connection to microsoft sql database

problem is that created temporary tables disappear and can't be used later

tsql (working):

test@visibuntu:~$ tsql -S mssql -U dba -P sql
locale is "en_US.UTF-8"
locale charset is "UTF-8"
1> use HamiltonSFA_280
2> go
1> create table #temptab(cus_id integer)
2> go
1> select * from #temptab
2> go
cus_id


iodbc test (not working):

test@visibuntu:~$ iodbctest "DSN=mssql;UID=dba;PWD=sql;DATABASE=HamiltonSFA_280"
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0607.1008
Driver: 0.82 (libtdsodbc.so)

SQL>create table #temptab(cus_id integer)
Statement executed. 0 rows affected.

SQL>select * from #temptab
1: SQLPrepare = [FreeTDS][SQL Server]Invalid object name '#temptab'. (208)
SQLSTATE=42S02
2: SQLPrepare = [FreeTDS][SQL Server]Statement(s) could not be prepared. (8180)
SQLSTATE=42000

in qt (using QTDS driver) it behaves the same as with iodbc test


from my past experience i guess that problem can be related to the fact that
microsoft sql can't use prepare/execute step when creating temporary tables,
only direct execution works. see note at
http://msdn.microsoft.com/en-us/library/aa905910%28SQL.80%29.aspx


so is it known problem or something new?
and is there any possible workaround to make it work?

thanks
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.