Results 1 to 6 of 6

Thread: Deploying SQL Compact with Inno

  1. Feb 3rd, 2008, 01:42 PM #1
    agmorgan
    agmorgan is offline

    Thread Starter
    Frenzied Member agmorgan's Avatar
    Join Date
    Dec 2000
    Location
    Lurking
    Posts
    1,383

    Deploying SQL Compact with Inno

    I have a fairly simple program that uses a small database so I decided use SQL Server Compact 3.5 even though my target is Desktop PCs and not mobile devices.
    I have the rest of my installation written using Inno Setup, but I am not sure what to do with the database.
    Do I have to distribute the SQLServerEv31-EN.msi file or is it possible to just distribute a few dlls?
    Help me with my PKR Hand History Tool
    AutoUpdater - ActiveX Control Format numbers to Significant Figures
    Delete Recent Projects from VB6 IDE Emulate Windows 95 Powertoys Regex in Excel
    Reply With Quote Reply With Quote
  2. Feb 3rd, 2008, 01:44 PM #2
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: Deploying SQL Compact with Inno

    From what I've heard you just need to distribute a few DLL's, and would recommend checking the readme file that came with it (or the MS knowledgebase) to find out which ones they are, and where they should be placed, etc.
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  3. Feb 3rd, 2008, 02:03 PM #3
    agmorgan
    agmorgan is offline

    Thread Starter
    Frenzied Member agmorgan's Avatar
    Join Date
    Dec 2000
    Location
    Lurking
    Posts
    1,383

    Re: Deploying SQL Compact with Inno

    Didn't occur to me to check the installation directory for a readme file!
    That does list the dlls, but more than you need (extra foreign language ones I think).
    Searching for the name of one of the dlls gave me my answer much quicker than hours of searching for "SQL compact deploy"!

    According to this page you need to deploy 7 dlls
    http://msdn2.microsoft.com/en-us/library/aa983326.aspx
    • sqlceca35.dll
    • sqlcecompact35.dll
    • sqlceer35EN.dll
    • sqlceme35.dll
    • sqlceoledb35.dll
    • sqlceqp35.dll
    • sqlcese35.dll
    Help me with my PKR Hand History Tool
    AutoUpdater - ActiveX Control Format numbers to Significant Figures
    Delete Recent Projects from VB6 IDE Emulate Windows 95 Powertoys Regex in Excel
    Reply With Quote Reply With Quote
  4. Feb 3rd, 2008, 03:51 PM #4
    szlamany
    szlamany is offline
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: Deploying SQL Compact with Inno

    Yes - I've seen that list of 7 DLL's before...

    Please keep us posted with how well the SQL CE behaved on your desktop installations - I would like to know for future reference myself!

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:     [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008
    Reply With Quote Reply With Quote
  6. Feb 3rd, 2008, 06:54 PM #5
    agmorgan
    agmorgan is offline

    Thread Starter
    Frenzied Member agmorgan's Avatar
    Join Date
    Dec 2000
    Location
    Lurking
    Posts
    1,383

    Re: Deploying SQL Compact with Inno

    You also need System.Data.SqlServerCe.dll
    This is in C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Desktop
    The other 7 dlls are in
    C:\Program Files\Microsoft SQL Server Compact Edition\v3.5
    Help me with my PKR Hand History Tool
    AutoUpdater - ActiveX Control Format numbers to Significant Figures
    Delete Recent Projects from VB6 IDE Emulate Windows 95 Powertoys Regex in Excel
    Reply With Quote Reply With Quote
  7. Feb 4th, 2008, 06:13 PM #6
    agmorgan
    agmorgan is offline

    Thread Starter
    Frenzied Member agmorgan's Avatar
    Join Date
    Dec 2000
    Location
    Lurking
    Posts
    1,383

    Re: Deploying SQL Compact with Inno

    I added this to my [Files] section in Inno
    Code:
    ;SQL Server Compact Edition 3.5 files
Source: C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\sqlcecompact35.dll; DestDir: {app}
Source: C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\sqlceer35EN.dll; DestDir: {app}
Source: C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\sqlceme35.dll; DestDir: {app}
Source: C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\sqlceoledb35.dll; DestDir: {app}; Flags: regserver
Source: C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\sqlceqp35.dll; DestDir: {app}
Source: C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\sqlcese35.dll; DestDir: {app}
Source: C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\sqlceca35.dll; DestDir: {app}; Flags: regserver
Source: C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Desktop\System.Data.SqlServerCe.dll; DestDir: {app}
    Interestingly, the program ran with only the following
    Code:
    ;SQL Server Compact Edition 3.5 files
Source: C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\sqlceme35.dll; DestDir: {app}
Source: C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\sqlceqp35.dll; DestDir: {app}
Source: C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\sqlcese35.dll; DestDir: {app}
Source: C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Desktop\System.Data.SqlServerCe.dll; DestDir: {app}
    Although, all I was doing was a few SELECT and UPDATE statements.
    Help me with my PKR Hand History Tool
    AutoUpdater - ActiveX Control Format numbers to Significant Figures
    Delete Recent Projects from VB6 IDE Emulate Windows 95 Powertoys Regex in Excel
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width