MSDE 2000 Release A

I want to export or import from MSDE 200 Rel A to Access2003/2000. How can I
do ? Thank alot
hi Quang Hanh,
Quang Hanh wrote:
> I want to export or import from MSDE 200 Rel A to Access2003/2000.
> How can I do ? Thank alot
you can have a look at sp_addlinkedserver system stored procedure...
you can add a linked server pointing to the Access database like following,
where a pesudo copy of the original JET table is created an populated from
the original data
SET NOCOUNT ON
USE master
GO
-- adding linked server
EXEC sp_addlinkedserver
@.server = 'my_JET_db',
@.provider = 'Microsoft.Jet.OLEDB.4.0',
@.srvproduct = 'OLE DB Provider for Jet',
@.datasrc = 'D:\NWIND.MDB' -- point to Nortwind JET database
GO
-- use your database.. here just define a new table in tempdb
USE tempdb
GO
CREATE TABLE dbo.MSDE_customers (
CustomerID VARCHAR(60) PRIMARY KEY ,
CompanyName VARCHAR(60) ,
ContactName VARCHAR(60) ,
ContactTitle VARCHAR(60) ,
Address VARCHAR(60) ,
City VARCHAR(60) ,
Region VARCHAR(60) ,
PostalCode VARCHAR(60) ,
Country VARCHAR(60) ,
Phone VARCHAR(60) ,
Fax VARCHAR(60)
)
GO
PRINT 'SELECT from the linked server Jet database'
SELECT TOP 10 * FROM my_JET_db...Customers
PRINT 'Import rows to the MSDE database via INSERT INTO'
INSERT INTO dbo.MSDE_customers SELECT * FROM my_JET_db...Customers
PRINT ''
PRINT 'SELECT from the MSDE database'
SELECT TOP 10 * FROM dbo.MSDE_customers
GO
-- cleanup
DROP TABLE dbo.MSDE_customers
GO
USE master
go
EXEC sp_dropserver 'my_JET_db', 'droplogins'
further information and relative synopsis about sp_addlinkedserver system
stored procedure can be found at
http://msdn.microsoft.com/library/de..._adda_8gqa.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

MSDE 2000 Rel A Installation Failure

try install previuos version of msde 2000 rel a, and update with sp3.
"chris fearnley" <anonymous@.discussions.microsoft.com> escreveu na mensagem
news:3D93D00C-1AAD-427F-905C-26533B3388F6@.microsoft.com...
> I have the same problem. I am trying to do test installtions of MSDE 2000
Release A on several systems, along with our own app which uses .NET. About
half the PCs halt the installation, usually when there is '7 seconds left'
and just hang. Same problem on XP SP1 and even old Win98 SE.
all right, see the 320873 article from microsoft's knowledge base to
manually remove a msde. since you don't have msde installed anymore, looking
for the key in registry and delete them.
after that, try to install msde 2000 (not msde 2000 rel a) and sp3.
"Joe Schillace" <anonymous@.discussions.microsoft.com> escreveu na mensagem
news:B835C284-FF56-4A3E-82F3-E467218FAF03@.microsoft.com...
> Adriano:
> The previous version of MSDE that I had installed was from MS Office 2000.
It appears that it installs SQL 7.
> I re-installed this version and it went in without a hitch. I then tried
installing SP3a.
> It got to about 3 or 4 seconds left and then rolled back. The setup log
indicates a failed installation.
> It seems that MSDE 2000 Rel A left some scraps in the windows registry. I
searched for "microsoft sql server" and found more than a hundred. I can't
tell from the log file which entry is causing the problem.
> I have deleted the microsoft sql server folder and ran regclean, hoping it
would remove the orphans. But, I am still having the problem.
|||Just found some more info to help solve previous posting.
There is an error line in the install log file:
......
Executing "G:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MSSQLSERVER" -Q "Latin1_General_CI_AS""
Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.
Action ended 10:43:17: InstallFinalize. Return value 3.
......
...and in the error log from the newly-crtated SQL folder: (created by cnfgsvr?)
.....
2004-05-28 10:41:11.83 spid3 Default collation successfully changed.
2004-05-28 10:41:11.93 spid3 Recovery complete.
2004-05-28 10:41:11.93 spid3 SQL global counter collection task is created.
2004-05-28 10:41:12.64 spid3 Warning: override, autoexec procedures skipped.
2004-05-28 10:42:58.51 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.
(that was the last line in the log)
Note the time delay between the last 2 entries.