How Do I Create A Database During Installation Of My C# Desktop Applicaton?
Nov 24, 2006
Dear all,
I have developed a C# desktop application which uses SQL express as its database. It works just fine as I installed the application, used SQL express Server Management Studio CTP to create database with tables , stored procedures etc.
Now, I want to create an installer that will not only install my application to other machines but also create the database with all the tables and stored procedures with it.
How do I do so? I searched the answer in several places but none worked out for me. Can anyone please help me on this??
For your convenience I'm giving the following informations:
Database name: NorthPoleSQL sever Name: IshtiaqueSqlexpress (used Windows Authentication Mode)
I have detached the database from the original machine and have the NorthPole.mdf and NorthPole_Log.ldf files. I want to use these files and create the database in target machine rather than writing sql scrips and executing them.
Please help me with a descriptive, step by step instruction as I am new to this technology.
Thank you.
-Ishtiaque
View 7 Replies
ADVERTISEMENT
Jan 21, 2006
I have searched through this forum and the news group
microsoft.public.sqlserver.ce
for this topic. I only find a post from Darren Shaffer and I requested a document.
Unfortunately, there is not a clear example of how to create a mobile database (sdf) on a desktop machine which contains VS 2005 and SQL server 2005 by using Visual Basic 2005.
I am sure a clear example in VB for this problem would help a lot of people. Hence anybody who knows how to perform this task, Please help these people.
Thanks in advance
Talat
View 1 Replies
View Related
Nov 30, 2005
Dear friends,
View 3 Replies
View Related
Jul 27, 2006
i have install vs2005 and wm5 sdk on my pc. i want to develop database application on my pocket pc (database = sqlserver 2005 express)
- i need to install another software on my pc or pocket pc ?
- how to start develop database application on my pocket pc?
thank you
View 1 Replies
View Related
Dec 23, 2006
how i can create a installation for my server database like the installation of examples northwind
I ask for how i can deploy my database
thanks
View 2 Replies
View Related
Feb 20, 2005
I am trying to use msde for the startup kits. but i cannot connect to it. How can I do a simple test to verify it is installed and that I can log into the db?
Thanks
Ron
View 1 Replies
View Related
Jul 27, 2006
I have SQL Server 2000 installed on my laptop and am trying to install an instance of MSDE. I keep getting the error message: "The installation of SQL Server 2000 Desktop Engine has failed. Please see the Getting Started manual for further instructions."
I have done this installation before on other machines. Something must be corrupt on my machine (?). The error message is not very enlightening. Any ideas?
View 6 Replies
View Related
Feb 6, 2008
There are special instructions for installing service packs on desktop edition installations -- command line options etc. How do you install hotfix roll-ups? Does build 2187 apply to desktop edition?
View 1 Replies
View Related
May 16, 2008
During installation of MSDE the installation hangs at "please wait while Windows configures microsoft sql server desktop engine" I always end up killing the installation process. I am trying to install Windows XPe dev kit and this is the step I am getting stuck on. If I try to skip this step and setup the database the setup obviously tells me that i dont have sql 200 or MSDE installed.
The KB article http://support.microsoft.com/kb/811479 describes the syptoms perfectly, but fast user switching isnt even enabled for this machine and is not the source of the problem.
View 8 Replies
View Related
Nov 7, 2005
I want to write a PC application that prepares a SQL Server Mobile Files (.SDF) and sends it to a PocketPC.
I get this error message:
View 47 Replies
View Related
Dec 5, 2005
Respected Sir
this thing I knew 2 year later, unfortunately forget and missplace
I want to not depend on sql server 2000 clients , can I include some dll s in my vb6 setup sothat I may not depend on sql server client to install all my clients
I want to add dependancy files of sql server in my deployment setup of application written in vb6 ans sql server
plz help me
Can anybody provide liste of these files
View 1 Replies
View Related
Sep 26, 2006
Dear All,
i have a question abt winCE 4.2 and SQL server CE.
i am using VB.net of Visual Studio 2005
My platform is using a PDA with winCE 4.2 and SQL server CE. The Host program is using dbf files on desktop side.
I got a problem of how to sync / read the sql CE data from a windows application.
so, i wanna ask,
1. any method to access the data from winCE data by windows application? or can i convert the sdf file to windows readable files? or any others?
2. Can i use a MDB to sync with SQL server CE?
can i synchronize the mobile device which has a SQL Server CE database with the Access database on the desktop?
last question,
3. is that windows CE .net 4.2 not support pocket access (cdb) anymore?
please help me out
View 1 Replies
View Related
Mar 27, 2008
Hi, I would create a vb2005 application that allow me to edit a sdf database stored into a pda connected at pc with activesyn directly on my desktop as well as "SQLCE Database View".
How can i do it??
Please help me
View 1 Replies
View Related
Jan 24, 2007
Please Help me!
I hav emulator Windows CE 4.0 with Visual Studio 2003, C#.
I want connect to sql server 2000......after read all posts of this subject and try all varieties modes of connecting string.....in sql profile i see that application in emulator try to connect the sql server but i have the same exception :
PlatformNotSupportedException
Here my code:
strcon = "Server = developer\devsql;Initial Catalog = master;User ID = domain\login; password = ******;Integrated Security = false";
What i did wrong or may be miss something?
View 1 Replies
View Related
Jun 19, 2007
I am dealing with an old ASP.NET 1.1 web app that I want to fix and
update. The existing site has an SQL database on the web host's SQL
server. I want to rip a complete copy of this database (it isn't large,
only 9MB) onto my desktop computer, so I can alter it and "bench test"
the changes I'm making to the overall application in VS2005.
Now, I have tried to yank a copy of this database and its structure
using GUI programs like Visual Studio 2005, SQL Studio Manager Express, and EMS SQL
Manager, none seem to offer a "Save As" option. While I can easily make changes to the database and its tables
on the web host's server (sql.hostname.net) with no problem, I can't
figure out how to pull a copy off of their server and onto my machine...
Does this problem have a very simple solution that I am overlooking?
Thank you for any advice!
View 1 Replies
View Related
Jun 24, 2007
I am thinking of using my web database as the database to use for my program, though not sure how feasible due to connection speeds and having to transfer that info.
what I am using as the connection string is
con.ConnectionString = "Data Source=databse ipadress inserted here; Initial Catalog=databasename here;Integrated Security=True"; with real data obviously inserted into the ip and tables, but when i try and send values there it just hangs and then crashes. I am thinking its not finding the database. Is there something else im to do?
I am using the exact same code as when i use my own machine as the server, and it works great that way, only thing different is the trying to send to the web server.
View 4 Replies
View Related
Oct 2, 2007
I am using SQL express and Visual web developer on windows Vista.
When I try to create a new database the following message appears.
CREATE DATABASE permission denied in database master (error 262)
I log on to my computer as an administrator.
Help appreciated
Prontonet
View 4 Replies
View Related
Nov 5, 1999
I am running 7.0 standard desktop on Workstation 4.0 and have run into a database size limitation of 10GB. I have all the newest
patches and have found no documentation that refers to a 10GB limitation. A September copy of VBA developer says that this edition
has a limitation of 4GB while the guides say that the Small Business Server edition would have a 10GB limitation. All other forms
of documentation say that there should be the standard mega-terabyte limit. I'm completely confused by this [lack of] documentation.
Any help???
View 2 Replies
View Related
Jun 7, 2006
I want to physically move my .SDF file to my desktop and then access this file from VS 2005 VB.NET. Ideally, I would want to access this .SDF file from MS Access 2003 but I undersand this is not possible.
Here are my VS 2005 VB.NET statements....
Dim ConnPPC As New System.Data.SqlClient.SqlConnection("Data Source = C:Documents and SettingsG014436My DocumentsSQL
MobileActMgr6CE.sdf")
Dim mySqlDataAdapter2 As New SqlDataAdapter("select * from T0002_AE_Activity_Entry", ConnPPC)
mySqlDataAdapter2.Fill(myDataSet2)
On executing the last statement(fill)...I get the following error.
function failed: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Does anyone have any suggestions?
View 6 Replies
View Related
Nov 1, 2006
The sample application provided with Access Database Synchronizer fires a "A request to send data to the computer running IIS has failed. For more information, see HRESULT." exception on my WinCE 4.2 device.
I debugged it with VS2005 to see what was going on and found that the problem resides in the line:
m_connDesktop.Pull("MSysObjects","SELECT Name FROM MSysObjects WHERE Type=1 and flags=0",accessSysConnectString,RDATrackOption.TrackingOff,"Err_MSysObjects");
It seems that connection m_connDesktop is ok but calling Pull method fails.
I've verified that SSEvAccessSync service is started when ActiveSync detects device connection and that firewall rules are correctly updated.
Also, i verified my System.mdw and i discovered that there is no "MSysObjects" table (only MSysGroupList, MSysGroupMembers, MSysUserList and MSysUserMemberships queries are there).
Do you think the problem is there?
How can i solve it without damaging System.mdw?
I cannot figure out what's the purpose of this line of code, can you help me?
View 8 Replies
View Related
Jan 31, 2008
Hello
I am writing a Desktop application accessing a SSCE database. I am running Windows XP SP2, VS2005 SP1, and have SQLServerCE3.1 installed. Debugging the application shows that ds.m_spInit->QueryInterface() returns E_NOINTERFACE. I have checked that SSCE runtime library is installed, IDBCreateSession uuid exists in the registry and m_spInit.CoCreateInstance(CLSID_SQLSERVERCE_3_0) return S_OK. Can you suggest me what need adding/installing to get the CSession.Open(datasource) working?
Thanks
Ares,
View 1 Replies
View Related
May 1, 2005
its sql server 7.0 and im looking for the service network utility and service manager that it didnt come with.. where can i download it?
View 1 Replies
View Related
Apr 4, 2006
Hi,
I am developing an application for a Pocket PC (PPC). I am using Visual studio 2005, and the Operating system on this PPC is Window Mobile 2003 SE. The followings are my codes to connect PPC with the database on my PC with sql server 2005. But when I cick the button1, the error with "SQL Server does not exist or access denied." Any ideas? Thanks a lot.
Imports System.IO
Imports System.Data
Imports System.Data.SqlClient
Imports System.Math
Imports System.Drawing
Imports System
Public Class Form1
Dim strConnection As String = "Server=localhost;Integrated Security=SSPI;database=AdventureWorks"
Dim strQuery As String
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Label1.Text = "Hello, Clicking after."
ReadOrderData()
End Sub
Private Sub ReadOrderData()
Dim queryString As String = "select * from Person.Address where AddressID < '10'"
Using connection As New SqlConnection(strConnection)
Dim command As New SqlCommand(queryString, connection)
connection.Open()
Dim reader As SqlDataReader = command.ExecuteReader()
While reader.Read()
MsgBox(String.Format("{0}, {1}", _
reader(0), reader(1)))
End While
reader.Close()
End Using
End Sub
End Class
View 15 Replies
View Related
May 17, 2007
Hi,
Actaully i want to install SQL SERVER 2005 Enterprise edition in the silent mode and I was tyring to create a response file (setup.iss), but from the document provided i saw that SQL SERVER 2005 Enterprise edition doesnt create response file, and doesnt support setup.iss. So please provide me some solution where i can generate response file or some thing which is similar to that.
View 4 Replies
View Related
Dec 17, 2007
I have a clustered server environment where three of the SQL Server local groups were not created during installation. One of these missing groups is SQLServer2005SQLAgentUser$ComputerName$InstanceName, and this is causing problems with trying to automate replication.
How do I create this group after I have installed SQL Server?
Thanks,
Neal
View 4 Replies
View Related
May 20, 2008
the subject pretty much says it all, I want to be able to do the following in in VB.net code):
{[If [table with this name] already exists [in this sql database] then [ don't create another one] else [create it and populate it with these values]}
How would I do this?
View 3 Replies
View Related
Jul 20, 2005
Can I dynamically (from a stored procedure) generatea create table script of all tables in a given database (with defaults etc)a create view script of all viewsa create function script of all functionsa create index script of all indexes.(The result will be 4 scripts)Arno de Jong,The Netherlands.
View 1 Replies
View Related
Jul 20, 2005
I have some code that dynamically creates a database (name is @FullName) andthen creates a table within that database. Is it possible to wrap thesethings into a transaction such that if any one of the following fails, thedatabase "creation" is rolledback. Otherwise, I would try deleting on errordetection, but it could get messy.IF @Error = 0BEGINSET @ExecString = 'CREATE DATABASE ' + @FullNameEXEC sp_executesql @ExecStringSET @Error = @@ErrorENDIF @Error = 0BEGINSET @ExecString = 'CREATE TABLE ' + @FullName + '.[dbo].[Image] ( [ID][int] IDENTITY (1, 1) NOT NULL, [Blob] [image] NULL , [DateAdded] [datetime]NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]'EXEC sp_executesql @ExecStringSET @Error = @@ErrorENDIF @Error = 0BEGINSET @ExecString = 'ALTER TABLE ' + @FullName + '.[dbo].[Image] WITHNOCHECK ADD CONSTRAINT [PK_Image] PRIMARY KEY CLUSTERED ( [ID] ) ON[PRIMARY]'EXEC sp_executesql @ExecStringSET @Error = @@ErrorEND
View 2 Replies
View Related
Mar 26, 2008
I'm new to using SSIS and have been reading and learning slowly how to use it. I'm trying to create an identical copy of our database for reporting. I've used the Import/Export wizard, but have had some issues with foreign keys and with sql_variant columns.
I've tried searching for anything but haven't had any luck as of yet. I guess I don't even know where to start or what to look for.
Any help would be appreciated. Thanks!
View 9 Replies
View Related
Aug 28, 2006
I have installed SQL Sever 2000 on my Windows XP Pro machine from theEnterprise Edition setup and it prompts you that only the client toolscan be installed. I wanted to have a local database as well So whatinstall should I have used to do so. Any information would greatly beappreciated.
View 2 Replies
View Related
Jun 3, 2006
I am trying to run one SQL Express database for two separate applications that will also use the Membership framework. My database is set up fine and works between both applications 100% as needed with the exception of Membership which I am fairly new to.
From my understanding given the following link
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/PAGHT000022.asp
I need to install membership on the database. So I did the following
(allow remote connections with TCIP/IP and named pipes)
Started SQL and even re-booted
Ran: aspnet_regsql.exe -E -S localhost -A m
I even tried to run it by replacing localhost with MSSQL$SQLEXPRESS
All attempts gave me an error saying it could not connect and most likely because remote connections is disabled.
I think the reason for all this is because I don’t actually have the “real� IIS installed but rather I am using the instantiated version that automatically comes up when starting a ASP.NET 2.0 application.
I am assuming I need to set everything up such that I am using the real IIS rather then the default one in visual studio.
Is this correct? Or do I have something else?
View 2 Replies
View Related
Jul 11, 2001
Hi everyone,
HELP!
I was wondering if someone could help me. I need to re-install the SQL Server (due to a registry corruption). What I plan to do is to:
- Detach all databases (including master, pubs, and tempdb)
- Copy databases to a different folder
- Uninstall SQL Server
- Reinstall SQL Server
- Copy the databases back
- Reattach all databases
Will that preserver all the security? (e.g. syslogins and sysxlogins) Will using an old "master" database on a new install pose any problems?
Any help will be GREATLY appreciated. Please email me at vchai@artinmotion.com
Thanks,
Vincent Chai
View 3 Replies
View Related
Feb 20, 2008
Hello, I am very new to SQL Server. I have downloaded the SQL Server 2005 Express from microsoft's website and installed it on Windows Vista. I have also downlaoded the sample databases like pubs, northwind from http://www.microsoft.com/downloads/details.aspx?FamilyId=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en and adventure works from the respective site. When i try to run the script of pubs and northwind, it generates error messages and it is as follows:
Msg 911, Level 16, State 1, Line 2
Could not locate entry in sysdatabases for database 'pubs'. No entry found with that name. Make sure that the name
is entered correctly.
Msg 262, Level 14, State 4, Procedure sp_dboption, Line 0
SHOWPLAN permission denied in database 'master'.
Msg 262, Level 14, State 4, Procedure sp_addtype, Line 0
SHOWPLAN permission denied in database 'master'.
Msg 2715, Level 16, State 7, Line 2
Column, parameter, or variable #1: Cannot find data type id.
Msg 2715, Level 16, State 7, Line 2
Column, parameter, or variable #1: Cannot find data type tid.
Msg 2715, Level 16, State 7, Line 2
Column, parameter, or variable #1: Cannot find data type id.
Msg 2715, Level 16, State 7, Line 2
Column, parameter, or variable #6: Cannot find data type tid.
Msg 2715, Level 16, State 7, Line 2
Column, parameter, or variable #1: Cannot find data type tid.
Msg 2715, Level 16, State 7, Line 2
Column, parameter, or variable #1: Cannot find data type empid.
Msg 8197, Level 16, State 4, Procedure employee_insupd, Line 2
The object 'employee' does not exist or is invalid for this operation.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'authors'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'publishers'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'pub_info'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'titles'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'titleauthor'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'stores'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'sales'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'roysched'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'roysched'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'roysched'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'roysched'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'roysched'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'roysched'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'roysched'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'roysched'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'roysched'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'discounts'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'jobs'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'employee'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'employee'.
Msg 208, Level 16, State 1, Procedure titleview, Line 4
Invalid object name 'authors'.
I think thess errors are mostly due to windows vista's new security features at the user level. However, I using my home computer and the admin privileges and in this case I shouldn't have any problem running it unless there's anything to be done on vista to work this.
I'll appreciate if anyone helps me installing the sample files.
Thanks in advance.
View 8 Replies
View Related
