Very Computer

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
server).

        **************************************

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
Location: C:\Data\Bindery.mdb

Destination: Microsoft SQL Server
Using Microsoft OLE DB Provider for SQL Server
Location: OEMCOMPUTER
Database: MKBindery

Tables
CUSTOMER -> [MKBindery].[dbo].[CUSTOMER]
OBSOLETE_TITLES -> [MKBindery].[dbo].[OBSOLETE_TITLES]
POTENTIAL_CUSTOMERS -> [MKBindery].[dbo].
[POTENTIAL_CUSTOMERS]
SALES -> [MKBindery].[dbo].[SALES]
SLSPERS -> [MKBindery].[dbo].[SLSPERS]
TITLES -> [MKBindery].[dbo].[TITLES]

9) I click the &#8220;Finish&#8221; 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?  

Quote:> 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
> server).

> **************************************

> 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 &#8220;MS Access&#8221; 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
> Location: C:\Data\Bindery.mdb

> Destination: Microsoft SQL Server
> Using Microsoft OLE DB Provider for SQL Server
> Location: OEMCOMPUTER
> Database: MKBindery

> Tables
> CUSTOMER -> [MKBindery].[dbo].[CUSTOMER]
> OBSOLETE_TITLES -> [MKBindery].[dbo].[OBSOLETE_TITLES]
> POTENTIAL_CUSTOMERS -> [MKBindery].[dbo].
> [POTENTIAL_CUSTOMERS]
> SALES -> [MKBindery].[dbo].[SALES]
> SLSPERS -> [MKBindery].[dbo].[SLSPERS]
> TITLES -> [MKBindery].[dbo].[TITLES]

> 9) I click the &#8220;Finish&#8221; 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?

I had the same problem. After several tries, I just decided to write some VB
code in Access to read the data into my development SQL Server 7.0 tables. I
used the same code just before launching the production database (I only had
to change the table prefix, which I did with global replace).

Hope this helps!
Edward