thank you...I will check that out....here is an example of
my T-SQL code that the fetch is failing for on the NT
machine but works for the 2000 pro machine.
>> Hello...I hope some one can help. I have this procedure
>> that has a Cursor that returns about 11407 records. I
>> Fetch the first row innitially and go right into
>> (fatchstatus=0)" loop and fetch next. In this loop I
>> two Insert statements. On my one machine 2000 Pro/SQL
>> client/256MB of RAM.....on this machine the the Fetch
>> through all rows....for the loop...thus Fetch_status is
>> always = 0 during the WHILE statement up to the end of
>> record. NOW on my other machine NT 4.0/SQL 7.0
>> client/256 MB of RAM...for some reason the fetch fails
>> after 214 rows...and I have to run it again to finish
>> machines....for some reason the fetch is failing on this
>> partiular machine.....why? Help!
This posting is provided "AS IS" with no warranties, and confers no rights.
| Content-Class: urn:content-classes:message
| Subject: Re: Cursors/Fetch Failing on NT 4.0 machine
| Date: Thu, 16 May 2002 06:08:41 -0700
| Lines: 156
| MIME-Version: 1.0
| Content-Type: multipart/mixed;
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcH82szFmWLc3gPLQBen/5/C4E6kPA==
| Newsgroups: microsoft.public.sqlserver.programming
| Path: cpmsftngxa07
| Xref: cpmsftngxa07 microsoft.public.sqlserver.programming:258342
| NNTP-Posting-Host: TKMSFTNGXA10 10.201.226.38
| X-Tomcat-NG: microsoft.public.sqlserver.programming
| thank you...I will check that out....here is an example of
| my T-SQL code that the fetch is failing for on the NT
| machine but works for the 2000 pro machine.
I tried to execute a idc file ( it runs on IIS2.0 )that query info from SQL 6.5 on NT40
but it didn't work.
( MSSQL 6.5 ) on Machine_A < -- ( IIS 2.0 ) on Machine_B
I got the error message from web page:
[Stat=08001][Error=6][Microsoft][ODBC SQL server ][dbnmpntw]Specified SQL server not found
[Stat=01000][Error=53][Microsoft][ODBC SQL server][dbnmpntw]ConnectionOpen(CreateFile())
I set odbc ( driver version 2.65 ) SQL server setup like the following on Machine B
Data Source Name: ABC
others are default
idc file like the following:
+select * from table1
What else configuration I should setup either Machine_A or Machine_B?
Please give me some suggestions.