Smartphone emulator and Query analyzer

I have a problem with using the SQL Server Mobile's Query Analyzer on the SmartPhone 5.0 emulator.

Query Analyzer is installed on the emulator just fine, and I can run it, but I cannot open a database. I've tried exactly the same on a Pocket PC 5.0 emulator and there I can point to an existing .sdf file and open it. How the h¤#! do I do the same on a SmartPhone?

Thanks,
Henrik Bach

[394 byte] By [HenrikBach] at [2008-1-27]

«« Object Oriented Data Storage
»» Is there a kind of Validation Tool for Processs Template?

# 1

Hi Henrik,

I am not familiar with that tool, I'll try to get some SQL Mobile folks to look into it.

Thanks,

Vladimir

VladimirFedorov at 2007-9-8 >

top of Msdn Tech,Smart Device Development,Device Emulator General...

# 2

Henrick, query analyzer isn't supported on Smartphone. But have no fear, there's a better way of manipulating databases :)

If you have Visual Studio 2005 installed, launch Visual Studio and go to the "Server Explorer" window (View > Server Explorer). Right click on the tree in the window and select "Add New Connection...". When prompted for a database type, select Sql Server Mobile Edition. Then you'll be able to navigate to the .sdf file on the desktop and open it. It'll show up in the tree view and using right click menus you can edit the table schema, create new tables, and view the contents of tables directly within VS.

Note that the option to connect to the database on the via ActiveSync doesn't work in Beta 2.

Neil

NeilEnnsMSFT at 2007-9-8 >

Smart Device Development Hot Topic

Smart Device Development New Topic

Smart Device Development

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech