Hello,
Is it possible to create a .SDF file at the develop machine?I want to write an exe which creates a sdf.So, my customer will be able to create a sdf and import this sdf to the device.
Thanks.
I have read all posts in this forum, but the answers for the main questions are still not completely clear for me. My scenario is smilar than other described cases.
I would like to send a large amount of data to a Windows CE device which runs SQL Server Mobile Edition 2005. Replication is not possible, cause the desktop size of software sometimes uses Oracle or earlier versions of MSSQL Server (for e.g. MSSQL 7.0).
For syncrhonizing data we have two possibilities:
1. sending the data in some format (csv, xml, etc...) to the Windows CE device, parse this file and insert the data into a database, the speed of this is unacceptable, so if it is possible I wouldn't like to use this method
2. Create the SDF file on desktop side, it would be very fast, because it makes unnecessary the post processing on a slow Windows CE device. So please give me a short (YES / NO is completely enough) answer to this: is there any *LEGAL* way to create an SDF file for SQL Server Mobile Edition without buying VS2005 or MSSQL2005 licenses for the desktop computer?
Thx for any help in advance. If the question was answered clear earlier, sorry for wasting time. I think a lot of us struggling with this problem.
Hello Everybody
I want to create SQL server 2005 mobile database on desktop programmatically with some inital data for my application and load it into device. We can create database only in VS2005 server explorer or SQL server 2005 application.
Anybody having this solution for this prob.
Regards
Chikuu
Hello, i'm trying to make a c# web form in vs.net 2003 and a connection to a sql database.I'm using a sqlconnection control and a sqlcommand, but when i test it, the page said: "There was an error in login Encuesta, with the user LOCALHOST/ASPNET" (or something like that)i don't have the source code, and i am not in my pc, so, can somebody help me?
View 5 Replies View Relatedhello everybody,
I've installed SQL Compact Edition (with Visual Studio 2005) and i try to compile Northwindoledb for the DeskTop. The goal of this operation is to migrate a Pocket PC application (C++/OLE DB/SQL Mobile) to the desktop. If i can run properly Northwindoledb project i could start to migrate ...
I've the following error :
hr = pICmdText->Execute(NULL, IID_NULL, NULL, NULL, NULL);
GUID_NULL undefined
What can i do ?
Thanks in advance !
1. Today I've installed webmatrix and MSDE200A and followed this instruction"Select 'SQL2kdesksp3.exe' and save it to your computer.Double-click on the SQL2kdesksp3.exe you downloaded.Once you have run the self extracting exe (SQL2kdesksp3.exe), go to a command prompt.Start > Run > cmdNavigate to the directory you expanded the self extracting exe to and change to the MSDE subdirectory.The default is C:sql2ksp3Type Setup SAPWD=(Some password) SecurityMode=SQLExample:c:sql2ksp3> Setup SAPWD=password SecurityMode=SQLAfter that gets done running, MSDE is installed.Start servicesTo get the SQL Server running and the SQL Agent we need start the services.right click My Computer > manage > servicesDouble click the following and set to Automatic.MSSQLSERVERSQLSERVERAGENTMake sure both are on automatic." then I restarted my comp. I've tried to connect to database but it did not work.I need the reply ASAP!!!! 2.What are the different among MSDE200A.exe, sql2ksp3.exe, and sql2kdesksp3.exe ?
View 1 Replies View RelatedIf I just need a desktop version of SQL 7.0 installed for local development. (Not being used as a server) Do I just need a CAL license?
Thanks!
My organization supports both SQL 7 and SQL 2K. Therefore I have the Enterprise Manager
for SQL 2K on my desktop (it accesses both SQL 7 & SQL 2K, but the SQL 7 EM won't access
both).
I installed the SQL 7 desktop edition on my NT 4 (SP 6) workstation, but only the server (not
client connectivity or client tools).
When I attempt to perform a new server registration using EM (with the desktop server running),
I get the following message:
"SQL Server does not exist or access is denied"
I am attempting to logon as "sa" with a blank password since this will be my very first access of
the installed DB.
Startup of server specifies that the "local system" account be used. Server starts up fine as best
as I can tell.
For client connectivity I have both TCP and NAMED PIPES available.
Any help would be very much appreciated!!!!
Thanks Gary Andrews
andrews_gary_w@solarturbines.com
P.S.
Where blank passwords are used, do I enter a single space or not enter anything
and just press enter?
Is it necessary to have a MS Loopback Adaptor to install SQL Server desptop edition at my home ? ( Otherwise i am unable to connect to the server from the EM )
Thanks,
Deepak.
I have installed Sql 7.0 desktop edition on Win 98 with IE5 and am having a problem starting the Sql server.
It auto registered the server under my machine name. It was returning a network connection error so I deleted it and tried to add one with the name (local). Enterprise Manager then returned an error saying one was already registered under that name.
Anyideas?
Thanks
JC
Hi All.
I have SQL2000 on my WinXP computer. Can I install SQL2005 on my desktop? If yes what version?
Thanks.
Is it possible to install SQL 2000 desktop without installing a databaseserver? I need to have the interface to access my database servers, butdon't want the overhead of a server and the service on my laptop.Possible?ThanksDoug
View 2 Replies View RelatedHello,
View 21 Replies View RelatedHi,
I want to jumpstart my learning of SQL Server so I downloaded the Express edition onto my desktop in the office and also onto my laptop. I usually connect the two machines (through a LAN) to update whatever I was able to do at home while in the office.
What should I do in order to view or edit whatever I started on the laptop from the desktop? Would the databases I create on one be accessible through the other machine for editing and the likes?
Glint.
I have a very simple application that is desktop and windows mobile. I am just starting work on it so the options are wide open for now. My goal is a simple database that will sync columns on both sides.
The SQL Compact Edition database seems like the perfect database to use for this application.
The only way I currently know of to sync a PDA database to the desktop, however, is to use IIS and SQL server on the desktop side and then use the ADO.NET sync stuff.
I don't want to have to set up IIS and SQL server on my client's computers. It will be a mass market product and that is just inviting a ton of support that I don't want to have to deal with. The application is too simple and cheap for that.
I know I can go the old fasion ActiveSync component route, but that is such a pain. I could also use a 3rd party solution, but again, too expensive for this application.
My question is whether anyone knows of a simple solution.
Is there any way in SQLCE to query a remote database and do updates to it? Could the desktop application get access to the PDA SQLCE database or the other way around?
Any help would be great. I have the experience to write an ActiveSync component myself. That is not the problem. It is just such a pain and it seems like in today's day and age I shouldn't have to.
Hello,
Everybody knows that Upgrade.exe is not a win32 application.
Since it is now possible to connect SQL CE 3.1 database with Framework 2.0 and SQL CE 3.1, I am wondering if someone is aware of a method to convert SQL CE 2.0 database to SQL CE 3.0 with Desktop Framework ?
(--> I have a lot of SQL CE 2.0 databases where I would like to connect avoiding use of a PDA. In order to do that, I need to convert all of them)
Thanks
Adrien
hi, can I use sql server desktop edition to deploy my web application and at the same time I am not violating license agreement with Ms.
thanks
Al
I want to know if there is Desktop edition for SQL 2000 Server and if so does it comes bundled on the same CD like it did for MSS 7.0.Also is there a limit to the size of DB's that can be build with it.
Thanks a Bunch
how can i start automatically sqlagent if it doesn't on W98 ?
thanks for answer
What type of licence do I need to run Desktop Edition of SQL 7.0. Is there such a thing as desktop license.
How much Does it approximately cost.
Thanks
Hi all:-
How do I upgrade my local sql server 7 to sql 2000 ? Do I just put in the sql server 2000 CD and run it or is there an upgrade CD ? I have lots of stuff on my sql 7 and don't want to lose it.
Thanks in advance!
my application has a good amount of data that is specific to each company (where there is only one user). i am currently setting it up as a access project, but was wondering about another route. to store the local data would there be an advantage to setting it up as a access project, and use the sql server desktop engine for the data, or should i stick with mdb tables?
View 2 Replies View RelatedI connect to a compute via Remote Desktop Connection that is running SQL Server 2003. That part works. However, once I'm connected, and running SQL Server, I cannot see my user name in SQL, when I use the query, "SELECT user_name as ()". What I see instead is "DBO". Nor does it show me as being in a particlar group. I also cannot see my Windows Authentication remote computer name.
I think it has something to do with using my PC to do the Remote Desktop Connection and then from there, running SQL Server 2003, but am lost on this one.
Can anyone help? I sure would appreciate it! Thanks in advance!
*********************************************************************
This forum is best viewed with a computer. Questions asked freely. Confusion happily shared.
Could the SQL2000 Desktop Engine be bought individually or they onehave to buy the Enerprise version in order to get the Desktop Engine?All we need right now is the Desktop Engine.Thank you very muchmike
View 2 Replies View RelatedHi, 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
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?
Can I synch between a Mobile device using SqlServer Compact and desktop PC running Sql Server Express using Microsoft Synchronization Services?
View 1 Replies View RelatedDear all,
I Need to read the Data from the SDF file in the Desktop. I have SQL Server 2005 in my System.
i know this is possible. but i dont know how it is ....
regards,
Tamil
I inherited a WinCE.net application that uses SQL Server CE as the database. We use Visual Studio 2003 to write the program. Using the query analyzer on the device is difficult and I would much prefer to do my database views/research on my desktop. I could even copy the SDF over to the desktop, slice and dice it and then return it to the compact unit. But what do I need to have on my desktop so I can view these SDF files? Thanks.
View 10 Replies View Relatedi have an application that uses sqlce.. now i want to install sqlce with my installer instead of seperate installer... could you please guide me how can i do this? i have created installer for my application but how to integrate sqlce with it...
View 1 Replies View RelatedDoes a desktop version SQL Server exist with Enterprise Manager and Query Analyzer? I'm a developer who uses SQL Server, Enterprise Manager and Query Analyzer at work to write scripts and batches. I would like to enhance my SQL Server skills at home on my desktop computer.
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!
I have a new computer p4 2.8
i just install in it the Microsoft Visual Studio .NET, when i try to install the sql server desktop from:
"C:Program FilesMicrosoft Visual Studio .NETSetupMSDE" in the middle it stops installing,
I tryed to uninstall Visual Studio and install it again , but i get the same problem
what can i do?