Accessing SQL Mobile Databases in VB2005 - Pocket PCApp

Hot Topic

Variables Not Seen In Custom DataFlow Destination
Beginner T-SQL Question
Does SSIS have these features????
RS 2005 and CSS
Installing SQL Server Express edition
Populating Package variables from a query with 1 input paramater.
MDX2005, current day / filter on a member property
Jet OLE DB Error
Finding out Field Names by Lineage ID
Columns from rows

SQL Server

Measure expressions and currency conversion
SQL Server pricing
Unpivot Transformation Null Values
how can I add a unique key column to a table and generate its values automatically?
Query performance
Device error or device off-line. ???
ExecuteSQL task fails and I think it should not
RS 2005 - keep column headings on screen with long reports??
sqlmaint.exe fail
Percentile

Accessing SQL Mobile Databases in VB2005 - Pocket PCApp


I am using VS 2005 to develop a Pocket PC 2003 application and for some reason I dont have the ability to assign my datasource to a SQL Mobile Database

When opening Server Explorer, right clicking Data Connection, Add New Data Source, Change Data Source, the only options I get are

Microsoft Access Database File
Microsoft ODBC Data Source
Microsoft SQL Server
Microsoft SQL Server Database File
Oracle Database
<other>

I was trying to follow the tutorial

Step by Step: Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005 (http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp)

and in that tutorial when they do the exact same thing it shows a screen shot that also lists 'Microsoft SQL Server Mobile Edition'

Any ideas why I dont have that option FYI, I have SQL Server 2005 and have installed SQL Server 2005 Mobile Edition.

Thanks

Mike

Answer this question

Accessing SQL Mobile Databases in VB2005 - Pocket PCApp

  • Chris G.

    Right on! Thanks so much, would of never figured that out! Noooooowwww, VS 2005 is working how it should and I'm much more impressed.

  • Mike Rousos

    Glad to hear that things working from your side. Thanks for using Microsoft Products and SQL Mobile.

    Thanks,

    Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation



  • AndreaC

    Can you please have a look at @ http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=260599&SiteID=1 and try the machine.config solution given.

    Thanks,

    Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation



  • Accessing SQL Mobile Databases in VB2005 - Pocket PCApp
Answer this question