VB.NET

setup.exe does not install sdf file

Please support our VB.NET advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Jul 2008

Posts: 42

Reputation: Bill Purkins is an unknown quantity at this point

Solved Threads: 1

Bill Purkins Bill Purkins is offline

Offline

Light Poster

setup.exe does not install sdf file

Dec 20th, 2008

Hi,

I am using Visual Basic 2008 Express Edition and published an application, and when I run the setup, it seems to install okay but when you run the program get an error message that the .sdf file is not found. I am using a Compact SQL database.

I have looked through various section of code but don't know what to change or where. Can anyone help?

Thanks in advance,
Bill Purkins

•

Join Date: Aug 2008

Posts: 710

Reputation: Teme64 will become famous soon enough

Solved Threads: 115

Teme64

Offline

Master Poster

Re: setup.exe does not install sdf file

Dec 22nd, 2008

Check that
1) SDF-file is really installed i.e. copied during installation
2) check your connection string. See Connection strings for SQL Server Compact Edition. Make sure your Data Source points to the SDF-file, which is installed by your customer (or the installer to be more precise). There may be just wrong drive letter or different path in the connection string

Teme64 @ Windows Developer Blog

•

Join Date: Jul 2008

Posts: 42

Reputation: Bill Purkins is an unknown quantity at this point

Solved Threads: 1

Bill Purkins Bill Purkins is offline

Offline

Light Poster

Re: setup.exe does not install sdf file

Dec 22nd, 2008

•

Originally Posted by Teme64

Check that
1) SDF-file is really installed i.e. copied during installation
2) check your connection string. See Connection strings for SQL Server Compact Edition. Make sure your Data Source points to the SDF-file, which is installed by your customer (or the installer to be more precise). There may be just wrong drive letter or different path in the connection string

Thanks for your response, I did look at the connection string and it appears to have no path specified, which to me would imply the current folder, no?
Thanks,
Bill Purkins

•

Join Date: Aug 2008

Posts: 710

Reputation: Teme64 will become famous soon enough

Solved Threads: 115

Teme64

Offline

Master Poster

Re: setup.exe does not install sdf file

Dec 22nd, 2008

Yes, it should be the current folder.
I suggest doing a simple FileExists test, if possible

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
Dim CurrentPath As String
CurrentPath = Application.StartupPath & "\"
If My.Computer.FileSystem.FileExists(CurrentPath & "<DBname>.sdf") Then
  MessageBox.Show("Database file exists", _
    "Exists", _
    MessageBoxButtons.OK, _
    MessageBoxIcon.Information)
Else
  MessageBox.Show("Database file not found", _
    "Exists", _
    MessageBoxButtons.OK, _
    MessageBoxIcon.Warning)
End If
Dim CurrentPath As String
CurrentPath = Application.StartupPath & "\"
If My.Computer.FileSystem.FileExists(CurrentPath & "<DBname>.sdf") Then
  MessageBox.Show("Database file exists", _
    "Exists", _
    MessageBoxButtons.OK, _
    MessageBoxIcon.Information)
Else
  MessageBox.Show("Database file not found", _
    "Exists", _
    MessageBoxButtons.OK, _
    MessageBoxIcon.Warning)
End If

with the installed application.