PocketPC SQL Server Connection

I am using this string as my connection string to a SqlConnection
object.

constr = "user id=datamobil;password=datamobil; data
source=ServerName;persist security info=False;initial
catalog=INDB;Integrated Security-SSPI;";

I am running the code in an emulator on the same machine that the
server exists. I keep getting an error "SQL Server does not exists or
access denied. Can somebody help me?

João
Sun Apr 18 12:06:28 CDT 2004

Are you trying to access SQL Sever from the emulator? There is no way you
will see it because 1 - you are using different machines; 2 - you can only
connect to an enterprise / desktop instance of SQL Server via SQL Server
CE's replication tools (merge and RDA).

Regards,

João Paulo Figueira

"KAN" <kalyanisundar86@hotmail.com> wrote in message
news:5b913af7.0404180511.4550f1fe@posting.google.com...
> I am using this string as my connection string to a SqlConnection
> object.
>
> constr = "user id=datamobil;password=datamobil; data
> source=ServerName;persist security info=False;initial
> catalog=INDB;Integrated Security-SSPI;";
>
> I am running the code in an emulator on the same machine that the
> server exists. I keep getting an error "SQL Server does not exists or
> access denied. Can somebody help me?

kalyanisundar86
Mon Apr 19 09:43:53 CDT 2004

Thanks a lot,

When i connect the Pocket PC to the desktop via active sync - it works
fine. So does that mean I cannot set the PocketPC up on the same
domain as the SQL Server via wireless access and connect just like any
other client?

KAN
"João Paulo Figueira [eMVP]" <joao.figueira@primeworks.takethisout.pt> wrote in message news:<Otev5eWJEHA.3120@TK2MSFTNGP09.phx.gbl>...
> Are you trying to access SQL Sever from the emulator? There is no way you
> will see it because 1 - you are using different machines; 2 - you can only
> connect to an enterprise / desktop instance of SQL Server via SQL Server
> CE's replication tools (merge and RDA).
>
> Regards,
>
> João Paulo Figueira
>
> "KAN" <kalyanisundar86@hotmail.com> wrote in message
> news:5b913af7.0404180511.4550f1fe@posting.google.com...
> > I am using this string as my connection string to a SqlConnection
> > object.
> >
> > constr = "user id=datamobil;password=datamobil; data
> > source=ServerName;persist security info=False;initial
> > catalog=INDB;Integrated Security-SSPI;";
> >
> > I am running the code in an emulator on the same machine that the
> > server exists. I keep getting an error "SQL Server does not exists or
> > access denied. Can somebody help me?

kalyanisundar86
Mon Apr 19 19:29:35 CDT 2004

kalyanisundar86@hotmail.com (KAN) wrote in message news:<5b913af7.0404190643.7359cbad@posting.google.com>...


I got it working.. I have to use the Emulator for PocketPC 2003 with
Visual Studio 2003

anonymous
Sun Apr 25 22:21:03 CDT 2004

Hi, Han

Is this going to work in real device, suppose the device is connected to the same network as sql server
I have a project, my device needs to connect to sql server using LAN, wonder if I can use sqlclient to connect to database

thanks for further info

csheng

wangkai
Thu May 13 02:46:03 CDT 2004

constr = "user id=datamobil;password=datamobil; dat
source=ServerName;persist security info=False;initia
catalog=INDB;Integrated Security-SSPI;"

The failed reason May be
1
In "user id" and "password" , you can use the username and the password of the user who can login the server machine.(example: "user id=administrator;password=abc"
"Integrated Security-SSPI" in here you should write "Integrated Security=SSPI"