SQL Server connection
in [Compact Framework]
|
From: George on 22 Jan 2009 05:16 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 22 Jan 2009 07:47 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 22 Jan 2009 08:23 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 22 Jan 2009 08:46 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 >> >> >
|
Pages: 1 Prev: cannot open serial port Next: How i restore the original function of my hardware keys? |