Re: Connecting Pocket PC & SQL Server 2000 through OleDB

There is no Microsoft OLEDB provider (or any other native provider) for
PocketPC that can connect directly to Sql Server. Are you sure you need
direct connections to Sql Server? If you have a mostly disconnected scenario
I would suggest trying Sql Server Mobile which can replicate data with Sql
Server.

If you need direct connections you have the option of using Ado.Net
providers from Sql Mobile (see System.Data.SqlClient)

In any case, the correct place to ask this question is
microsoft.public.sqlserver.ce

--
Thank you,
Leonard Mosescu, Microsoft Windows CE Compiler Team

This posting is provided "AS IS" with no warranties, and confers no rights.

"Vetri" <j_vetri@xxxxxxxxx> wrote in message
news:1139481485.468745.9270@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,
I am developing application in EVC++. My application needs to
directly connect with SQL Server 2000 through OLEDB. I have tried
including SQLOLEDB.h and it fails in CoCreateInstance Anyone Kindly
help me to solve this problem. Is there any method to connect to the
SQL Server 2000 database.
Thanks & Regards,
Vetriselvan



.

Relevant Pages

  • Re: SQL Server on a Laptop
    ... It seems like from the SQL Server FAQ that the licensing may be a little ... Personal Edition is acting as a mutliplexer and SQL Server device CALs ... SQL Server Personal Edition or through direct connections. ...
    (microsoft.public.sqlserver.server)
  • Re: Do I need to use a Web Service to hook up An Access Front End to SQL Server?
    ... Do I need to use WCF to hook up an access front end to a sql server ... My IT department doesn't allow direct connections to my ... No you don't need a web server, nor do you need to use web services to have ... connection can be an IP address). ...
    (microsoft.public.access.forms)
  • Do I need to use a Web Service to hook up An Access Front End to SQL Server?
    ... Do I need to use WCF to hook up an access front end to a sql server ... My IT department doesn't allow direct connections to my ...
    (microsoft.public.access.forms)
  • Re: Disabling ASP.net 2.0 Membership
    ... I checked out the article you referenced and implemented my own provider. ... as a FoxPro database, an Oracle database, or other data sources. ... custom connection string so that I can use the Commerce Server SQL Server ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ERROR: Provider Management - Could not establish a connection to t
    ... If you have not yet created the SQL Server database, ... Can any data provider be used to ... Exception Details: System.Data.SqlClient.SqlException: A connection ...
    (microsoft.public.dotnet.framework.aspnet)