MSDE 2000 shipped to the Republic of Czech

Are there any export restrictions, etc. for MSDE 2000 in
the Republic of Czech? In the EULA for MSDE 200 it states
that in most cases local laws applies. I went to the
Exporting page for Microsoft, but could not find anything
definitive. Thanks in advance for your assistance.
CCS
Our Czech firm wide uses MSDE 2000 in the Czech Republic and Poland.
I do not know about any local restriction for MSDE 2000 in the Czech
Republic. We
use it according to the Microsoft EULA.
IH
"CCSGrayTech" <anonymous@.discussions.microsoft.com> pse v diskusnm
prspevku news:2ce201c47e2a$7a9b2290$a401280a@.phx.gbl...
> Are there any export restrictions, etc. for MSDE 2000 in
> the Republic of Czech? In the EULA for MSDE 200 it states
> that in most cases local laws applies. I went to the
> Exporting page for Microsoft, but could not find anything
> definitive. Thanks in advance for your assistance.
> CCS

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 - Problems connecting using SQL Authentication

I'm trying to use the import/export part of MSDE. When I choose to connect to the server via Windows NT Authentication, everything works fine, assuming I have a connection to the server open (ie VPN connection).

When I chooose SQL Server Authentication, I get the following error:

Client unable to establish connection [CBNMPNTW] ConnectionOpen(CreateFile()).

I need to be able to connect using sql server authentication. Can anyone help me?

Thanks,
StephanieRE:
I'm trying to use the import/export part of MSDE. When I choose to connect to the server via Windows NT Authentication, everything works fine, assuming I have a connection to the server open (ie VPN connection). When I chooose SQL Server Authentication, I get the following error: Client unable to establish connection [CBNMPNTW] ConnectionOpen(CreateFile()). I need to be able to connect using sql server authentication. Can anyone help me?
Thanks,
Stephanie

Q1 Can anyone help me?
A1 Possibly, more information would be helpful and is probably quite necessary. You may well have more than one issue, i.e.(Are you using DSNs, do you have a local DSN(s) configured to use TCP/IP instead of Named Pipes, are you able to tracert / ping your MSDE server with and / or without Windows NT Authentication via your VPN, is your VPN Win NT authentication based, etc., etc.,?).

MSDE - moving a copy of a database and reloading onto another PC

I need to the best way to make a copy(Backup/export) of the data base put in on a CD or e-mail it. Have instructions to import or restore the database onto another PC.
Also in the C:\Program Files\Microsoft SQL Server\80\Tools\Binn>
What and how does dtsrun.exe work?
Thanks
These articles might help ..
314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546
240872 HOW TO: Resolve Permission Issues When You Move a Database Between
http://support.microsoft.com/?id=240872
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
|||These articles might help ..
314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546
240872 HOW TO: Resolve Permission Issues When You Move a Database Between
http://support.microsoft.com/?id=240872
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

MSDE - moving a copy of a database and reloading onto another PC

I need to the best way to make a copy(Backup/export) of the data base put in on a CD or e-mail it. Have instructions to import or restore the database onto another PC.
Also in the C:\Program Files\Microsoft SQL Server\80\Tools\Binn>
What and how does dtsrun.exe work?
Thanks
Please refer to these articles that might help -
314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546
240872 HOW TO: Resolve Permission Issues When You Move a Database Between
http://support.microsoft.com/?id=240872
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
|||Please refer to these articles that might help -
314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546
240872 HOW TO: Resolve Permission Issues When You Move a Database Between
http://support.microsoft.com/?id=240872
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.