Groups | Blog | Home
all groups > sql server clients > march 2005 >

sql server clients : Connecting WinCE app directly to SQL Server


Harold Rappold
3/23/2005 5:22:37 PM
We are developing a portable gaming device for use in casinos and bingo
halls. We use SQL Server (2000K) as the backend. The gaming device
software is a Windows CE application written in C/C++. We do not use any
framework as we needed maximum graphics speed to spin reels and do other
animations so that rules out the usual way to connect CE to SQL Server. We
currently use a product called CEFusion that provides us with an ADO
interface to SQL server but it is overkill for what we need and has a high
per client cost.

We are thinking about writing our own SQL client software, and have
sufficient programming skills to do it, but we don't know if that is
something Microsoft allows or if they would release the information needed
to do it. Is this possible? Are there any other solutions?


Mike Epprecht (SQL MVP)
3/24/2005 1:43:02 AM
Hi

ADOCE is you option. No matter what, you need to use some form of OLE
DB/ODBC layer, as MS does not publish the wire protocol spec for TDS.

Look at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppc2k/html/ppc_eplus.asp

http://search.microsoft.com/search/results.aspx?qu=ADOCE+&View=msdn&st=b&c=4&s=1&swc=4

Regards
Mike

[quoted text, click to view]
AddThis Social Bookmark Button