Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Data read suspending on XP SP2

Author  Topic 

kiluyar
Starting Member

2 Posts

Posted - 2007-03-30 : 00:48:43
Hi, all

I'm developing a client report tool to fetch data from my SQL Server 2000 Data Base. My SQL Server 2000 was installed on WINDOWS XP with SP2. I'm using Microsoft OLE DB for SQL Server to access it. My server network utility setting is TCP/IP mode ans using default port: 1433.

However, when I tried to get a large data from SQL Server, my client report tool failed when open rowset! SQL Server return such error message:

ADO Error Code: 0x Source: Microsoft OLE DB Provider for SQL Server Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
SQL State: 08001
Native Error:1

I don't know the cause. The error occurred randomly after I repeated opening row set several times. For small data report, its data reading needn't long time and no such problem.

I have closed my fire well service of XP SP2.

kiluyar
Starting Member

2 Posts

Posted - 2007-03-30 : 01:19:54
By the way, I tried to use ODBC, it doesn't has such problem.
Go to Top of Page
   

- Advertisement -