473,378 Members | 1,578 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

Cannot import/link data from dBase with SQL Server DTS nor Access anymore..

Hi,

SQL Server 2000 SP3
Windos 2000 Server SP4

I have a DTS package that imports data from a dBase IV databse with
files located in two folders (dBF1 and dBF2). I use a transform data
task to transform the data.

They were running properly, but last week we installed W2K SP4, and
now the transform task for files from dBF2 are not working properly.

I have two tranform tasks to extract data from files in dBF2 folder.
If I double click to open the transform data task of either of them,
Enterprise Manager crashes with the errror

mmc.exe applicatio Error
The instruction "xxxx" referenced memory at "xxx". The memory could
not be read.

Althoug the transform task for one of the files will run, the other
will not run giving the message

Error Source: DTS package
Catastrophic failure

Also, I have an Access database that has links to the same dBase
files. For files from dBF2 folder, I'm able to see the data from one
of the files, but if I double click to see the data from the other,
access crashes with no specific error message. Nothing has changed on
dBase related files (permission wise).

The transform tasks to extract data from the other dBase folder (dBF1)
files are working fine, and data is accesible from Access.

Any advice how to tackle this one?
Jul 20 '05 #1
2 5506
Hi

This sounds as if the file is corrupt in some way. Can you open it and run
the dBase tools against it?

John

"Ivan" <i.*******@warwick.ac.uk> wrote in message
news:2b**************************@posting.google.c om...
Hi,

SQL Server 2000 SP3
Windos 2000 Server SP4

I have a DTS package that imports data from a dBase IV databse with
files located in two folders (dBF1 and dBF2). I use a transform data
task to transform the data.

They were running properly, but last week we installed W2K SP4, and
now the transform task for files from dBF2 are not working properly.

I have two tranform tasks to extract data from files in dBF2 folder.
If I double click to open the transform data task of either of them,
Enterprise Manager crashes with the errror

mmc.exe applicatio Error
The instruction "xxxx" referenced memory at "xxx". The memory could
not be read.

Althoug the transform task for one of the files will run, the other
will not run giving the message

Error Source: DTS package
Catastrophic failure

Also, I have an Access database that has links to the same dBase
files. For files from dBF2 folder, I'm able to see the data from one
of the files, but if I double click to see the data from the other,
access crashes with no specific error message. Nothing has changed on
dBase related files (permission wise).

The transform tasks to extract data from the other dBase folder (dBF1)
files are working fine, and data is accesible from Access.

Any advice how to tackle this one?

Jul 20 '05 #2
Thanks John for your reply,

The dBase files are fine. They are from the CRM application. Also,
They are all accesible from an NT 4 workstation with Access 97.

I wonder if it's the jet 4 files the ones are corrupt.. not sure if I
should just install jet 4 SP7 again. would the previos isntallation be
overwritten? is it possible to install a lower version of Jet 4 on a
Jet 4 SP7 isntallation?

I can't unistall W2K SP4 and go back to previous OS state as I didn't
archived the files....

Thanks,
Ivan

"John Bell" <jb************@hotmail.com> wrote in message news:<3f*********************@reading.news.pipex.n et>...
Hi

This sounds as if the file is corrupt in some way. Can you open it and run
the dBase tools against it?

John

"Ivan" <i.*******@warwick.ac.uk> wrote in message
news:2b**************************@posting.google.c om...
Hi,

SQL Server 2000 SP3
Windos 2000 Server SP4

I have a DTS package that imports data from a dBase IV databse with
files located in two folders (dBF1 and dBF2). I use a transform data
task to transform the data.

They were running properly, but last week we installed W2K SP4, and
now the transform task for files from dBF2 are not working properly.

I have two tranform tasks to extract data from files in dBF2 folder.
If I double click to open the transform data task of either of them,
Enterprise Manager crashes with the errror

mmc.exe applicatio Error
The instruction "xxxx" referenced memory at "xxx". The memory could
not be read.

Althoug the transform task for one of the files will run, the other
will not run giving the message

Error Source: DTS package
Catastrophic failure

Also, I have an Access database that has links to the same dBase
files. For files from dBF2 folder, I'm able to see the data from one
of the files, but if I double click to see the data from the other,
access crashes with no specific error message. Nothing has changed on
dBase related files (permission wise).

The transform tasks to extract data from the other dBase folder (dBF1)
files are working fine, and data is accesible from Access.

Any advice how to tackle this one?

Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Scott Tilton | last post by:
I am having a terrible time getting this to work. I am hoping someone out there can help me with very specific code examples. I am trying to get the linked tables in my Access 97 database to be...
20
by: Steve Jorgensen | last post by:
Hi all, I've just finished almost all of what has turned out to be a real bear of a project. It has to import data from a monthly spreadsheet export from another program, and convert that into...
3
by: Peter Afonin | last post by:
Hello, Our SQL server used to run under System account, and I had no problems executing DTS packages from the ASP.NET: Dim oPkg As DTS.Package oPkg = CreateObject("DTS.Package")...
8
by: Vishal | last post by:
Hello, I need to import data from a excel file into a SQL Server. I would like to provide an asp.net interface for that purpose. What would be the best to do that? A simple textarea where the...
3
by: Rob Hughes | last post by:
(This is a crosspost from .data for greater exposure) I am writing an external app that utilizes. The app needs to be able to run repeatedly, but I am having a problem because Access will not...
2
by: Mark S | last post by:
I'm basically a database noob hoping to find a shortcut if at all possible. I've created an ER diagram for a site I plan to build and have used that to create the database in MS SQL 2000. Now...
24
by: dancer | last post by:
Using ASP.net 1.1 and Microsoft Access. I received the following error message. Why? I have closed the Access file. I have another very small access file that opens with no trouble with the...
6
by: provor | last post by:
Hello, I have the following code that I am using when a user presses a button to import an excel file into a table. The code is hard coded to point to the correct table. This works great for this...
3
by: cvalle | last post by:
A little about me... Iíve build a few Access dbases but I consider myself a novice. I have never inherited someone elseís Dbase. The dbase is not password protected, but I cannot access all of the...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.