Monday, February 20, 2012

Microsoft SQL Server Mobile Edition data source

i just installed a copy of microsoft sql server 2005 in my pc and decided to follow the newbie's guide:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp?frame=true
anyway, on the 5th exercise wherein i'm supposed to add a new data connection through the server explorer.. when i chose the option of adding a new data source and was prompted to select a data source i couldnt find the Microsoft SQL Server Mobile Edition data source..
is there anything else that i need to download in order to have that data source?

1) Did your installation include "SQL Server 2005 Mobile Edition". Can you see SQL Mobile traces in "Add/Remove Programs" directory. Some thing like "SQL Server Mobile Developer Tools".

2) If yes, then can you please follow the thread@. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=260599&SiteID=1, and see if it helps you out.

Thanks,

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

|||uh yeah. but mine says "Microsoft SQL Server Mobile 2005 Mobile [ENU] Server Tools" i got the sql server 2005 mobile edition by accessing the sqlce30setupen.msi file. also i already tried to add the following lines to the machine.config file but i still couldnt find it when i open vs studio 2005. anyway, if worst comes to worst and i cant figure this one out would you happen to know how i would configure the database connection for a pocket pc through the use of vs.net 2003?

<add name="SQL Server CE Data Provider" invariant="Microsoft.SqlServerCe.Client" description=".NET Framework Data Provider for Microsoft SQL Server 2005 Mobile Edition" type="Microsoft.SqlServerCe.Client.SqlCeClientFactory, Microsoft.SqlServerCe.Client, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />|||

Hmm...it looks like SQL Mobile Developer tools were not installed. Server Tools are not needed for you, they are meant for synchronization of SQL Mobile database with SQL Server. If you dont have Developer Tools, try installing the SQL Mobile Developer tools from the following location of your VS 2005 Disk: wcu\SQLCE\sqlmobile30devtoolsxxx.msi

The xxx in the MSI name stand for the locale, for english it would be 'enu'.

Let me know installing that worked for you.

Thanks

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

|||Dear Laxmi....

I also have the same problem and I tried to install the SQL Mobile Developer tools from VS 2005, but the location is not avalaible in the CD. I used VS PRo 2005.

Please help me because I have a project to write program for My Mobile Application that's need to connect to database.

No comments:

Post a Comment