Ad:

VB.NET Discussion Thread
Unsolved
Views: 1777

Dec 20th, 2008

setup.exe does not install sdf file

Expand Post »

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

Similar Threads

spyware, adaware and viruses in Viruses, Spyware and other Nasties

Bill Purkins

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

42 posts
since Jul 2008

Permalink

Dec 22nd, 2008

Re: setup.exe does not install sdf file

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

Reputation Points: 218

Solved Threads: 201

Veteran Poster

Offline

1,024 posts
since Aug 2008

Permalink

Dec 22nd, 2008

Re: setup.exe does not install sdf file

Click to Expand / Collapse Quote 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

Bill Purkins

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

42 posts
since Jul 2008

Permalink

Dec 22nd, 2008

Re: setup.exe does not install sdf file

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

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.

Teme64

Reputation Points: 218

Solved Threads: 201

Veteran Poster

Offline

1,024 posts
since Aug 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: displaying the values in the combobox

Next Thread in VB.NET Forum Timeline: read FROM crystal reports in vb

DaniWeb Message

Cancel Changes

User Name
Password