SQL 6.5 tempdb error 1101 - VC++ 4.2 w MFC ODBC 
Author Message
 SQL 6.5 tempdb error 1101 - VC++ 4.2 w MFC ODBC

Hi, please i need help:

I have a SQL-Server 6.5 with SP1, a tempdb with 10MB RAM.
I want to insert 100000 records from a Btrieve database into the
SQL-Server,
but after 1000-1100 records i became a exception "Error 1101 - no space
avaible
in tempdb ...". I wrote a programm with VC++ 4.2 and use the
MFC-ODBC-Functions,
where if the record in the SQL-Server exist, it will be edit, if the record
not exist,
it will be appended. I use the requery-function from the MFC-CRecordset. I
think,
thats why in the tempdb i have a lot of temporary cursors. How can i
delete them, or
who could help me solve the problem.

Kai




Sun, 25 Jul 1999 03:00:00 GMT  
 SQL 6.5 tempdb error 1101 - VC++ 4.2 w MFC ODBC

I have spotted that you have not received any responses to both of your
queries.  Perhaps if you supply some code I could provide some further
explanations and offer some help.

You may also try to post this question to the SQL Developers newsgroups, as
most C++ gurus do not have intricate SQL Server knowledge.

Ben Thomas
MCT, MCSE, MCSD


http://www.pro.co.nz



Quote:
> Hi, please i need help:

> I have a SQL-Server 6.5 with SP1, a tempdb with 10MB RAM.
> I want to insert 100000 records from a Btrieve database into the
> SQL-Server,
> but after 1000-1100 records i became a exception "Error 1101 - no space
> avaible
> in tempdb ...". I wrote a programm with VC++ 4.2 and use the
> MFC-ODBC-Functions,
> where if the record in the SQL-Server exist, it will be edit, if the
record
> not exist,
> it will be appended. I use the requery-function from the MFC-CRecordset.
I
> think,
> thats why in the tempdb i have a lot of temporary cursors. How can i
> delete them, or
> who could help me solve the problem.

> Kai





Mon, 26 Jul 1999 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. SQL 6.5 tempdb error 1101 - VC++4.2 w MFC-ODBC

2. PRJ98 FileOpen Error 1101 with VC++ MFC Automation

3. PRJ98 FileOpen Error 1101 with VC++ MFC Automation

4. PROBLEM: Accessing SQL SERVER 6.5 from 16 bit ODBC Application (VC++ 1.5)

5. Connection is busy with results - VC++ 1.52, SQL Server 6.5, ODBC

6. PROBLEM: Accessing SQL SERVER 6.5 from a VC++ 1.5 ODBC application

7. VC++ 1.52, Connection is busy with results - SQL Server 6.5, ODBC

8. MS SQL-Server 6.5 - MFC ODBC functions. Problem with tempdb.

9. DAO vs ODBC for SQL Server 6.5

10. triggers cascading DELETE with ODBC on SQL Server 6.5 and 7

11. ODBC and MS SQL Server 6.5

12. ODBC And SQL 6.5

 

 
Powered by phpBB® Forum Software