MSDE Question - Microsoft SQL Server

Steve Bishop

Hope MSDE questions ok here. I would like to distribute a MSDE
application on CD ROM. I don't have any of the packaging solutions i.e.
Visual Studio, Office Developer or VB Pro. I'm using MS Web Matrix to
build an ASP.Net front for MSDE.

How distributable is MSDE without the additional distribution products?

Would I need to load up MSDE from the CD Rom then execute some long
scripts to build my tables and stored procs I use in the application?
Should I just get one of the professional development products listed
above and use the distribution tools?

Help / Input appreciated.
Steve

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 20 '05 #1

Subscribe Post Reply

1689

Simon Hayes

"Steve Bishop" <st****@viper.com> wrote in message
news:40*********************@news.frii.net...

Hope MSDE questions ok here. I would like to distribute a MSDE
application on CD ROM. I don't have any of the packaging solutions i.e.
Visual Studio, Office Developer or VB Pro. I'm using MS Web Matrix to
build an ASP.Net front for MSDE.

How distributable is MSDE without the additional distribution products?

Would I need to load up MSDE from the CD Rom then execute some long
scripts to build my tables and stored procs I use in the application?
Should I just get one of the professional development products listed
above and use the distribution tools?

Help / Input appreciated.
Steve

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You can install MSDE using just a command line - check the readme for the
latest MSDE download, which lists all the parameters to setup.exe.

After you install it, you can run your object creation scripts with
osql.exe, or possibly include a database backup and simply restore it, which
is quick and easy, although of course you have no flexibility to create
objects conditionally.

I'm not familiar with the packaging tools you mention - you might get better
information in a .NET or ASP forum.

Simon

Jul 20 '05 #2

Similar topics

Replication with MSDE

by: Craig HB | last post by:

I have a distributed inventory control database that I am going to migrate from Access to SQL Server. I am going to use SQL Server Replication to keep the data current. There will one SQL Server...

Microsoft SQL Server

MSDE Question

by: Steve Bishop | last post by:

Hope MSDE questions ok here. I would like to distribute a MSDE application on CD ROM. I don't have any of the packaging solutions i.e. Visual Studio, Office Developer or VB Pro. I'm using MS Web...

Microsoft SQL Server

MSDE 2000 Release A won't talk

by: noname | last post by:

MSDE 2000 Release A installed under windows 2000 pro will not communicate with SQL Server Manager nor MS Access on peer computer. Can someone help? Have set DISABLENETWORKPROTOCOLS=0 at install...

Microsoft SQL Server

msde

by: JIMMIE WHITAKER | last post by:

Can MSDE be used on computer in different cities? Say the server in Dallas and the client computer in Houston. Or is the full SQL Server required?

Microsoft SQL Server

Converting database to MSDE

by: Rosy Moss | last post by:

I am in the process of cleaning up a database that our company uses to track jobs, time and expense, and customer information. We are running Windows 2000 Server with approximately 20 terminals...

Microsoft Access / VBA

Jet or MSDE

by: NB | last post by:

Hi I have been developing on MS Access / Jet / VBA platform for about 2 years. The current project I am working on for a small business is built on Access 2002. It has about 53 tables in 2...

Microsoft Access / VBA

Considerations for packaging MSDE app

by: Paul Aspinall | last post by:

Hi I have a C# Winform app which runs using SQL Server. I want to package up the app, so that it deploys with MSDE. Can anyone offer any pointers or references to help?? Thanks

C# / C Sharp

MSDE Authentication

by: Anthony P. Mancini | last post by:

Does anyone know how to make the MSDE do SQL authentication ? It appears to authenticate using Windows at all times. Thanks, Anthony

ASP.NET

Problem: Performance difference between MSDE and SQL Express 2005

by: HC | last post by:

Hello, all, I started out thinking my problems were elsewhere but as I have worked through this I have isolated my problem, currently, as a difference between MSDE and SQL Express 2005 (I'll just...

Microsoft SQL Server

Access Europe meeting on Wed 2 August - An Access Developer Guide to creating applications in Blazor

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

How to Use CodiumAI's pr-agent?

by: erikbower65 | last post by:

Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...

General

Speedup your spring application

by: linyimin | last post by:

Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...

General

Steps manually installing IntelliJ IDEA.

by: erikbower65 | last post by:

Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...

General

Development of Funny H5 Game - Toy Claw

by: kcodez | last post by:

As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...

HTML / CSS

How to insert a new record in a database

by: Taofi | last post by:

I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...

DB2 Database

Cancel Print Action if Sub form has No Records

by: DJRhino1175 | last post by:

When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...

Microsoft Access / VBA

Python code for finding the longest common subsequence

by: Rina0 | last post by:

I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...

Python

Windows 11 and Access Combo Box Issue

by: DJRhino | last post by:

Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

Microsoft Access / VBA