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)
 ODBCBCP\driver version conflict

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-05-05 : 14:57:51
Bhas writes "Hi All,
While I am executing BCP command, I am getting following message in output file
My BCP Command on my production server
SET @MyCmd = 'bcp "exec [Test]..XMLCreation_New 58 " queryout "c:\test-files\xxxx-0-File 1.xml" -c -S xxx.xx.xxx.xxx -U sa -P xxxxx -o c:\test-files\InsertionLog.out'
EXEC master..xp_cmdshell @MyCmd
All file paths are physically available.
If I open my InsertinLog.out, I got the following message "ODBCBCP\driver version conflict"
The same if I run on my Testing server it is working fine.
[Test]..XMLCreation_New is procedure, which is resulting XML formated out. Even it is wokring fine on my production server.
May I know what might be cause of this error.
Thanks & Regards,
Sreedhar"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-05-05 : 15:05:23
Reinstall MDAC or install the latest MDAC.

Tara
Go to Top of Page
   

- Advertisement -