Page 1 of 1

unable to open file from location

Posted: Wed May 16, 2007 10:46 am
by svkworld
I am getting this error while running the ds job. I checked the location of the file. I don't know why I am getting this error. Its a .dbf file. I added ODBC driver to read .dbf file. I have some other .dbf files and they worked fine. This file is 20GB in size. Does size matters?

SQLSTATE=S0002, DBMS.CODE=30040
[DataStage][SQL Client][ODBC][DataDirect][ODBC dBase driver]Cannot open file

Appreciate any input.

Posted: Wed May 16, 2007 4:22 pm
by ray.wurlod
Double check the location of the file that you have specified in the DSN. Check that you have permission to open the file. Size should not be a problem just to open the file.

Posted: Wed May 16, 2007 4:51 pm
by pradeepleon
ray.wurlod wrote:Double check the location of the file that you have specified in the DSN. Check that you have permission to open the file. Size should not be a problem just to open the file.
...
Also try
the file name is correctly spelled(Do not copy & paste file name...instead try typing it in.)