Problems Installing SQL Server 2005 Mobile On Device
Dec 24, 2005
I have a Fujitsu-Siemens LOOX 520 running WM 5 version 5.1.70 on which I am trying to create a Server 2005 Mobile database.
I have installed the following files on the Pocket PC after a hard reset to make sure the unit was in its vanilla state:
NETCFv2.wm.armv4i.cab
sqlce30.dev.ENU.ppc.wce5.armv4i.CAB
sqlce30.ppc.wce5.armv4i.CAB
sqlce30.repl.ppc.wce5.armv4i.CAB
All the files appeared to succesfully install. Connecting to the device in VS2005 works with no problems. Creating a small test app in VB.NET and running it on the device works no problems, so the device is satisfactorily connected to VS2005.
My problem is this:
When I try to create an SQL Server 2005 Mobile database on the device using Add Connection under the Data Sources window in Visual Studio 2005 Professional (RTM version), I get the following error:
"Microsoft SQL Server 2005 Mobile Edition and/or .NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding."
Trying the same thing in Microsoft SQL Server Management Studio gives the same error, but a little bit of extra information:
"Microsoft SQL Server 2005 Mobile Edition and/or .NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding. (SQL Server Mobile Edition ADO.NET Data Provider)"
As far as I can see, everything IS installed OK, so why is VS2005 not working?
Thanks for any help.
JB
View 6 Replies
ADVERTISEMENT
Nov 15, 2006
We have setup a 32-bit IIS server on a 32-bit machine. Installed necessary SQL Server components (32-bit replication components). We have installed SQL Server 2005 64-bit SP1 with latest hotfixes on a 64-bit machine.
On the Mobile device we installed SQL Server 2005 Mobile.
When we start mergereplication the problem we have is error 28009 (An instance of the SQL Server Reconciler cannot be created) on the mobile device. I read allot about it, but still have a questetion.
Should this work?
I found the doc: SQL Server 2005 Upgrade Technical Resource Guide:
Note: If your upgrade involves SQL Server CE subscribers, you must perform additional actions on the IIS server. You will need to install SQL Server 2005 client connectivity components along with SQL Server Mobile Edition components on the IIS server. You will also have to replace sqlcesa30.dlll, sqlcerp30.dll, and all the replication components on the IIS server.
From this I conclude it should work or is the doc in error?
If it does not, what can we do?
32-bit SQL Server 2005 on the 64-bit machine should work. (Can a 64-bit SQL Server 2005 run alongside 32-bit SQL Server 2005?).
Beste regards,
Hans Mank
View 1 Replies
View Related
Jun 28, 2006
Executing a select query with left outer joins etc takes .53 seconds to execute on sqlce 2.0.
Same query on sql 2005 mobile ed. takes 11 minutes .
on database having same data.
Sample query
SELECT routes.location,routes.equipment_type, routes.contract_type,
routes.maintenance_interval,routes.bank_description,routes.Unit_Des,
routes.Unit_no,max(task_last_completed.date_completed)as date1,min(case when
task_last_completed.due_date is NULL then getdate()-1 else due_date end) as
due_date FROM routes left outer join tasks on tasks.model = routes.model and
tasks.eqtyp = routes.equipment_type inner join task_by_contract_type on
tasks.task_id = task_by_contract_type.task_id and
task_by_contract_type.contract_type = routes.contract_type and
task_by_contract_type.model = routes.model left outer join
task_last_completed on routes.unit_no = task_last_completed.equipment_Id and
tasks.task_Id = task_last_completed.task_Id WHERE routes.location LIKE
'S153825-01%' group by
routes.location,routes.equipment_type,routes.contract_type,routes.maintenanc
e_interval,routes.bank_description,routes.unit_des,routes.unit_no ORDER BY
routes.location, routes.bank_description, routes.Unit_Des
WHY????????????????
View 4 Replies
View Related
Nov 15, 2005
How can I connect to sql server from a mobile device?
View 14 Replies
View Related
May 9, 2007
It is possible to install the .NET Compact Framework from the desktop with a .msi file.
However, SQL Mobile 2005 seems to require you to know the processor which your mobile device uses - there are only CAB files available to do the install.
Have Microsoft made an MSI file available to make this process easier?
matt.
View 1 Replies
View Related
Jan 13, 2006
I'm trying to install the SQL Mobile 2005 Server tools on a Windows 2003
Server with IIS & MSSQL 2000 sp4.
I've stuck .NET 2.0 on already, but the installer for the server tools
Sqlce30setupen.msi just goes straight to the last page of the wizard and says
the install was interrupted.
I've run the install with logging turned on and this is the last portion of
the trace. Can anyone shed any light on whats going wrong.
-------------------------------><-------------------------------------
MSI (c) (9C:14) [14:12:35:912]: Doing action: FindRelatedProducts
Action start 14:12:35: FindRelatedProducts.
Action ended 14:12:35: FindRelatedProducts. Return value 1.
MSI (c) (9C:14) [14:12:35:912]: Doing action: AppSearch
Action start 14:12:35: AppSearch.
MSI (c) (9C:14) [14:12:35:912]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (c) (9C:14) [14:12:35:912]: PROPERTY CHANGE: Adding IISROOTFOLDER
property. Its value is 'C:Inetpubwwwroot'.
MSI (c) (9C:14) [14:12:35:912]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (c) (9C:14) [14:12:35:912]: Note: 1: 1402 2:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL
Server90ToolsShellServices{CA8A686A-0882-4e79-BCA3-AF3F3AB3EB8A} 3: 2
MSI (c) (9C:14) [14:12:35:912]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (c) (9C:14) [14:12:35:912]: PROPERTY CHANGE: Adding MDACFOUND property.
Its value is '2.80.1022.0'.
MSI (c) (9C:14) [14:12:35:912]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (c) (9C:14) [14:12:35:912]: PROPERTY CHANGE: Adding ISIISINSTALLED
property. Its value is 'LocalSystem'.
MSI (c) (9C:14) [14:12:35:912]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (c) (9C:14) [14:12:35:912]: PROPERTY CHANGE: Adding SQL2KREPLCLIENT
property. Its value is '{2FAD19D0-E309-11D2-B6E5-00C04F688E8F}'.
MSI (c) (9C:14) [14:12:35:928]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (c) (9C:14) [14:12:35:928]: Note: 1: 2262 2: Signature 3: -2147287038
Action ended 14:12:35: AppSearch. Return value 1.
MSI (c) (9C:14) [14:12:35:928]: Skipping action: CheckOSVersion (condition
is false)
MSI (c) (9C:14) [14:12:35:928]: Doing action: CA_CheckInstalledSQL
Action start 14:12:35: CA_CheckInstalledSQL.
MSI (c) (9C:94) [14:12:35:943]: Invoking remote custom action. DLL:
C:DOCUME~1CharlieLOCALS~1Temp1MSIB.tmp, Entrypoint: CheckInstalledSQL
MSI (c) (9C:88) [14:12:35:943]: Cloaking enabled.
MSI (c) (9C:88) [14:12:35:943]: Attempting to enable all disabled priveleges
before calling Install on Server
MSI (c) (9C:88) [14:12:35:943]: Connected to service for CA interface.
Action ended 14:12:36: CA_CheckInstalledSQL. Return value 3.
MSI (c) (9C:14) [14:12:36:005]: Doing action: SetupCompleteError
Action start 14:12:36: SetupCompleteError.
MSI (c) (9C:54) [14:12:36:082]: Note: 1: 2731 2: 0
Action ended 14:13:33: SetupCompleteError. Return value 2.
Action ended 14:12:32: INSTALL. Return value 3.
MSI (c) (EC:00) [14:19:35:619]: Destroying RemoteAPI object.
MSI (c) (EC:0C) [14:19:35:619]: Custom Action Manager thread ending.
=== Logging stopped: 11/01/2006 14:19:35 ===
MSI (c) (EC:34) [14:19:35:619]: Note: 1: 1708
MSI (c) (EC:34) [14:19:35:619]: Product: Microsoft SQL Server 2005 Mobile
[ENU] Server Tools -- Installation operation failed.
-------------------------------><-------------------------------------
thanks
// charlie
View 3 Replies
View Related
Feb 9, 2007
I have set up a locahost site in IIS using the "Configure Web Synchronization Wizard". One of the first test I was asked to do was to open a broweser and browse to http://localhost/MobileTest/sqlcesa30.dll
If all is well I should get a web page with the following line:
SQL Server Mobile Server Agent 3.0
But unfortunately I get an error stating :
"The server has encountered an error while loading an application during the processing of your request. Please refer to the event log for more detail information. Please contact the server administrator for assistance."
I checekd the Event log and found this error related the IIS launch process on my machine.
DCOM got error "Logon failure: unknown user name or bad password. " and was unable to logon .IWAM_Rataq in order to run the server:
where Rataq is the name of my machine. Could my IWAM_Rataq account be corrupted, my other sites on the machine work.
Infact if i put in a Test.htm page in the virtual directory MobileTest I am able to browse to the page.
Can the Account be re-set? is there another problem that I am not aware of. I have Norton Internet 2006 running could that be the reason? Could Norton be blocking the dll from loading? But the event log states it is a Account error.
Any ideas why this might occur? any help is always appreciated
View 1 Replies
View Related
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
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
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
Dec 23, 2006
Hi all, I'm new to mobile devices.
I have a desktop application that uses SQL Server Compact Edition. I will soon have a mobile application that will use the same database. How can I (at runtime of the desktop app, say when the user clicks a button) transfer the sdf file to the mobile device? I'm not necessarily interested in synchronizing the databases, simply overwriting the database on the mobile device with the one on the desktop would suffice.
Is something like this possible?
Thanks!
View 3 Replies
View Related
Jun 5, 2006
Hello,
I try to connect the SQL Server from the mobile device.
my connection string is:
string conn_str = "Server= 10.0.0.11;Database=theDB005;uid=bahadir;pwd=abcd;Trusted_Connection=false;";
when i try to open the connection I get SqlException,altough the 10.0.0.11 machine is reachable.. is not allowed to access a remote sql server with ip?
Thanks in advance.
View 1 Replies
View Related
Jan 26, 2006
I have been unable to properly install SQL Mobile 2005 on my armv4i windows CE 5 device. Below is a summary of what I have found and done. Any help in resolving my issue will be appreaciated. Thanks in advance for your help.
Symptoms:
No errors occur during installation of SQL Mobile on the device via cab files (either deployed through VS2005 or manually copied and installed on the device)
SQL Mobile 2005 appears to be installed, can see it in the device remove programs list. All 7 SQL Mobile dll files are present in the windows folder. (sqlceca30.dll, sqlcecompact30.dll, sqlceer30en.dll, sqlceme30.dll, sqlceoledb30.dll, sqlceqp30.dll, sqlcese30.dll - version for all files is 3.0.5206).
The following error occurs when attempting to create a new or open an existing database using SQL Mobile query analyzer on the device - "Failed to initialize the provider. Please make sure that SQL Server Mobile Edition is properly installed".
Problem is not isolated to SQL Mobile query analyzer, a similar problem occurs when attempting to instantiate SQL objects from within a C#.Net smart device test program - "Can't find PInvoke DLL 'sqlceme30.dll'.
Problem is not solved by copying SQL Mobile dll files to program folders.
No registry entries exist for any of the 7 SQL Mobile dll files under the HKEY_CLASSES_ROOT.
None of the dll files for SQL Mobile can be registered manually via the regsrvce.exe program. The error code c1 is returned - invalid win32 application (Note SQL CE 2.0 dll files can be successfully registered via this program).
Background:
The desktop used for development is running Windows 2000 sp4. The develpment enviroment is Visual Studio 2005 Professional Edition (version 8.0.50727.42 (RTM.050727-4200). The version of the Microsoft .NET Framework installed is 2.0.50727. The programming language is C#.NET. The device is a 64 MEG Armv4i device running a custom image of windows CE5. The CE5 image was created by Platform Builder with all QFE's through 2005 applied. .NET Compact Framework version 1.0.4292 and SQL CE version 2.0 are included as part of the image (both are in ROM). .NET Compact Framework version 2.0.5238 and SQL CE Mobile are installed via CAB files in the order defined below:
netcfv2.wce5.armv4i.cab
sqlce30.wce5.armv4i.cab
sqlce30.rep.wce5.armv4i.cab
sqlce30.dev.ENU.wce5.armv4i.cab
system_SR_ENU.cab
View 23 Replies
View Related
Sep 13, 2007
Hello,
I am using the SQL Reporting services with SQL Server 2005. I am able to view my reports in the report manager however, when the report generates on my device it shows blank of 0 pages. I created a simple test report with just a header, company's logo and contact info and still no luck. I am using anoynomous user access and have given IUSR datareader access in SQL Server. Not sure where I am going wrong. I feel like I am so close...If someone out there had any success viewing reports on mobile device (WM5.0) and would be so kind to share their experience or knowledge, I would greatly appreciate it!
Thanks.
View 1 Replies
View Related
Oct 5, 2007
I want to create an application for home users which runs on their mobile device (smartphone) and their desktop PC and keeps the data synchronized between them. On their desktop I want to run either SSCE or SSExpress. There are so many options in the SSCE literature, which options should I use? How do I synchronize the data?
The literature has so many options I don't know where to start.
View 1 Replies
View Related
Aug 19, 2007
Hello,
VS 2005 & SQL server 2005
I developed a mobile application PDA using the Compact Framework 2.0. And using typed datasets
I have also developed a web service. When the PDA is connected to the Internet it can access the web service and get all the data that is in the sql database. The user can add new records, update existing records, and delete them. So the web service acts like a middle man.
In the PDA the data is filled using typed datasets.
However, the customer now wants to be able to interact with there data on the PDA, currently they have to be connected to the Internet. But if there is no internet connection, then they will still like to add, update, and delete the records. Then once they have a connection, all these would be updates with the sql database.
What is the most efficient method to do this.
Many thanks for any suggestions,
Steve
View 4 Replies
View Related
Jan 21, 2008
Hi,
I'm writing a windows application using VB.NET 2005 that must connect to Pocket PC via ActiveSync to read data from SQL Server CE. This is my code:
Dim cnn As New SqlCeConnection
cnn.ConnectionString = "Data Source =Mobile DeviceStorage CardProgram FilesMyAppMobileDB1.sdf"
cnn.Open()
But I get the following error:
The path is not valid. Check the directory for the database. [ Path = Mobile DeviceStorage CardProgram FilesMyAppMobileDB1.sdf ]
Any help would be greatly appreciated!
Leila
View 5 Replies
View Related
Apr 19, 2006
I just upgraded our application from SSCE 2.0 to SQL Mobile. Our app is written in C++, and we use OLE DB for most of our queries, including the routine the downloads and inserts our lookup table data. This application is running on a Dell Axim X51.
Using SSCE 2.0, this routine takes 236 seconds, with most time spent inserting data into various tables (using OLE DB). The resultant database size is 15.1 MB.
Using SQL Mobile, this routine now takes 675 seconds, with a resultant database size of 27.9 MB!! There is a noticable increase in time when the downloaded data is being inserted into the database.
What would be the reason(s) for the slower performance and the increased size of the database? This appears to be a monumental step backwards in performance. Any suggestions regarding improving the perfomance and size?
View 6 Replies
View Related
Mar 11, 2006
I've written a query to pull data from a SQL Mobile database which seems to completely hang the device when I run it (I waited several minutes before warm-starting). Yes, it's a bit complex, but it works fine on the desktop version--completes pretty much instantly.
Are there any limits to SQL Mobile that might prevent me from writing such a query? There are not very many records in any of the tables (all are <20, except one which is ~2500).
Here is the query:
------------------------------------code---------------------------
SELECT oi.ProductID, g.GenusName, Species.SpeciesName, f.FormName, f.Abbr, sz.Sizes, su.SizeUnits, su.Abbr, pa.PackageName, pa.Abbr, oi.NumRequested, oi.NumProvided
FROM OrderItems oi
JOIN Products p ON p.ProductID=oi.ProductID
JOIN Varieties v ON p.VarietyID = v.VarietyID
JOIN Genus g ON v.GenusID=g.GenusID
JOIN Species ON v.SpeciesID=Species.SpeciesID
JOIN Grades gr ON gr.GradeID=p.GradeID
JOIN Form f ON gr.FormID=f.FormID
JOIN SizeUnits su ON gr.SizeUnitsID=su.SizeUnitsID
JOIN Sizes sz ON gr.SizeID = sz.SizeID
JOIN Packages pa ON p.PackageID=pa.PackageID
WHERE oi.OrderID=3
------------------------------------------code---------------------------------------
Any ideas? Thanks in advance.
-Kevin
View 6 Replies
View Related
Feb 5, 2007
Dear ppl,
I have a windows mobile 5.0 application that syncronises with SQL Sever 2005 (Merge Replication). The replication works fine without SSL. But when using SSL it doesn't work .On the device i get an error
28037, A request to send data to the computer running IIS has failed.
I have created a a Wild Card Certificate (*.domain-name.net) using Microsoft Certificate Services (Stand Alone) and setup the replication website with replication virtual directory under it , in IIS, to use this certificate. The host header for the replication site is set to "sql.domain-name.net". I have binded the host headers to the port as well.
I can access the https://sql.domain-name.net/replication/sqlcesa30.dll from remote computer and device and it says Microsoft SQL Server Compact Edition Server Agent, that means it is setup correctly.
I have installed the certificate authority and its wild card certificate on the device Root Certificates. Now when I call repl.syncrhonise() from device .. it throws exception with error 28037, A request to send data to the computer running IIS has failed.
which i think means, it can't find the service url.
I am not sure what is the problem..something to do with Trust - SSL certificates... Is there any thing i am missing ?
Awaiting,
View 9 Replies
View Related
Apr 4, 2008
Hey guys,
So I started an SQL CE database for use inside a mobile application. I used SSMS to create a .sdf file (because if I let Visual Studio do it, SSMS can't open it because it will be version 3.5).
The reason I wanted to use SSMS is because I wanted to be able to design the database in design view, and populate it with initial information for the application to use. That means adding tables and rows.
The problem is, SSMS doesn't seem to have a design view available when working with CE databases. It also doesn't seem to have a feature for adding rows into tables. It's essentially as useless as VS2008 for designing my mobile database. It only lets me add tables, and I can't even do that visually in design view. I have to use those cumbersome forms.
Is there any way to design a CE database in design view? And add rows of data into tables? It feels like I'm overlooking something.
Note: I dont need to subscribe or publish the database. The mobile application just needs to use the database as a repository.
View 7 Replies
View Related
Dec 9, 2006
Hi, Guys
I read a lot of your post about the mobile device connecting SQL Server. I try to solve my problem, but i still in trouble of Mobile database application.
The following is my development enviroment
Visual Studio .net 2005
Sql Server 2005
Windows CE.Net 4.2
Microsoft ActiveSync 4.2
First i can run some simple application on the Mobile Device( Symbol MC9060G Mobile Device), all the connection between develop PC and Mobile Device is fine. All the develop SDK for the Mobile device without problem.
Secont, i can develop a simple normal windows database application, work fine, can get data from SQL Server 2005. the connection to database server is fine.
I used VS2005 develop a simple database with DataGrid on the form( all the code generated by the VS 2005), when run the program, got error at " int returnValue = this.Adapter.Fill(dataTable)"
error "PlatformNotSupportedException". I don't know what's going on.
I think the connection to the database no problem. Maybe the Mobile device has problem. I insatlled sql.ppc.wce4.armv4.cab file to mobile device.
Can someone help me out?
Thanks.
View 4 Replies
View Related
Sep 16, 2007
Hi:
When I try and connecto to SQL CE I always get an invalid operation exception. I"m afraid that I did not follow the proper install for Orcas Beta 2. I can't remember if I was supposed to uninstall SQL Mobile 2005 first or not.
All I know is when I try and use my SQL CE I can't connecto to a DB / sdf file ?
Any help would be appreciated I"m just starting to use SQL CE.
thanks
mark
View 2 Replies
View Related
May 4, 2007
hi,
Can I write a dll(or share the same code) that works on both Mobile device and pc? Since we are using compact edition, we are hoping we can write some common module with the same code that could works on both mobile device and pc platform. I noticed the reference is the same, System.Data.SqlServerCe.dll 3.0.
Another question is, we already have a module for SQLCE2.0, with .net CF1.0. Now, we will start to use compact edition, should we just update on the 1.0 one, or we have to write a different one based on .net CF2.0? Can I use compact edition in CF1.0 dll?
Thanks.
View 1 Replies
View Related
Aug 5, 2007
Hiya,
I have a project that requires that I filter certain data going to the mobile device via the publication based on user selected value on the mobile device. (Filter by location based on the selection of the location on the mobile prior to syncronization).
Now, our current authentication model is Windows Authentication, and changing that to Username based authentication is not feasable, and using the users account to pass that value to the database is the only way I can think of to do this... (Then filter based on username)
But then I thought that there has to be another way - such as passing a variable or parameter to the sync request during or before syncronization... Is this possible? If I could query the data being sent back up to the server, for instance, I could do so to retrieve the value I need.... Any ideas?
Any help appreciated!!
Dave Borneman
anyWare Mobile Solutions
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
Feb 14, 2008
Hi All,
Can we render a report directly on to a mobile device/ interface from SSRS?
View 6 Replies
View Related
Aug 31, 2007
Hi all, Im new here so il start with a little introduction of myself, My name is Arjan im 19 years old from Holland, and i work for a company to compleet my ICT Education.
My situation:
My boss gave me a server with server 2003 standard and Sql server 2005 and visual studio 2005 installed already, he asked me if i could figure out how the 'new' reporting services work, Im pretty new to SQL and the reporting service but i figured out i had to install asp.net / frameworks and IIS.
So right now i wanna start the Reporting Services Configuration Manager and i get an error that says 'Invalid namespace' and when im trying to approach by using my browser i get 'page not found' so obviously their is Alot wrong. I asked my boss if i could not reinstall everything and do it in the correct order (IIS / ASP.net / Frameworks before installing SQL server 2k5 but that was not an option because we dont seem to have the cd's anymore.
The server is not connected to any network or the internet.
My Question:
Is their any way to fix this? and if yes could anyone tell me where to start
Thanks in Advance!
ps if their is information or logs that u need in order to help me just say so :-)
-Arjan
View 1 Replies
View Related
May 19, 2006
I have an SDF using SQLCE 2.0. When I run the app on a Pocket PC device running Windows Mobile 5.0 I get 0x80004005 and 0x80040e21 errors. The same app executes fine on PPC 2003.
The app is written in VC++ using and uses the SQLCE OLEDB Provider to access the SDF. It is complied with eVC 4.0
Any idea as to the problem?
View 5 Replies
View Related
Sep 9, 2007
I use my Pocket PC XDA O2 mini for 2 years already and I don't have any problems when I sync it with my previous laptop which has Window XP operation system.
A few months ago, I bought a new laptop with Window Vista operation system, I could not sync my O2 mini with my PC. Then, I download Windows Mobile Device Center but my computer still could not recognize my O2 mini. My O2 mini has window mobile 2003 Second Edition Version 4.21.1088 operation system. Please let me know if you have any advices.
Thanks.
View 1 Replies
View Related
Jul 24, 2007
Hi,
I am using web service to synchronize data between SQL Server 2005 on a desktop and a SQL Server Mobile Edition on a mobile device.
Initially, when i added the data source to my mobile application, my .sdf only has 3 records. I am then supposed to retrieve 97 more records from the desktop server when my mobile application runs. After performing merging, I clicked (on my device emulator) on the .sdf deployed under my mobile application and the query analyzer showed all 100 records.
Does this mean my mobile database has been successfully updated with all 100 records? If not, how do I check that? The reason why I am asking this is that the file size of this .sdf with 100 records is still the same as the initial .sdf with only 3 records. How is this possible?
Am I missing anything or getting some concepts wrong? Please enlighten. Thanks.
View 4 Replies
View Related
Feb 14, 2007
Hi
I have installed SQL Server Express 2005 on my machine.
I want to install SQL Server Standard Edition 2005 on my machine to check new services it has.
Can these 2 Editions coexist with each other, or any troubles you think might encounter?
Thanks
View 5 Replies
View Related
Sep 25, 2007
Hi,
Please provide some help regarding the "Interface Defining Error: IID_IDBDataSourceAdmin" error while trying to create a SDF database using Query Analyzer on a Windows CE 5.0 mobile device (Symbol MC3000).
Error: 0x80004005 E_FAIL
Native Error: 28558
Description: SQL Mobile encountered problems when creating database [,,,,]
Param. 0: 0
Param. 1: 0
Param. 2: 0
Param. 3:
Param. 4:
Param. 5:
A list of (related) installed packages:
NETCFv2.wce5.armv4i.cab
sqlce30.dev.ENU.wce5.armv4i.CAB
sqlce30.repl.wce5.armv4i.CAB
sqlce30.wce5.armv4i.CAB
PS.
Basically I have developed a mobile application that programmatically creates the database, the code worked on a similar device (Win CE 50), trying to run the application on a new device resulted in database creation errors. I tried creating a test database manually .. and this is what I got.
Browsing MSDN or searching on the Forum did not help.
~Zarko Gajic
View 3 Replies
View Related
