Setup File - Developed A Software Using SQL Compact Edition Database (.sdf File)
Nov 15, 2011
I've developed a software using VB.Net and SQL compact edition database. (.sdf file) Now i want to add my .sdf file to setup file. I've search internet and create setup file. when i install the software, it is created new folders in program files including my database file and exe file. after double clicking exe file, it is open the software. but when using, it's shown a message "connection current state is closed". but when i run my vb project, it is working well.
Other details.
1) I create data base inside of /bin/debug
2) I've created setup file using this method. File menu --> add --> new project Then, Setup and deployment -> Visual studio installer After that I selected Setup project, then click OK.
3) I add database using this Right click on setup file -> add -> file (In solution explorer window) Then i selected my .sdf file.
This is my connection string
CODE:
It is created only 3 files in Program files.
1. my exe
2. my sdf file
3. System.Data.SqlServerCe.dll file
View 5 Replies
ADVERTISEMENT
Dec 2, 2010
I have made a SQL Server Compact Edition Database File (.sdf) and created tables inside. However as I am new to SQL Server I don't know how to connect to the database using VB .NET.Code I have now:
Dim sqlcn As New sqlconnection()
Dim sqldataset As New DataSet()
Dim sqlda As SqlDataAdapter[code].....
View 16 Replies
Apr 30, 2010
How i can make an installation file from a VB project developed in VB express edition 2008?So i can give it to someone and they can install it on their system.
View 1 Replies
Oct 15, 2009
Ive created one database Sql Server Compact Edition 2005, with one table ("Cliente") I know that I can created my database good, but i have a problem saving information since three textbox, in my table(With columns "Nombre" "Apellido" "Cliente". In my form there is a button save ("Guardar"). When I do click in my button appear the next message : "The column cannot contain null values. [ Column name = Nombre,Table name = Cliente ] " and happen the same with apellido and Id_Cliente. And this happen becouse my code cant save the information....
This is the code
Option Explicit On
Option Strict On
Imports System
Imports System.IO
Imports System.Data
[CODE]...
And the code for my button is:
Private Sub cmdguardar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdguardar.Click
Dim myconnection As SqlCeConnection
Dim mycommand As SqlCeCommand
[CODE]...
View 2 Replies
Feb 18, 2010
I am having trouble while installing Visual Basic 6.0 . Setup gives message
View 5 Replies
Mar 2, 2010
Friends I have Developed my Data base Project on vb6, using adodc and datagrid using ms access database file, it was working nice in vb6, I also put Search box there and used adodc1.recordsource="select * from table" sql query.
later i needed to convert it in vb.net I converted it, every thing is working fine, but one problem appears, an adodc's Recordsource query for searching records is not working, it only works if there is data in dataset (Datagrid),suppose once i pressed search button to search record and if no record found then dataset / datagrid becomes empty, now i wanted to search an other record with other name, but this time it does not work and following error appears Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
[Code]...
View 1 Replies
Apr 24, 2012
I'm doing a project with vb.net (smart device) on visual studio 2008 and I need to connect to a database on the device itself (I do not have a physical device to test, only emulation). How should I go about doing it? I would like the database to be in the device on start up.
View 1 Replies
Jun 27, 2012
i Have Used Database file for storing Data in my Application.Now I want to take backup of data in Access, Excel or in Any other Format.
View 1 Replies
Aug 7, 2009
Setup and deploy for my project worked fine for a while allowing you to install my program and uninstall the old version, but now it installs two entries. I don't get it, before I got it do do that it would give an error that it needed to be uninstalled first. Now like I said I get two entries in the programs uninstall window. RemovePreviousVersions = true. I change the version number and update the product code. Even tried changing the upgrade code. I just don't get why it doesn't work anymore, and its really annoying! Also, is there a way that the setup file can just be one .exe rather then a setup file and a data file?
View 2 Replies
Feb 4, 2010
I have a program that I need to import a csv file into sql database/tables.I am using Visual Basic 2008 express and sql server. When complete I have to distribute this to several users where they will have csv files in the same format but with unique data.It has been several years since I have done any programming and then it was vb6.I have quickly realized that my vb6 books are going to do me no good. I have spent an entire day watching tutorial and reading forums to no use.
The csv file is full of junk, where some of the records are 92 fields and some are 122. The fields have data that may have dozens of characters before and/or after the data that I need. On the good side I was able to pull the file into access and load it into two tables by using something along the lines of (where this = this, fill this table and the same for the second table.) So I have my 92 char records in one file and the 122 in another.Unfortunately though I can not use access to do this as many of the users do not have it. But by doing this I was able to work with the data in the file to get all of the fields set for name, length, type ect.So then I went into my vb project and created the database with two files.I set the fields up according to the information I got from the access tables. So I know that these two tables are a perfect fit for the data in this file.
What I need to be able to do is have the user browse through the program to find the csv file they will be using. If they have followed my directions, they should have placed it in the same folder as they program I will send them.I then need the program to take that file and import the data into my sql database/tables.I have come to the conclusion, given the condition of this file, that rather than try and clean it up before using it, it will make more sense to just get it loaded into the two tables.Then have my forms ect go and get the information that they need from the tables. Then after we are done using the records save them to a clean tables.
View 2 Replies
Dec 3, 2011
Im looking for some advice on the deployment of an application using SQL Compact Edition.My application will only be used by two people on two separate desktops with file sharing enabled.My goal is to deploy the application and have the .sdf file located on one of the desktops in a shared folder. So the other person using the app can connect to that database too.What is the best way to setup the deployment of this so that I can place the DB in lets say c:DBMyDB.sdf
View 5 Replies
Mar 15, 2011
I have developed an application, in vb.net, which uses the sql database to store some data. I have created the database using server explorer inside visual studio. Afterward I have created the setup wizard to install the application on to another computer but the problem is, I dont know how can I include my database file into the setup file
View 2 Replies
Oct 17, 2011
I'm development an application in vb 6.0 with SQLCE but when I try to make an update in a table I recive an error 3251 or -2147217887 (80040e21) [code]...
View 1 Replies
Dec 20, 2009
can the code below be modified for use with a SQL Server Compact edition DB? Public Function Querymode1(ByVal SpecifiedYear As String) As DataSet
'Dim DBConnection As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=charlyX;Persist Security Info=False;Data Source=c:mydata" & DBName)
Dim DBConnection As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=charlyX;Persist Security Info=False;Data Source=" & Trim$(MitsSetUpFile.MainDataLocation) & "" & MDBName)
[Code]...
View 1 Replies
Jan 8, 2011
I do one project in visual basic 2010.In visual basic 6 project can be make Package and deployment (setup file or install file) file using Package and deployment wizard.But in visual basic 2010 express edition does not have Package and deployment wizard.how to make Package and deployment (setup file or install file) file in visual basic 2010 project?
View 4 Replies
Apr 9, 2010
I have the requirement to create an application that has multiple front ends developed using Windows Forms, WPF, ASP and Compact Framework Mobile Forms.I would like to be able to create a series of obejct representing the business logic and have this logic accessible from the various front ends available. My first thought was to use remoting as I'd like to be able to pass the business objects back and forth between client and server but the compact framework doesn't support remoting and also transferring a full framework business object to a compact framework business object doesn't seem possible.My next thought was to use web services but again the passing of business objects seems to be very hard to accomplish. Without doing this I would have to create individual web methods for each business operation.
Finally my next option is to use sockets and write the whole client/server logic within some classes and expose them to the UI/Business layer. My only problem with this is it is not scaleable should the number of clients increase dramatically whereas using remoting or web services I can host the solution via ASP.Net.Does anybody have an ideas on the best way forward for this or even have any input on how they would write an application that required a windows form, wpf, asp website and mobile device GUI all of which want to use the same business logic?
View 3 Replies
Feb 21, 2012
I am trying to do multiple joins within a single query in SQL Server CE. I know that SQL Server CE doesn't support multiple SELECTs but I can't find any information on multiple INNER JOINs. I keep getting token errors on ProjectItemMaster (after the FROM) and the first INNER JOIN. Warning this is a big ugly query used to generate reports.
[Code]...
If I can't uses multiple INNER JOINs I can I break the query down into a number of different queries but I would prefer not to. So it is easier to maintain a SQL Server CE and an SQL Server version of the program.
View 1 Replies
Dec 1, 2011
I know to work with VB.net + crystal report + SQL server.But now i want to work with SQL server compact edition instead of SQL server.When we creating Crystal report it is asked provider in one moment. If we work with SQL server we select "Microsoft OLE DB provider for SQL server".I want to know
(Q1) what I should select as provider.
(Q2)After clicking next, it is asked SERVER. what should i typed. (When i use sql server i typed, "MyName-PC\SQLEXPRESS")
View 2 Replies
Aug 12, 2009
I have googled around for the connection string to connect with Sql Compact edition database. but i really have no idea how to do that. furthermore i dont know how to connect a form's fields to that database.
if i wana use ms sql server 2005 and dotn wana use sql compact edition then what i have to do?
View 1 Replies
Nov 12, 2011
I've developed a software using VB.net and SQL server 2005. This is the connection string that used. Data Source=MY-PC\SQLEXPRESS;Initial Catalog=studentInformation; Integrated Security=True But now i want to use SQL server compact edition. So what should i change in this connection string?
View 11 Replies
Jan 11, 2011
I have an application that is currently using DAO and would like to move it to ADO.Net. The problem I'm having is that when I do, I cannot do any queries that take variables if the database is Access or SQL Server Compact Edition. For example: SELECT RecipeName FROM tblMasterRecipe WHERE CategoryID = iCategoryID..The database is a local standalone database. Of course if I use the Standard SQL Server I can add parameters just fine using the TableAdapter Query Configuration Wizard. How do I do something similar for Access or SQL Server Compact Edition? The Create new stored procedure radio button is greayed out when the database is Access or SQL Server Compact Edition.
View 6 Replies
Mar 9, 2010
how to convert the .txt file to .shp file using visual basic 2008 express edition and the .shp file can read in ArcMap?
View 1 Replies
Jan 27, 2011
I am trying to compact a Access 97 MDB file. I have found and tried the following code
Private Sub CompactDB()
Dim jro As JRO.JetEngine
jro = New JRO.JetEngine()
jro.CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<DATAPATH>", _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<DATAPATH>;")
MsgBox("Finished Compacting Database!")
End Sub
This codes works and seems to compact the file and it appears in the destination folder but when i try to open the new file i get an error "Unrecognized database format 'DATAPATH'"Is there something i am doing incorrect? the database file sizes range from 5Mb to 100Mb+
View 13 Replies
Oct 14, 2010
[URL] to create my sqlite db file. I created it as a sqlite db version 3 file. When I go to open the connection
[Code]...
View 1 Replies
Sep 25, 2009
I have a compacting subroutine which basically call for MSAccess compacting[code]...
It runs without a problem in VB 2005 IDE, no problem at all. However, when I compiled it, and build the set up, and deploy it. It throws up this exception:
"Could not load file or assembly 'Interop.JRO, Version=2.6.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified."
View 3 Replies
Jan 25, 2012
I need to replace WebRequestFactory, what is this doing?
Public Shared Sub download_file()
Dim wr As HttpWebRequest = CType(WebRequestFactory.Create("http://www.test.com/test.jpg"), HttpWebRequest)
[Code]....
View 1 Replies
Feb 7, 2011
How can i compact my outlook 2007 pst file?
View 4 Replies
Jul 22, 2010
I created a SQL Compact Edition .sdf file in VB 2010 Express. I set the first column in the table as a Primary Key. But can I make use of it or am I limited to scrolling all the way through the file until I find the match I want? I managed to use a primary key with a SQL server .mdf file using the FindBy statement, though as a beginner, didn't really understand what I was doing so resorted to the more simple sdf file format to get me started. Goodness me there's so much to learn about data handling, it took me days to find out I didn't need a .Net provider in the connection string for Compact Edition.
View 3 Replies
Jun 10, 2011
im trying to creat a pocket pc application using visual basic. but i got problem access text file. system always shows that "counld not find a part of path". the code i wrote is like:
Imports System
Imports System.IO
Public Class Form1
[code]....
View 7 Replies
Aug 31, 2010
How can I include a batch file or an .exe file in my setup, that runs after setup is complete?
View 2 Replies
