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.
unable to open file from location
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
pradeepleon
- Participant
- Posts: 32
- Joined: Fri Dec 02, 2005 10:44 pm
- Location: Chicago,IL
Also tryray.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.
...
the file name is correctly spelled(Do not copy & paste file name...instead try typing it in.)
Thanks,
Pradeep
(Ten Hugs And Nine KisseS - THANKS)......is that true?
In GOD we trust,for all others we take cash.
Pradeep
(Ten Hugs And Nine KisseS - THANKS)......is that true?
In GOD we trust,for all others we take cash.