Wednesday, March 7, 2012

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=40...elopmentnow.com

No comments:

Post a Comment