BCP Error

CP Activation Error
-------

The following command runs on several PCs without any problems,
but on one of the computers + user the bcp resulting with error

Env:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
SQL Server: win 2000 server
PCs: win 2000 professional

Command:
"bcp" "select a, b from db_name.dbo.tbl_name WHERE (c = 0) ORDER BY a" "queryout" "\\pc-name\dir1\dir2\file-name.p" "-Ssrv" "-T" "-c"

Result:
Starting copy...
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Code page 862 is not supported by SQL Server
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Unable to resolve column level collations

BCP copy out failed

Please, help me to solve this problem

HelenaInteresting...you mean different servers, right...

Collation not supported? Hmmmm...

Is this SQL Server or sybase?|||Is there a difference between the computer with the problem and other machines where it's working fine in Windows Regional Settings? mojza|||Hi, Its runs ok on other PCs & for other users. The connection to MSSql 200 it with windows id.
Thanks
H|||Hi,
There is only MsSql server 2000, no Sybase involved.
I Don't know the setting of the computers - whot chell i check ?
Thanks
Helena|||Hi,
Thanks for the hint.
I changed the Windows Regional Settings on the problemathic PC and now BCP works ok.

Thanks again
Helena

BCP call to import data from computer other than server is this possible?

Hi,

I have written an application which is being used by only 4 people on different computers. The one with SQL Server installed is comp0, then comp1, .... comp4.

Everything was working fine until today when the only user who is authorised (by my application) to perform the data import of BCP files, tried to import the latest BCP files. I am making my bcp command line string and then calling it using the VB Shell call.

If I run the import option from my app on the server it works fine. So at first I thought, ah, the BCP files won't be in the other computers path. I've copied BCP.EXE and BCP.rll but it still doesn't work.

Is it even possible to run BCP from a computer other than the one with SQL Server installed? I really need the import to work on a computer other than the server.

Thanks in advance,

Paul

Hi Paul,

What is the bcp command you are tyring to call exactly?

Thanks

Cris

|||

Hi Cris,

The calls is as follows:

strBCPCommand = "bcp database_name.schema." & _

table_name & _

" in " & _

full_path_of_bcp file & _

" -n -T -Sserver_name\sql -V65"

It all works fine when called from the application or command line on the server.

Thanks,

Paul