Re: sql server compact edition

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


"Paul Clement" <UseAdddressAtEndofMessage@xxxxxxxxxxxxxx> wrote in message
news:kecou2l958omg0vkg698a19oohpss5t81l@xxxxxxxxxx
On Wed, 28 Feb 2007 10:56:57 -0800, "bz" <nospam@xxxxxxxxx> wrote:

¤ > ¤ >> just a VB6-Client-App running on XP.
¤ > ¤ >>
¤ > ¤ >> This is the flow:
¤ > ¤ >> 1) send client the app to use
¤ > ¤ >> 2) client fill up the database
¤ > ¤ >> 3) client email me back the database
¤ > ¤ >> 4) load the client database to Oracle.
¤ > ¤ >
¤ > ¤ > Then you should work either with ADO/JET
¤ > ¤ > against an *.mdb-File (XP normally comes with
¤ > ¤ > the JET-Engine and ADO preinstalled) - or you
¤ > ¤ > use an SQLite-Combination (requires only one or
¤ > ¤ > two Dll-Binaries) at the Clientside, wich is also
¤ > ¤ > capable, to accumulate all "Tables" in one
¤ > ¤ > single File.
¤ > ¤ >
¤ > ¤ > Olaf
¤ > ¤ >
¤ > ¤ >
¤ > ¤
¤ > ¤ Can I use Sql Server Compact Edition instead?
¤ > ¤ Do you know how to use it with VB6?
¤ >
¤ > You might want to check the below link. There should be a VB 6.0
example
¤ > that uses the OLEDB
¤ > provider:
¤ >
¤ > http://blogs.msdn.com/sqlservercompact/
¤ >
¤ >
¤ > Paul
¤ > ~~~~
¤ > Microsoft MVP (Visual Basic)
¤
¤ Thanks. The example works.
¤
¤ But I still don't know how to connect the SDF file from Enterprise
Manager
¤ (or Access) to create/modify the database.
¤
¤ I usually use Visio to build my database. I still don't know how to do
this
¤ for SDF file.
¤
¤ So... I think I will stick with Access.

You have to use the SP2 version of Microsoft SQL Server Management Studio
Express for SSCE.

http://www.microsoft.com/downloads/details.aspx?FamilyID=6053C6F8-82C8-479C-B25B-9ACA13141C9E&displaylang=en


Paul
~~~~
Microsoft MVP (Visual Basic)


Got it! Thanks!

But... (how comes there is always a "but"??!!)

It doesn't work with SQL 2000. The Relationship Diagram from 2000 doesn't
work with Management Studio.



.

Relevant Pages

  • Re: VB6, VB2005, or Something Else?
    ... By the way, the preformance of Gosub in PCode was quite good, it ... ¤ ... I'm not complaining about the necessary changes, ... that Microsoft intentionally and unnecessarily made it more difficult. ...
    (microsoft.public.vb.general.discussion)
  • Re: Rolling the dice on vb6
    ... Stefan Berglund wrote: ... ¤ Yep, long gone. ... Let us say that Microsoft could write a real VB6 -> Fred ... MS could have had their business, could have had my business, and they ...
    (microsoft.public.vb.general.discussion)
  • Re: VB6, VB2005, or Something Else?
    ... It seems to me that you are a proponent for the .net framework, ... Relating to the above 4 items: A small company selling software such as us ... Relating to the above 4 items: Can't Microsoft: ... ¤>we are. ...
    (microsoft.public.vb.general.discussion)
  • Re: Using MS Access in ADO.NET - coming from VB6
    ... ¤ for the Compact Edition. ... They just release RC1. ... Microsoft MVP ... still seeing SQL Server Mobile listed in the SQL Server Management Studio ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: VB6, VB2005, or Something Else?
    ... ¤ Duh! ... Microsoft MVP ... GoSub is a bit dated - but no reason to kill it. ... possibly understand how a compiler or platform might work. ...
    (microsoft.public.vb.general.discussion)