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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-06 : 18:16:56
|
purushotham writes "I am sitting on a problem for quite some time now and this is really frustrating. Read this and if u have a solution for this please let me know.
We have a C application. It uses the DB-Library to access the SQL server. It does the bulk copy operations on MS SQL 2000.
This application does a bulk copy in and out of the SQL Server using a format file. We did generate a format file using the BCP utility of the SQL server.The command is given below -
bcp NorthWind..Customers out c:\gcp\customers.dat -Uusername -Ppassword.
While execution, this asks whether a format file is to be generated. We generated the format file with all the default choices.
The problem here is, the the application( to be specific, the db-library function which does this is bcp_readfmt(..)) doesn't read the format file saying - "Attempt to read the unknown version of the BCP format file" .The error number is 10101.
We are working on MSSQL Server 2000. OS is Windows2000 professional.The program is compiled with VC++ 6.0 compiler.
Will you kindly provide us with a solution for this.
waiting for ur reply -
regards,
Purushotham." |
|
|
|
|
|
trouble reading the format file generated by the BCP - utility