Re: Connect to Desktop SQL Server 2000 from Pocket PC

From: Alex Feinman [MVP] (public_news_at_alexfeinman.com)
Date: 06/21/04 

Date: Mon, 21 Jun 2004 10:46:49 -0700

Thank you. 

-- 
Alex Feinman
---
Visit http://www.opennetcf.org
""Ilya Tumanov [MS]"" <ilyatum@online.microsoft.com> wrote in message
news:oerE1c7VEHA.2764@cpmsftngxa10.phx.gbl...
> SSPI is in fact supported, but you have to provide user ID and password
> anyway as CE does not have this information.
> This might be useful if SQL authentication is disabled on a server.
>
> Best regards,
>
> Ilya
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> --------------------
> > From: "Alex Feinman [MVP]" <public_news@alexfeinman.com>
> > References: <eV#I4s6VEHA.1652@TK2MSFTNGP09.phx.gbl>
> > Subject: Re: Connect to Desktop SQL Server 2000 from Pocket PC
> > Date: Mon, 21 Jun 2004 10:19:20 -0700
> > Lines: 23
> > X-Priority: 3
> > X-MSMail-Priority: Normal
> > X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
> > X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
> > Message-ID: <OogXkP7VEHA.2168@TK2MSFTNGP10.phx.gbl>
> > Newsgroups: microsoft.public.dotnet.framework.compactframework
> > NNTP-Posting-Host: 204.249.181.133
> > Path:
>
cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED
> 01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
> > Xref: cpmsftngxa10.phx.gbl
> microsoft.public.dotnet.framework.compactframework:55645
> > X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework
> >
> > You need to use SqlClient class available in System.Data.SqlClient. It
> works
> > pretty much the same way as on the desktop except IIRC the Integrated
> > Security=SSPI is not supported. You need to use User ID= and Password=
> >
> > -- 
> > Alex Feinman
> > ---
> > Visit http://www.opennetcf.org
> > "Leonardo Castillo" <castillolj@hotmail.com> wrote in message
> > news:eV%23I4s6VEHA.1652@TK2MSFTNGP09.phx.gbl...
> > > Hi,
> > >
> > > I need to connect from a program in the Pocket PC to SQL Server in my
> > > desktop. How i can do than in VB.NET ?.
> > > (I need an information in one table in SQL Server 2000).
> > >
> > > Thanks,
> > >
> > > Leonardo Castillo.
> > >
> > >
> >
> >
> >
>

Relevant Pages

  • General Network Error - Connecting Pocket PC with SQL Server (Desktop)
    ... I need to connect from a program in the Pocket PC to SQL Server in my ... "General network error". ... > Alex Feinman ... >> I need to connect from a program in the Pocket PC to SQL Server in my ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: CE Emulator and RDA
    ... A win2k server platform. ... > // Initialize the RDA object. ... >> Another thing - do you have IIS on the same machine as the SQL server? ... >> Alex Feinman ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: managed out of memory exception in pocket pc 2002 emulator
    ... Try rechecking properties on your classes. ... >> Alex Feinman ... >>>> constructors, form load events etc)? ... >>>>> My pocket pc application was up and running in both the pocket pc ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Upload a file from a Pocket PC to a web server?
    ... Alex Feinman ... after the connection has been made, and written to the Stream Writer object. ... >>> I'm tring to write a program that will take a file from the Pocket ... >>> upload it to a IIS web server using HTTP. ...
    (microsoft.public.pocketpc.developer)
  • Re: General Network Error - Connecting Pocket PC with SQL Server (Desktop)
    ... Try using SQL Server IP address instead of name. ... "Leonardo Castillo" wrote in message ... > "General network error". ... >> Alex Feinman ...
    (microsoft.public.dotnet.framework.compactframework)