I have copied an Access database into my C-Drive and now I
want use the DTS in SQL Server 7.0 to import the Access
database into SQL Server 7.0 running on Win 98 OS.
The SQL Server 7.0 is updated with SP3.
My instructor says it should work the same with Win 98.
He says at home he is running SQL Server 2000 on Win 98
and he did import the same database from Access to SQL
Server 2000. He added the courseware was originally
designed for SQL Server 7.0.
I use the following method to import the data. The same
method was used in my SQL class (SQL2000 on Win 2000
1) Right clicked the DTS Folder > All Tasks > Import Data
2) DTS main screen opens > Next
3) Choose a Data Source:
In the Source field I chose “MS Access” and in the File
Name I chose C:\Data\Bindery.mdb > Next
4) Choose a Destination:
Destination is default (Microsoft OLE DB provider for SQL
server), Server Default (OEMCOMPUTER), Use the SQL server
authentication (Radio button is ON)
I clicked the refresh button and chose <new> and typed in
the New Database name (MKBindery with Data file size 2 and
log file size 1) then OK. The (MKBindery) is visible in
my database dropdown menu > Next
5) Specify Table Copy or Query:
The Copy table(s) from the source database (radio button
is ON) > Next
6) Select Source Tables:
I chose Select All. All tables show a check mark next to
them. > Next
7) Save, Schedule and Replicate Package:
The (Run Immediately) is checked. > Next
8) Completing the DTS Wizard:
Source: Microsoft Access
Using Microsoft Jet 4.0 OLE DB Provider
Destination: Microsoft SQL Server
Using Microsoft OLE DB Provider for SQL Server
CUSTOMER -> [MKBindery].[dbo].[CUSTOMER]
OBSOLETE_TITLES -> [MKBindery].[dbo].[OBSOLETE_TITLES]
POTENTIAL_CUSTOMERS -> [MKBindery].[dbo].
SALES -> [MKBindery].[dbo].[SALES]
SLSPERS -> [MKBindery].[dbo].[SLSPERS]
TITLES -> [MKBindery].[dbo].[TITLES]
9) I click the “Finish” button. Nothing happens
10) The SQL server freezes and I have to use ctrl + alt +
delete to end the task and close the SQL.
Since I am running SQL Server 7.0 desktop edition on the
Win 98 the Named Pipes and Banyan Vines Server Net
Libraries cannot be installed. The desktop edition
database on Win 98 cannot accept connections using Server
Net-Libraries, but the client Net-Libraries can be used.
The default Client Configuration on my machine was [Named
Pipes] in the [SQL Server Client Network Utility] screen.
I changed it to TCP/IP, Multiprotocol and even NW Link
IPX/SPX and the result was the same as the above.
I have even Uninstalled and Reinstalled my SQL Server 7.0
four or five times with the same result.
What am I doing wrong?