Pocket PC Networking >> OK, I'm embarrassed - s/b easy - connecting to SQL server

by Q2luZHlMdQ » Thu, 28 Apr 2005 06:49:35 GMT

First, let me say a BIG THANK YOU to the awesome MVPs who freely share their
knowledge that they worked so hard to earn. Where would we be without you?
Many thanks - you do a fantastic service.

I read the November 24 post in this forum that said that it should be
possible to connect to SQL Server through a SmartDeviceApplication. I have a
working Windows App that talks great with SQL, so I copied over the exact
same connection info, but the SmartDeviceApp just times out as it is trying
to connect, even with a huge timeout string. It's not an issue with the
handheld, because I'm just trying to run it using the PC2003 emulator. The
code is so simple - just this in the load event of the form. It does display
the "trying" msgbox OK, then after 500 seconds dies. HUGE gratitude in
advance for any hints.


Dim myConnString = "User ID=sa;Data
Source=cindylulaptop;Password=;Initial Catalog=M1_DD;Persist Security
Info=True;Packet Size=4096;Connect Timeout=500"
Dim myConnection As New SqlClient.SqlConnection(myConnString)

MsgBox("trying...")
myConnection.Open()
MsgBox("success")

myConnection.Close()


Similar Threads

1. Easy setup for replication with SQL Server CE - Pocketpc Developer

2. SQL Server CE without SQL Server

I have a Pocket PC application that currently uses an Access database to
search for reference data. These databases are created on the desktop by a
VB application than copied (and converted) over to the device by the
DesktopToDevice API. The data used to create these Access databases come
from XML files retrieved from a web server.

Now the number of records are getting very big (> 150000) and I'm
considering moving on to SQL Server CE. My question is, can I move to SQL
Server CE without having an instance of SQL Server ? In other words, can I
still create a SQL Server CE on the desktop and copy it to the device. Or
can data be inserted into the SQL Server CE database directly from the
desktop application ?

Thanks in advance
Tom


3. Synchronising SQL Server 2005 Express & SQL Server Mobile - Pocketpc Developer

4. adding records from SQL Server Mobile to SQL Server

Hi,

Im going to write a simple application (vb .NET) for mobile device (Windows 
mobile 2003). The program will add some records to a table (called tbl1) on a 
"SQL Server 2005 Mobile".  What I want to do is to put the mobile device to a 
dock connecting to a PC and somehow add (append) these records to a table 
(tbl1) on a SQL Server 2000 on a server which is on the same network with the 
PC. Probably the PC must have SQL Server client on, right; . So can someone 
tell me what I need to do in order to add these records;

Thank you, 
Kostas

5. DB SQL Server 2000 to SQL Server CE - Pocketpc Developer

6. SQL Server 2005 Mobile vs SQL Server Compact Edition 3.1

Hi,

Is there any whitepaper or facts about SQL SErver Compact Edition 3.1 has 
better performance than SQL SErver 2005 Mobile?

Currently I am using SQL Server 2005 Mobile and my database performance is 
very very bad. I am looking for upgrading of db if performance is better.

Please advise before I make the upgrade.

Thanks

-- 
Johnson

7. I'm new to Pocket PC and have a couple what should be easy user question - Pocket PC

8. I'm looking for an easy proxy server... suggestions

Hi, I want to setup a broadband internet surfing proxy server for a
group of about 30 windows xp clients. I'd like it to do some
configurable content filtering. I would like to use my extra windowsXP
machine to do this. What program can I get that would be easy to
setup?