From: George on
I want to develop a small software in C# for Windows mobile 6 whose one of
the actions is to connect and retrieve data from the corporatre MS SQL
Server 2005. I am still in development phase with visual studio 2008. When I
create a new connection in my windows mobile form (the same way as in
windows forms for desktop windows) and try to open it returns an error with
the message "SQLException" and nothing else.

what am I doing wrong?

George

From: Ginny Caughey MVP on
George,

Probably the problem is your connection string. From a mobile device, you
need to use the IP address and port rather than server instance name for the
SQL Server. You also need to provide \domainName\userID and password even if
you are using integrated security on the server.

--

Ginny Caughey
Device Application Development MVP


"George" <gvarelas(a)casinorio.gr> wrote in message
news:E6C00B42-A41C-4339-9062-F126F1968839(a)microsoft.com...
>I want to develop a small software in C# for Windows mobile 6 whose one of
>the actions is to connect and retrieve data from the corporatre MS SQL
>Server 2005. I am still in development phase with visual studio 2008. When
>I create a new connection in my windows mobile form (the same way as in
>windows forms for desktop windows) and try to open it returns an error with
>the message "SQLException" and nothing else.
>
> what am I doing wrong?
>
> George

From: George on
I suspect that it is matter of network. I work at Visual Studio Emulator in
order to develop the application. Do I need to do something at the emulator
(settings or anything) in order to see the local area network?


"Ginny Caughey MVP" <ginny.caughey.online(a)wasteworks.com> wrote in message
news:C3F020B4-9BD0-48AE-AF0D-04283409D05E(a)microsoft.com...
> George,
>
> Probably the problem is your connection string. From a mobile device, you
> need to use the IP address and port rather than server instance name for
> the SQL Server. You also need to provide \domainName\userID and password
> even if you are using integrated security on the server.
>
> --
>
> Ginny Caughey
> Device Application Development MVP
>
>
> "George" <gvarelas(a)casinorio.gr> wrote in message
> news:E6C00B42-A41C-4339-9062-F126F1968839(a)microsoft.com...
>>I want to develop a small software in C# for Windows mobile 6 whose one of
>>the actions is to connect and retrieve data from the corporatre MS SQL
>>Server 2005. I am still in development phase with visual studio 2008. When
>>I create a new connection in my windows mobile form (the same way as in
>>windows forms for desktop windows) and try to open it returns an error
>>with the message "SQLException" and nothing else.
>>
>> what am I doing wrong?
>>
>> George
>
>

From: Ginny Caughey MVP on
George,

I find it's easier to "dock" the emulator and use it like a regular device.
(From VS menu - Tools, Connect to Device.)

But I find it's easiest to use a real device for anything involving
connectivity.

--

Ginny Caughey
Device Application Development MVP


"George" <gvarelas(a)casinorio.gr> wrote in message
news:FD407FBE-5CA1-49B3-A3AE-2297077665D1(a)microsoft.com...
>I suspect that it is matter of network. I work at Visual Studio Emulator
>in order to develop the application. Do I need to do something at the
>emulator (settings or anything) in order to see the local area network?
>
>
> "Ginny Caughey MVP" <ginny.caughey.online(a)wasteworks.com> wrote in message
> news:C3F020B4-9BD0-48AE-AF0D-04283409D05E(a)microsoft.com...
>> George,
>>
>> Probably the problem is your connection string. From a mobile device, you
>> need to use the IP address and port rather than server instance name for
>> the SQL Server. You also need to provide \domainName\userID and password
>> even if you are using integrated security on the server.
>>
>> --
>>
>> Ginny Caughey
>> Device Application Development MVP
>>
>>
>> "George" <gvarelas(a)casinorio.gr> wrote in message
>> news:E6C00B42-A41C-4339-9062-F126F1968839(a)microsoft.com...
>>>I want to develop a small software in C# for Windows mobile 6 whose one
>>>of the actions is to connect and retrieve data from the corporatre MS SQL
>>>Server 2005. I am still in development phase with visual studio 2008.
>>>When I create a new connection in my windows mobile form (the same way as
>>>in windows forms for desktop windows) and try to open it returns an error
>>>with the message "SQLException" and nothing else.
>>>
>>> what am I doing wrong?
>>>
>>> George
>>
>>
>