Re: FP2003 & Databases: MSDE, MYSQL, SQL

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Kevin Spencer (kevin_at_takempis.com)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 10:25:10 -0500

In addition, I might mention that MySql certainly IS supported by
FrontPage, as well as all other ODBC-compliant or OLE DB-complaint
databases. 

-- 
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
"Jon" <js@roksteady.net> wrote in message
news:#1tkGrqBEHA.2404@TK2MSFTNGP11.phx.gbl...
> Hi Jim,
> you know MSDE will be throttled when you have more than 5 connections -
> wether this is acceptable to you obviously depends on your app
>
> The easiest way to get a .csv file into sql server is to use bulk insert
(I
> assume this would work on MSDE too, no idea about mysql) All you need to
do
> is choose your row and column delimiters. So if you had commas delimiting
> columns and new line
> delimiting rows you could do something like this
>
> BULK INSERT YourTable
>     FROM 'c:\file.csv'
>     WITH
>     (
>         FIELDTERMINATOR = ',',
>         ROWTERMINATOR = '\n'
>     )
>
> Run it and your data's in - it's that simple.
>
> Unless you're hosting yourself you should only need to purchase the
> developer edition of sql server which is only $49.95, it's that cheap
> because you can't use in production. If you're hosting yourself the cost
of
> sql server may well be prohibitive - cerainly into the thousands of
pounds -
> an alternative in this scenario might be to sign up with a host just for
sql
> server. From your post it doesn't sound to me as though MSDE is going to
> much use to you. I can give you plenty of info regarding sql server but
> nothing about mysql - you  might want to ask this same question in a mysql
> newsgroup to get some decent opinions about that product.
>
> Jon
> Microsoft MVP - FP
>
>
>
> Jim Clouse wrote:
> > I am using FP2003 to build XML database-driven websites.  What I need
> > is help getting our raw datasource information (which unfortunately
> > is .csv files) into MSDE.  These .csv datafiles are updated daily and
> > I want to update the MSDE dynamically daily.
> >
> > One method would be to convert these .csv files into MSDE directly.
> > Does anyone know the best & simplest way to do this?
> >
> > Another method would be to convert the .csv files first into MYSQL
> > (which is not supported in FP2003) and then convert that file into
> > MSDE.  Does anyone know the best & simplest way to do this?  Is there
> > a way to link this MYSQL database into MSDE?
> >
> > Or am I best served by going ahead and purchasing SQL, especially
> > given the limitations of MSDE's with the number of concurrent users
> >
> > Any assitance you can give me on how to most efficiently do this
> > would be greatly appreciated.
> >
> > Thanks!
> >
> > JWC
>
>

Relevant Pages

  • RE: How to configure WSS to use SQL server instead of MSDE
    ... This is why, in this post, I wanted to focus on only WSS features. ... Apparently WSS DOES NOT SUPPORT SQL Server since it has no tool (that we ... >>MSDE databases for its configuration and content ...
    (microsoft.public.sharepoint.windowsservices)
  • Cannot insert explicit value for identity...
    ... I am developing an integration process between two databases. ... The main database is the SQL Server, the MSDE will contain a really ...
    (comp.databases.ms-sqlserver)
  • Re: Newbie Questions
    ... I have noticed that some of the documentation talkes about SQL Server ... > MSDE is the old database engine there is now as well SQL server Express, ... > hard to find (mostly everything is done with scripting ASP style). ... How do I use the MSDE functionality in relation to databases? ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Change default to named instance??
    ... Take a backup of all databases ... Stop SQL Server and copy the MDF and LDF to a safe place ... Un Install the MSDE ... > conflicts with other app's msdes, I now want to use a named instance. ...
    (microsoft.public.sqlserver.msde)
  • Re: Relocate MSDE 2000 database?
    ... Most of the 2000 versions of SQL Server and thus MSDE have been pulled. ... It can be purchased for about $40 and can manage any version of SQL Server. ... It will be increasingly expensive to support no-supported databases as time goes on. ... post -- these databases are installed and deployed by 3rd party apps ...
    (microsoft.public.sqlserver.msde)