Establishing a Direct Database Connection

Establishing a Direct Database Connection

• chrislal

  Yes, it's possible to establish direct connection to SQL Server 2000 and SQL Sever Mobile (CE), support for that is included into VS.
  
  Other DB providers are available from 3rd parties. For example, Oracle DB provider can be found here: http://crlab.com/oranet/< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

  
  
  

• Vikasumit

  Thanks so much for your advice. I was kind of thinking that was the answer. I will install VS 2005 since I still have the subscription to get it. There are 3rd party apps out there to connect to the device and SQL CE 2.0. Some of them are very good. SQL Mobile also considered SQL CE 3.0 I have SQL Server 2005 installed so now all I have to do is get VS 2005 installed and I will be good to go. Thanks so much for answering my questions. I tried reading the white pages on this stuff but there was so much out there they kind of conflicted or overwhelmed you.
  
  

• SYStems

  Ilya Tumanov
  
  Thanks for the post back to the above message. I would like to use a native microsoft tool to do this. Does microsoft have a native tool to connect to a SQL Sever Mobile (CE) database
  
  

• Cameron Kloot

  The only tool available from Microsoft for SQL CE 2.0 is query analyzer which runs on device. 3rd part tools might be available.
  
  Tools for accessing SQL Mobile database are included with VS 2005, as well as query analyzer which runs on device.
  
  SQL Server 2.0 database has different format from SQL Mobile database, so you can not access SQL Server 2.0 database using SQL Mobile. You can convert database, this is done on device.< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

  
  
  

• Jeff Mason

  Ok maybe I miss stated the question. Below I have two examples on my site of apps for PPC smart devices. These both connect to SQL Server CE and allow you to create table, delete table, insert records etc..
  
  http://www.ipdg3.com/sourcecoderesults.php option=search_sourcecode&sc=Mobile_&ss=sql&match=cp&offset=0
  
   Sorry what I ment was is there a want to connect to a SQL Server CE database on the mobile device and manage the database. Like you do with SQL Server (2000) Enterprise Manager or SQL Server (2005) Management Studio. I have found with SQL Server 2005 you can connect to Server Type "SQL Server Mobile". Although it will not connect to my mobile database I have created using the reference to System.Data.SqlServerCe.dll in my VB.NET app. I get this erro when trying..
  
  TITLE: Connect to Server
  ------------------------------
  Cannot connect to C:\intranet.sdf.
  ------------------------------
  ADDITIONAL INFORMATION:
  Invalid database version. [ Db version = 0,Requested version = 0,File name = C:\intranet.sdf ] (SQL Server Mobile Edition ADO.NET Data Provider)
  ------------------------------
  BUTTONS: OK
  ------------------------------

  
  
  

• bairavinathan

  If by "native" you meant native c++ application, you can use, say, OLE DB.
  
  http://www.pocketpcdn.com/articles/articles.php &atb.set(c_id)=74&atb.set(a_id)=4574&atb.set(c_id)=74&atb.set(c_id)=74&atb.set(c_id)=74&&atb.set(c_id)=74&atb.set(a_id)=4574&atb.set(c_id)=74&atb.set(c_id)=74&atb.set(c_id)=74&atb.perform(details)=&
  
  If you meant "provided by Microsoft", it is included into VS as I stated above. Just add a reference to System.Data.SqlServerCe.dll and you're good to go. Samples can be found in VS documentation.< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

  
  
  
• Establishing a Direct Database Connection