Hi,

I am using MS SQL SERVER 2000 and its Data Transformation Service(DTS)
to import my DBASE IV database to MS SQL server database. I can import
most of the files without any trouble, but with some files, I get the
following error
message:

Error Source: Microsoft JET Database Engine

Error Description: The Microsoft Jet database engine could not find the
object
'LowesRetailDB'. Make Sure the object exists and that you spell its
name and the
path name correctly.

Context: Error calling OpenRowset on the provider



Here LowesRetailDB is a DBASE IV file.
At first I thought the file name violated some rules about the table
name length but I
have imported some files having even longer names.

Does anyone have any idea what might be the problem?

Hi Shwetabh

I believe this is an error due to the file name of your DBASE
being longer than 8 characters. Try renaming to something shorter
and re-import it.

It's strange how Microsoft still has these silly restrictions on certain
applications.

Regards,

Raul


"Shwetabh" <shwetabhgoel (AT) gmail (DOT) com> wrote

Hi Raul,

I renamed all my files to less than 8 characters and it worked.
But the surprising thing is that when I used a dbase file having name
of 18
characters, it worked perfectly fine and got imported without any
problem.

So, I think it has nothing to do with the length of file names.
Any other ideas where the problem might be?

Regards,
Shwetabh

Hi Shwetabh,

I cannot re-create this. I have never been able to import a dbase file
with a name of more than 8 characters in length, which leads me to believe
that this has something to do with file naming convention.
This dbase file with a long name you're talking about, what version is it?
How was it created?

As this is a Jet error you're getting, you could try looking at some
registry keys like:
SupportsLongNames under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\ISAM Formats\dBase IV
or Jet 3.5
By default these are set to OFF.

Regards,
Raul

"Shwetabh" <shwetabhgoel (AT) gmail (DOT) com> wrote

Hi,
I created this DBASE file from a labelling software called EasyLabel.
It creates the
files in DBASE IV format. The name of the file which despite having a
long name got
converted easily is bwfcover_semco-mmg.dbf. I had to use square
brackets [] to
import the records in a table with same name.

I checked the registry. As you said, the key was set to OFF. I set it
to ON ie 1 but
it didnt help.
Any other ideas?

Regards,
Shwetabh