bcp & error 10063 
Author Message
 bcp & error 10063

I am trying to run bcp on a sql server 6.5 table.  I keep
getting error 10063 'Unable to open data file'  I get the
same message whether I bcp in or out of the database.
Example:
bcp Personnel..exporttable out d:\MyExportFiles\exp.out
-fd:\MyExportFiles\bcp -T
I am in an environment running both NT & Novel.  I have
tried running bcp on my client workstation (Windows 95) and
directly on the NT 4.0 Server with the same result. Any
ideas on what to check?  Could it be the path to the file?
(I have tried both the MSDOS path and the NT path)  Any
suggestions would be appreciated.


Mon, 01 Jan 2001 03:00:00 GMT
 bcp & error 10063

    As the error description says, it has something to do with the
non-existing file. You have the '-f' flag for the bcp format file but
d:\MyExportFiles\bcp is not a valid file or filename. You must specify, for
example, d:\MyExportFiles\bcp.fmt, which must have the valid bcp format
statements.

Khin Zaw
Seattle, WA


Quote:
>I am trying to run bcp on a sql server 6.5 table.  I keep
>getting error 10063 'Unable to open data file'  I get the
>same message whether I bcp in or out of the database.
>Example:
>bcp Personnel..exporttable out d:\MyExportFiles\exp.out
>-fd:\MyExportFiles\bcp -T
>I am in an environment running both NT & Novel.  I have
>tried running bcp on my client workstation (Windows 95) and
>directly on the NT 4.0 Server with the same result. Any
>ideas on what to check?  Could it be the path to the file?
>(I have tried both the MSDOS path and the NT path)  Any
>suggestions would be appreciated.



Mon, 01 Jan 2001 03:00:00 GMT
 bcp & error 10063
I tried a lot of different combinations, but maybe I always left the .fmt off
the format file.  I will try it with the .fmt extension and see what happens.
Thanks.

Steven C. Gray
Essential Software Solutions

Quote:

>     As the error description says, it has something to do with the
> non-existing file. You have the '-f' flag for the bcp format file but
> d:\MyExportFiles\bcp is not a valid file or filename. You must specify, for
> example, d:\MyExportFiles\bcp.fmt, which must have the valid bcp format
> statements.

> Khin Zaw
> Seattle, WA



Tue, 02 Jan 2001 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Help with BCP & data file access error

2. Date Format & BCP errors

3. BCP & file access error

4. ODBC, BCP Error: Unable to open BCP host data-file

5. BCP Error: Connection is not enabled for BCP

6. ODBC, BCP Error: Unable to open BCP host data-file

7. BCP error or SQL Server error?

8. bcp & floats problem

9. BCP & loading numeric data

10. BCP, BULK command, package & JOB


 
Powered by phpBB® Forum Software