SQL Native Client throws up error while dealing with ## temp table
This is a discussion on SQL Native Client throws up error while dealing with ## temp table within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> I have created a system DSN Using SQL Server 2005 - SQL Native Client to connect to a database ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-20-2008, 01:47 PM
| ||||
| ||||
 SQL Native Client throws up error while dealing with ## temp table I have created a system DSN Using SQL Server 2005 - SQL Native Client to connect to a database with compatibility set to 80. While I was creating index on the global temporary table I get the following error. ---------------------------------------- [Microsoft][SQL Native Client][SQL Server]Cannot find the object "##Temp267Num1_1" because it does not exist or you do not have permissions. SQL: CREATE UNIQUE INDEX idx##Temp267Num1_1_TempRowNum ON ##Temp267Num1_1 (TempRowNum) [Error: -2147217900] [DBExecute] --------------------------------------------------------------------------- Please let me know If I am missing sothing. This is critical to me to certify SQL Native Client driver to use with our product. Thanks and Best Regards      |
Linear Mode
