I am using the following line to export data from SQL Server to a text file. This has been running without any problem for a couple of months. We had to reset the server the other day and since then the BCP fails with the error below any idea

Command Used:

SET @Qry = 'SELECT LineValue FROM myData..Export where BatchRef = ''' + @BatchRef + '''' + ' AND SectionID = ''H''
SET @cmd = 'bcp "' + @qry + '" queryout ' + @file + ' -t , -c -Uauser -Ppassword

Error Message :

SQLState = S1000, NativeError =
Error = [Microsoft][ODBC SQL Server Driver]ODBCBCP/Driver version mismatc
NUL

Check two of your DLLs for version mismatches sqlsrv32.dll and odbcbcp.dll.
If the version numbers are different,
Re-apply MDAC on this machine.



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]
file. This has been running without any problem for a couple of months. We
had to reset the server the other day and since then the BCP fails with the
error below any ideas
[quoted text, click to view]