Error using RDO query object with SQL Server 7.0

While using RDO(msrdo20.dll) query object to create a temporary table in SQL
Server 7.0(with SP4), I am gettng the error:
Code '40002': Error: S0001: :[Microsoft][ODBC SQL Server Driver][SQL Server]
There is already an object name '#<name of temporary table>' in the database.
Please help me to resolve this.
Thanks.
Temporary objects persist until they go out of scope or are explicitly
dropped. If you are in the midst of development, you probably have a
pre-existing creation of the object on your current connection that you have
yet reseted nor have you explicitly dropped the table.
Sincerely,
Anthony Thomas

"ak3010" <ak3010@.discussions.microsoft.com> wrote in message
news:FD8956BA-5547-402C-88E5-2981F0A1860B@.microsoft.com...
While using RDO(msrdo20.dll) query object to create a temporary table in SQL
Server 7.0(with SP4), I am gettng the error:
Code '40002': Error: S0001: :[Microsoft][ODBC SQL Server Driver][SQL Server]
There is already an object name '#<name of temporary table>' in the
database.
Please help me to resolve this.
Thanks.
|||While using RDO(msrdo20.dll) query object to create a temporary table in SQL
Server 7.0(with SP4), I am gettng the error:
Error: 40002: :[Microsoft][ODBC SQL Server Driver][SQL Server]
The cursor was not declared
From http://www.google.co.in/search?q=40002+++msrdo20.dll&hl=en&start=10&sa=N
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com