Re: Database connection from PDA over cradle

Thanks for the follow up, Joe. I've had no problems with Vista, but I believe based on your comments, that may be because I installed the WM 6.0 SDK which includes Device Emulator 2.0.

--
Ginny


"Joe [MCSD]" <JoeMCSD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:03EA4D16-81B8-455C-BCFB-6FBAF9C9C5D1@xxxxxxxxxxxxxxxx
Ok I figured out the problem. Basically it’s a Vista / Windows Mobile Device
Center / Emulator issue.
In order to get the device/emulator to talk to the network I had to install
the newest emulator 2.0. The problem was the emulator wouldn’t cradle with
Vistas – Windows Mobile Device Center.

Thanks for the response, Joe


"Ginny Caughey [MVP]" wrote:

Joe,

Are you attempting to log in using Windows authentication or SQL Server
authentication? If Windows authentication, you must provide the
DomainName\UserID and password, unlike on the desktop machine.

--
Ginny


"Joe [MCSD]" <Joe [MCSD]@discussions.microsoft.com> wrote in message
news:6D5C1E4F-71F8-4106-AE2B-63A207876C12@xxxxxxxxxxxxxxxx
> Any one figure this out? I am having the same problem.
> As a heads up when I try and hit the server with the name it can't find > it
> at all (Server not found)
> When I use the IP I get a (Server Not Found or Invalid Login)
> The login works fine in a standard Windows VP app.
>
> Thanks, Joe
>
> "Ginny Caughey [MVP]" wrote:
>
>> Joshua,
>>
>> Does it work if you use the ip address for the database instead of the
>> machine name?
>>
>> -- >> Ginny
>>
>>
>> "Joshua_Wise" <JoshuaWise@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:BD55319E-33D3-4A8B-84A5-6FE326A9938F@xxxxxxxxxxxxxxxx
>> > Mario,
>> >
>> > Thanks for this. Unfortunately this is exactly what I'm doing, and
>> > it's
>> > just not seeing the databases. I'm not sure if it's because the >> > Pocket
>> > PC
>> > is
>> > not seeing itself as "on" the network or what, but when I run this >> > code
>> > on
>> > my
>> > desktop app, it works fine. When I run it on the pocket PC I get >> > the
>> > error
>> > that the database can not be found.
>> >
>> > I've put my code below.
>> >
>> >
>> > *************CODE********************
>> > Imports System.Data
>> > Imports System.Data.SqlClient
>> >
>> > Private myCommand As New SqlCommand("Select * from [beverage_brands
>> > (ap)]")
>> > Private myDS As New DataSet("TEST")
>> > Private myT As DataTable
>> >
>> > Private Const SELECT_STRING As String = _
>> > "SELECT * FROM bob.info"
>> > Private Const CONNECT_STRING As String = _
>> > "Data Source=LK65735;Initial Catalog=fds;User ID=sa; >> > Pwd=myPW"
>> > Private m_DataSet As DataSet
>> >
>> > 'LK65735 is the name of the computer where the MSDE SQL DB is hosted
>> > and
>> > running.
>> >
>> >
>> > 'Button click to start the code
>> > Private Sub Button1_Click(ByVal sender As System.Object, ByVal e >> > As
>> > System.EventArgs) Handles Button1.Click
>> > Dim data_adapter As SqlDataAdapter
>> >
>> > ' Create the SqlDataAdapter.
>> > data_adapter = New SqlDataAdapter(SELECT_STRING, _
>> > CONNECT_STRING)
>> >
>> > ' Map Table to Contacts.
>> > data_adapter.TableMappings.Add("days", "mydays")
>> >
>> > ' Fill the DataSet.
>> > m_DataSet = New DataSet()
>> > data_adapter.Fill(m_DataSet)
>> >
>> > dgDays.DataSource = m_DataSet.Tables(0)
>> > End Sub
>> > **************END CODE******************
>> >
>> > "Mario Aoun" wrote:
>> >
>> >> Hi Joshua_Wise,
>> >>
>> >> Please find my answers to your questions below:
>> >> 1. Is this even possible?
>> >> Yes, sure it is possible.
>> >> 2. How would I go about it?
>> >> inside the smart device application project, you add a reference to
>> >> System.Data.SqlClient and in the connectionstring of your >> >> connection
>> >> you
>> >> use
>> >> the same string you are using on ur desktop application like the
>> >> following:
>> >> dim conn As New SqlConnection
>> >> conn.ConnectionString =
>> >> "server=YOURSERVERNAME_OR_YOURPCNAME;database=YOUR_MSDE_DATABASE;User
>> >> ID
>> >> =YOUR_SQL_LOGIN; Password=YOUR_SQL_PASSWORD"
>> >>
>> >> Good luck
>> >> mario
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> "Joshua_Wise" wrote:
>> >>
>> >> > Hi all,
>> >> >
>> >> > Ok, I have an application on my WM 5.0 device that i developed in
>> >> > VB.Net
>> >> > 2005. What I want to do is be able to access an MSDE database >> >> > that
>> >> > is
>> >> > hosted
>> >> > on the PC that my device is cradled to. At the moment i can do >> >> > this
>> >> > by
>> >> > using
>> >> > a desktop application that queries the database and then sends >> >> > the
>> >> > results to
>> >> > the PPC as XML files. What I want to be able to do is do a >> >> > direct
>> >> > data
>> >> > connection from the PPC application to the database, hence >> >> > cutting
>> >> > out
>> >> > the
>> >> > "middle man" on the desktop.
>> >> >
>> >> > Two questions then. 1. Is this even possible? 2. How would I >> >> > go
>> >> > about
>> >> > it?
>> >> >
>> >> > Thanks in advance,
>> >> > Joshua Wise
>>


.