Re: How to Direct connect with ActiveSync

Paul
I have tried to connect to the Northwind data base that is on SQL 2000 using
Visual Studio 2008 and I keep getting the error "Server does not exist or
access is denied" I made sure that SQL was on port 1433 and turned off all my
firewalls and I am still getting the "Server does not exist or access is
denied"
Please help.
Thanks

"Paul G. Tobey [eMVP]" wrote:

Well, I don't write in VB.NET, but it seems to me that you'd use the
SqlConnection class, with a suitable connection string. You're using a very
old version of SQL Server, older than I've ever used with a .NET Compact
Framework client, so I'm not sure that it will work (and I'm sure it won't
be supported, even if it does). You also haven't told us what version of
the .NET Compact Framework you're going to put on the device, so there might
be some cavaets, depending on that. Something roughly like this:

imports System.Data.SqlClient
....
sql = New SqlConnection("Data Source=<name or IP of SQL Server
machine>;Initial Catalog=<name of database>;User ID="<name of
user>";password="<password for user>";")
sql.Open()
....

Paul T.

"MutlyP" <MutlyP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1B912628-7601-405B-9596-E11C55F230B6@xxxxxxxxxxxxxxxx
Paul
Can you give me a link to some code samples in VB on how to do this?
Thanks
Matt

"Paul G. Tobey [eMVP]" wrote:

You should be able to treat the ActiveSync connection as a network
connection, like wired Ethernet (NOT WIRELESS ;-). Have you tried this
and
found a problem? The code would be no different than the wireless code,
of
course, since it's just a network.

Paul T.

"MutlyP" <MutlyP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AF059081-FB02-46E1-BCE0-25D8E058293A@xxxxxxxxxxxxxxxx
I hope someone can help me on this one it is driving me crazy.
I have Mobile 6 device connected to my desktop computer through a wire
,(NOT
wireless, repeat NOT WIRELESS) useing ActiveSync.
What I need to do is have the device connect to the SQL Server 2000
database
that is on my intranet and download data from tables in that database
to
the
tables in the database that is on my device. I beleive it's called
Direct
Connect. I can not find any example code on how to do this. On the net
it's
all about wireless connections, or merge and replication, but I can't
do
those because of my companies security policies.
Please help
Thank You
Matt






.

Relevant Pages

  • Re: Connection issues between .Net framwok and SQl Express 2005
    ... You will no longer need the database MDF file name in the connection string. ... simply attach the ASPNETDB.mdf to SQL Server permenantly, ... as USER INSTANCE on existing SQL Server Express, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Wireless Print Server - Without Connecting to Router or PC
    ... connection, Layers 1 and 2. ... wireless end points are 'clients' to an access point. ... That also brings up the question of what's a client and what's a ... Kinda reminds me of the X11 server versus client and ...
    (alt.internet.wireless)
  • Re: Performance of ODBC
    ... if you have a software firewall; forward 1433/1434 to your server ... I've now created my own server with SQL Server 2005 Express, ... glitch concerns the Upsizing Wizard. ... I originally set up my ODBC connection via ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL Err when WLAN conn is dropped and then restored. Help!
    ... We run ppc's in our warehouse that communicate via wireless lan with our SQL ... Server 2000 database. ... lose their wireless connection. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Cant Connect Computers
    ... Configure Email and Internect Connection Wizard ... re-enable the wireless on the router, unplug the Ethernet cable to the ... server for the wireless NIC. ... How to configure Internet access in Windows Small Business Server 2003 ...
    (microsoft.public.backoffice.smallbiz)
Loading