Best Way To Learn SQL Mobile?
Aug 1, 2006
I am an experienced web developer using PHP and MySql have experience with VB.
What is the best way for me to learn programming pocket pc's? Is using sql server mobile the best offline database to use as I will be using MySql Compact framework to connect direcly to our Linux server.
Any help is much appreciated as I can't seem to find any useful tutorials on quering an sql databse to update, insert, read or delete. I have created a datebase however, I just don't know how to use it.
Thanks in advance.
Mark
View 7 Replies
ADVERTISEMENT
Aug 8, 2006
Dear ppl,
I am writing an application for a device (MDA Pro T-Mobile) having Windows Mobile 5.0 using
-MS .NET Compact Framework 2.0 SP-1
-SQL Mobile 2005.
-VS 2005 .NET
The application uses Merge Replication. The error occurs in the Synchronise() Method of the SqlCeReplication object.
"SQL Server Mobile encountered problems when opening the database."
repl.AddSubscription(AddOption.CreateDatabase);
repl.Synchronize();
I don't understand why I am having this error. It does create the database on AddSubscription() method but it is failing opening the database on Synchronise(). I have also tried uninstalling and then reinstalling all the SQL Mobile components in the following order.
-sqlce30.wce5.armv4i.cab
-sqlce30.repl.wce5.armv4i.cab
-sqlce30.dev.ENU.wce5.armv4i.cab
However, when i run this application on a device(Dell X50 AXIM) with Pocket PC 2003, it runs fine creating the database and sysnchronising it.
The target platform for the project is Windows Mobile 5.0 Pocket PC SDK.
Does any one have any clue what could be the problem ?
Regards
Nabeel
View 6 Replies
View Related
Jun 15, 2006
I am migrating a pocket PC application from VS 2003 to VS 2005 and a few weeks ago I hit the following problem when replicating
A SQL Mobile DLL could not be loaded. Reinstall SQL Mobile. [ DLL Name=sqlceca30.dll]
Scanning forums for help I saw that other people had had this problem and one
http://www.eggheadcafe.com/aspnet_answers/NETFrameworkCompactFramework/Feb2006/post25814466.asp
suggested that this problem could be circumvented by getting the replication object early and then continuously using the same object for subsequent replications.
I did this and it works a lot better now but ever so often I get another error which is
Native Error 28559 SQL Mobile encountered problems when opening the database
My only option at this point is to stop and start the application which cures the problem.
View 4 Replies
View Related
Mar 23, 2006
Hello,
I am developping a non-managed C++ application for PocketPC using a SQL Server mobile database.
The application is compiled for PocketPC 2003 and uses SQL Server Mobile v2. I use Visual Studio 2005. But I need to compile the application for Windows Mobile 5.0 devices. So I installed the WM5 SDK and had the WM5 into my project configuration.
The "ssceoledb.h" which I include incluses the "transact.h" file. But my problem is that this file is only provided with the PocketPC 2003 SDK and not in the WM5 SDK.
So I cannot use the WM5 configuration project with SQL Server. I also tried with the last SQL Server Mobile 2005 (ie v3.0) and the "ssceoledb30.h" also includes "transact.h".
Did I miss something to install ?
Do you know how I can resolve the problem ?
By advance, thank you for any answer.
--
Gregoire
View 9 Replies
View Related
May 18, 2006
Using MS VS 2005 (incl SQL Server Mobile)
MS Pocket PC 2005 SDK
I am working on a project that builds for Pocket PC on both Mobile 2003 and Mobile 5. The project uses/will use SQL Server Mobile to store local data.
Project created from new with support for both platforms. I include required header files ssceerr30.h and ssceoledb30.h.
Project builds fine in WM2003 configuration, release and debug.
When I build for WM5 the compiler cannot find the header file transact.h. This is included from within ssceoledb30.h. Same as under WM2003.
In WM2003 configuration if I highlight the ssceoledb30.h include in Visual Studio and open the header, it takes me to <Visual Studio dir>SmartDevicesSDKSQL ServerMobilev3.0. I then locate the include for transact.h and do the same, which takes me <Visual Studio dir>SDKPocketPC2003include. The file exists.
If I repeat the above 'browsing' under the WM5 configuration, ssceoledb30.h takes me to a different copy in the WM5 SDK directory. There is no diff between the file here and the other copy used by WM2003. If I attempt to open transact.h - file does not exist.
Fix (which I'm not too sure about, i.e. is it OK?) - If I copy transact.h to the WM5 SDK directory, the project builds.
Why has transact.h disappeared from WM5 SDK?
I can find no ref's to this problem anywhere. Is my installation of the WM5 SDK corrupt? What else could I be missing?
Is there a sample for SQL Server mobile (like the NorthwindOLEDB sample) that comes configured to build for WM5?
View 1 Replies
View Related
Mar 6, 2006
It is possible to access a Sql Server 2005 Mobile database in a VS2003 application (compact framework) ?
Thanks
Robson
View 4 Replies
View Related
Sep 8, 2007
I receive error 25123 on my PPC (audiovox 6600) in a reproducable way (usually) with .net 2.0 application that is using SQL CE that I wrote:
Open the application
Connect to the database
Close the applicaton
Re-Open the application
Connect to the database <-- Error occurs
I will also receive the error if my application isn't the first application launched (or very close to the first to launch).
I don't believe it's a memory issue as according to the memory manager I have plenty of memory:
At boot up only start screen items loaded: 18.46 Used 49.89 Free
Launch Resco File Explorer to click EXE: 19.18 Used 49.18 Free
Launch my application (no DB connection): 23.64 Used 44.71 Free
Connect to the DB and do select count(*) from a table with 0 rows: 26.27 Used 42.08 Free
Close the application (this.Close() on the form: 19.38 Used 48.97 Free
Relaunch App and connect to DB receive error: around 38 Used around 30 free
I was unable to reproduce the issue right now while typing this message, the last sets of numbers are from memory, and include other applications that are currently running.
The only way I have to get SQL CE to load again is to soft reset the PPC. If the application is able to connect to SQL CE at least once it is fine up till I close it and re-open the application. So it either connects and runs great, or it can't connect at all.
Any help in resolving this issue would be greatly appreciated.
Wayne
View 1 Replies
View Related
Apr 24, 2006
Hi folks, I'm new to Windows Mobile progamming, and new to this forum. Apologies in advance if I'm asking a boneheaded question, but I've done searches and can't find anything directly applicable to my problem.
I'm currently walking through the published MS tutorial in setting up an SQL Server 2005 Mobile application that subscribes to a publication on SQL Server 2005 to exchange information.
I've gotten almost all the way through... successfully set up the server components, creating the publication, etc. On the mobile side, I've been able run the cab files to install the SQL Mobile components and to create the project, add the reference to the dll, and instantiate an engine object. It compiles.
The step in the tutorial after that, though, where you specify the data source from the "data" menu, I've got a problem. When I try to use the "new connection" dialog from choosing the data connection, "MS SQL Server Mobile Edition" doesn't show up as a choice. I've tried choosing any of the other combinations, and in teh subsequent "Connection properties" section my database, SQLMobile (as in their sample) is available, but I get an error when I choose it and click OK. Clicking on "Test Connection" gives me a connection successful message.
My guess is that something about the Mobile server side components is not installed correctly on my development machine, but honestly I have no idea how to begin to fix it. Has anyone seen this problem before and know how to resolve it?
Your time and any knowledge sharing is greatly appreciated.
Thank you,
-Dana
View 8 Replies
View Related
Jan 31, 2005
Hello everyone! Many thanks in advance for taking the time to help me out. I’ll also apologize upfront for the longwinded email, but I seem to be really stuck in a rut. I've been writing web apps for 3+ years in ASP and am finally taking the leap into ASP.net (a bit behind the curve, i know). I have a few books and have gone over the tutorials on this site. I am realizing that the syntax (if using VB) is much the same, but also realize how much richer asp.net is in comparison to traditional ASP.
I'm having some major issues in my learning process that stem from using the tutorials and attempting to be efficient with VS2003. I feel as though I’m missing something fundamental that could be causing my problems. My area of focus right now is data access, using connections, adapters and datasets.
The tutorials on this site show all of the examples by hardcoding the data access into the ASPX page. The tutorials have me importing the proper namespaces for data and sqldata access at the top of the page. This seems to work fine and dandy if I were to be coding my pages from a standard text editor, but I would like to use the richness of the VB.NET studio gui to expedite my work.
My first problem lies if I try to manually code the data access in the private class defined for the page in the codebehind section. Because it will not allow me to import multiple namespaces, the only way I get it to work would be to include the complete namespace for the object I’m trying to use (ie: system.data.sqlclient.sqconnection). On top of this, the datasets I define aren’t available as options when I try to bind them to objects in the GUI.
On the flip side, I tried to use the SQLconnection, Dataadapter, etc objects in the gui, but I can’t seem to find where the code is dynamically written for these, nor how I can, for example make this sort of connection use an application-variable level connection string. The only way I can see to make this would be to define the connection for each web form, which seems silly when I’m trying to deploy each solution multiple times with different databases.
I apologize for my ignorance, as this is probably fairly simple to overcome. If someone could point out what I’m doing wrong, or point me in the right direction, I’d be very appreciative. I am sick of spinning my wheels with this, and keep getting tempted to go back to using traditional ASP, just so I can get my job done.
Thanks again,
Tbldev
View 2 Replies
View Related
Nov 23, 2005
does anyone know where I can learn how to make forumlas to use in my table fields?
I have two mauals on SQL Server and niether of them cover formulas.
Thanks,
token
View 7 Replies
View Related
May 15, 2006
anyone know any site that can provide "EASY" to understand examples about joins?
View 2 Replies
View Related
Jun 12, 2007
I was just looking for opinions on the best place to pick up SQL skills. Community college course? Online courses? Grad school? I've finished undergrad, if that helps anyone have an idea of my current situation.
View 4 Replies
View Related
Dec 13, 2007
hi,
I am new to sql server. I would like to learn sql server. I have knowledge of databases. Can anyone guide me on this?
View 6 Replies
View Related
Jul 23, 2005
How to learn sql from beginning?I would like to learn sql but don't have a clue.can you help me?where would I start?
View 1 Replies
View Related
Aug 22, 2005
I can't get a script to run that's supposed to generate a QueryParameters dialogue to take inputs and then run the query - forexample, the following.. . .and fl.flow_name = [[TRUE][FLOW NAME][@?]].. . .generates SQL Query Analyzer exceptions about "Incorrect syntax near'FLOW NAME'.Suggestions?
View 1 Replies
View Related
Aug 2, 2007
I have several DTS packages I need to move to SSIS. I am having trouble understanding the new tools available and how I translate my lookup and ActiveX scripts into the new format. I feel like I just need a jump start to get me on the right road. Does anyone have any good suggested links to get me started with the new technology and get my head unstuck from the old DTS?
Thanks,
Eva
View 1 Replies
View Related
Oct 25, 2007
Hi all.. I install SQL Express install.. I am looking for a job, and I see companies posting want ad's for SQL server admins.
My one question... what is the difference of SQL Server vs OpenSQL ?
Thanks,
Happy Tom
View 1 Replies
View Related
Jul 16, 2003
Hi:
AS a newly Master degree graduate student in IT field. My M.S. degree training has been emphasized in database developer, Web developer, Web/database developer, network, and network and computer security.
My personal interesting are database and web. have experienceon java servlet and database(create a web site), try ASP and dataabase now, but I don't have any work experience(come from other country and change major)
hope can get advice from kindness prople what is suitable to learn DBA or oracle ? conside about difficult level, cost, and suite for future job market
Thank you
View 5 Replies
View Related
Sep 19, 2001
Greetings:
I would like to learn to write SQL scripts to use with SQL 2000 and would like a good reference. I read the book "SQL Queries for mere mortals" and that was a start, but really didn't provide me enough depth to write the complex scripts that I need. Idealy something that goes into the programming logic like PL/SQL in Oracle did. Basiclly, if I had something that would allow me to interperet some of the scripts I see on Swynk so I can modify them to meet my needs, I think that would be a great place to start.
Any recomendations?
Thanks.
View 1 Replies
View Related
Sep 11, 2004
Hi All,
I am totally new to databases. I am starting from the absolute beginning. I want to learn MS-SQL and was wondering how/where to start. I need info on everything from installation and set-up on an Windows XP PC to programming in SQL. Is there a book or website that can guide me. I am fairly decent at programming and am able understand technical books. Installation and set up are my main concerns right now, since I believe that once I have a stable system to learn on, SQL should be easy.
Thanks!
View 6 Replies
View Related
Jun 15, 2007
Hi, All:
I know oracle SQL, now I need to do a lot of SQL query on Microsoft SQLSERVER, can any one point out any place that I can find out the syntax of SQLserver SQL statement? Since this is just a short term assignment, so I don't want to buy a book, just hoping I can learn something quickly from online. I don't need learn anything deep, just need to know some simple syntax so I can do join, count, concatenate, min(), max(), sum () etc.
thanks in advance.
View 5 Replies
View Related
Jul 21, 2006
This is a great tutorial and it's a shame one of the more important steps was missed.
In the €œCreate the snapshot user€? section you you find the steps to create the snapshot_agent account. Then in the €œCreate the snapshot folder€? section you find the share and folder permissions. However, at no point do the instructions advise you about adding the snapshot_agent to the SQL Server Logins. The result is that agent cannot perform the initial snapshot but you won't find this out until 50 steps later after Step 10 in the section €œCreate a new subscription".
To get back on track, openthe Object Explorer's Security section and add the snapshot_agent to your logins. Then using the "User Mappings", set an appropriate level for the SQLMobile database role. Once completed you then need to run the agent.
Right-click the SQLMobile publication you created and select "View Snapshot Agent status". From that dialog you can select "Start" to run the agent. When it completes, you can return to the tutorial section "Create a new subscription" and continue with the tutorial.
View 4 Replies
View Related
Nov 3, 2007
I am studying the tutorial in SQL Server 2005 Mobile Edition Books Online, and the topic is Creating a Mobile Application with SQL Server Mobile. I have got a problem when creating a new subscription after created a new SQL Server Mobile database. And the problem is shown below:
New Subscription Wizard
- Beginning Synchronization (Success)
- Synchronizing Data (100%) (Error)
Messages
* Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)
* 無法完æˆ?作æ¥ã€‚
- Finalizing Synchronization (Stopped)
- Saving Subscription Properties (Stopped)
Before I have met this problem, I have finished all the task. And I can browse the localhost web site by using anonymous account even I use internet explorer or browse the directly in IIS.
Does anyone can solve it?? Thank you very much~~~
View 3 Replies
View Related
Feb 6, 2006
Hello,
My department is switching from a TM1 database to an SQL Server database. With TM1, only a few people had the software necessary to run queries installed on their PCs. Whenever I needed data, one of these people would run the query for me and then I would perform whatever analysis is required. Now however, we all have MS SQL Server (Query Analyzer, Profiler, Enterprise Manager, etc.) installed on our machines and will be able to run our own queries.
I have no prior experience with SQL (my only programming knowledge is with Excel VBA) so I bought the "Teach Yourself SQL in 10 Minutes" book and worked through most of it. I practiced writing queries in MS Access, and feel somewhat comfortable with the language. However, when I try to do anything with SQL Server, I feel kind of overwhelmed with all of the options. I assume that I should be writing and executing my queries from Query Analyzer, but I find the object browser and everything confusing. Also, I'm not sure if I'm even able to create my own database to practice with. It seems like I can only connect to my department's server. Is there any way to work "offline" with a database on my own hard drive?
All of the SQL Server books that I've found seem to be either for DBAs or developers. Anything geared more toward beginners isn't SQL Server specific. Can anyone recommend an appropriate book for me?
Thanks,
John
View 13 Replies
View Related
Apr 16, 2007
Dear Experts,I've worked with Oracle since 1995. I have gonevery deep into many of the Oracle features, includingsqlloader, and export/import. And I've done datamodelling even longer.At the same time, I have done ETL since 1995.Although, at the Proc, and PLSQL, sqlloader, level.Map the data. Take data from the source, do anymodifications/transformations that are required,and insert or update. Easy. The hard part isdetermining the mappings.But I have not been given the opportunity towork much with ETL tools such as:Informatica, DataStage, Ascential, Ab InitioThe little bit of experience that I do have,showed that Informatica was -incredibly- easy to use.It's a GUI. It's SUPPOSED to be simple!!!I have missed out on a number of opportunitiesbecause I didn't have a few YEARS of experiencewith ETL tools. Which seems odd, because thetool looks like it requires a max of a week to learn!Just how difficult are these ETL tools to learn?Especially if you have already been working withOracle, and doing data mappings and loads since 1995?I'm thinking that it can't be difficult at all.When you search for newsgroups, there are no newsgroupsfor these tools. Although the companies who makethem, might have their own newsgroup.There are also not many books on these tools.If you search for books on Oracle, or SQL Server,you will find a lot of very big, and detailedbooks. But there is next to nothing specificallyon the various ETL tools.Any certifications for any of these tools lookto be much simpler than Oracle's.To me, the real issue is the mappings. If youcome into a new environment, the data mappingsare completely esoteric to those systems.No amount of experience with an ETL tool, or anytool, is going to tell you what the mappings should be.Questions:- Just how difficult are these ETL tools to learnfor an experience Oracle pro like myself?- Other than a GUI, making everything simple to use,just what are the advantages of using ETL tools?- what built in functionality do ETL toolshave, that can't be done in PLSQL?Thanks a lot!
View 19 Replies
View Related
Feb 20, 2008
Hi there,I have learned to create very, very basic queries at work, but I wouldlike to expand my knowledge. I live in Northern California, doesanyone know of any good schools and/or literature that could help mein this quest?Thanks a bunch,Juana
View 2 Replies
View Related
Dec 31, 2007
I'd like to learn SSIS working with SSAS, how to transformation data for Dimension or fact tables? What are different between normal ETL tasks and ETL for Dimension / fact tables ? How to learn? Do I need to learn SSAS first? Please give tips for that. Many thanks.
View 1 Replies
View Related
Oct 5, 2007
Hello.I would like to learn all the possible ways that we can access and modify data in ASP .net 2.0 programmatically.for example one way would be like this: StringBuilder sql = new StringBuilder();sql.Append(" SELECT *"); //count the total number of recordssql.Append(" FROM dbo.tblJobTitle "); //get the connection string from web servicesstring strConnection = new sqlconnection.SQLConnection().GetSQLConnectString(sqlconnection.SQLDSN.SCIC);//Use the Microsoft.practices SqlDatabase object to execute our sql.SqlDatabase SqlHelper = new SqlDatabase(strConnection);SqlDataReader reader = (SqlDataReader)SqlHelper.ExecuteReader(CommandType.Text, sql.ToString());the i can loop through reader and get the data OR I can create a DataSet like this: SqlDatabase db = new SqlDatabase(strConnection);
DbCommand dbCommand = db.GetSqlStringCommand(sql.ToString());
DataSet dst = db.ExecuteDataSet(dbCommand);I want to know if there is a comprehensive book explainaning all these possible ways to access and modify data using C# under ASP .net 2.0I really really apreciate this.Thank you very much.
View 3 Replies
View Related
Mar 24, 2008
does anybody know where I can learn how to add, update, delete using SQL datasource control? I have a couple of books that shows me how to SELECT but nothing shows me how to update, add new record or delete with the SQL data source control. Even this website doesn't have any tutorial. Does any body know where I can read up on how to use all features of this control? Or where that have a couple of examples on how to use it?
View 5 Replies
View Related
Nov 7, 2005
Hi there,Where I should start to learn using stored procedure in SQL Server?Is there any link/site that good for learning?Thanks,Ron.
View 1 Replies
View Related
Feb 8, 2007
Hello,
I need to start learning SSIS. Has anyone found any good sites that explain it and that are free?
Thanks,
Kurt
View 2 Replies
View Related
Jul 6, 2007
Learn Oracle Database Administration in 10 Minutes. No kidding. Checkit yourself,http://www.takveen.comOnly good analogy makes complex concepts simple!
View 2 Replies
View Related
Oct 24, 2007
i want to learn about the meanings of the different 'data types' in VS 2005 (database) i.e. 'nvarchar(50). could you please advice me of a good site (reference) to read.
View 1 Replies
View Related
