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

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

|||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.
|||

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

Accessing Shared Data Source in VS.net

How can i get the shared data sources i created in the report manager to be available in VS.net to be able to assign to a report. I want to be able to create the shared data source first in Report manager and then be able to assign it a report in VS.Net

Thanks.

You need to find where it stores the .rds file. Then in Visual Studio, you could add the existing data source. I'm not sure where it stores the file though.

|||

Wouldnt it be stored on the Report Services server?

|||

Yes, but I mean where would the .rds file be stored in windows? Try creating a new data source from report manager then searching for the name of the data source in windows. Once you find where it typically stores the files, you can just go to that path and use the existing data source to add it to Visual Studio.

I would think anyway....

|||

If you created a shared datasource in the report manager, you can script it using RS Build (http://www.codeplex.com/RSBuild/) or RS Scriptor (http://www.sqldbatips.com/showarticle.asp?ID=62).

Alternatively, you can take the low-level approach and read the appropriate table in the ReportServer database <g>.

The point of these scripts is supposed to be to publish to a different server, etc, and as backup -- not specifically for creating a VS definition file, but it will give you what you need to create an .rds file, nonetheless, because that's just an XML file with the same contents as the properties that the scripting tools are extracting out.

Either way, you will almost definitely need to supply the credential information again.

>L<