I have a script that writes 83 separate files to a directory using bcp.
The script in total worked perfectly well until two weeks ago.
I am now getting the same error message for data from 25 different tables. The error is:
SQLState = S1010, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Function sequence error
The exact bcp command for one of these tables is as follows:
bcp "Select * from Smed_data2000.. vw_CrsMstSORD" queryout "\\som\sqlF\dat aout\sord\07073 0\tblCrsMst.txt " -T -c -a 65535 -b 10 -S<servername>
In this example, the view returns 2311 records, hardly enough I think to cause this problem.
DTS works nicely but since my company is using SQL2000 (looking to move shortly to SQL2005) I don't want to write a DTS package in SQL2000 and then have to rewrite it when we move to SQL2005.
Any suggestions are greatly appreciated!
The script in total worked perfectly well until two weeks ago.
I am now getting the same error message for data from 25 different tables. The error is:
SQLState = S1010, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Function sequence error
The exact bcp command for one of these tables is as follows:
bcp "Select * from Smed_data2000.. vw_CrsMstSORD" queryout "\\som\sqlF\dat aout\sord\07073 0\tblCrsMst.txt " -T -c -a 65535 -b 10 -S<servername>
In this example, the view returns 2311 records, hardly enough I think to cause this problem.
DTS works nicely but since my company is using SQL2000 (looking to move shortly to SQL2005) I don't want to write a DTS package in SQL2000 and then have to rewrite it when we move to SQL2005.
Any suggestions are greatly appreciated!