Re: Help needed for connecting SQl server from PPC Emulator

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Ramesh Singhvi (ramesh_singhvi_at_hotmail.com)
Date: 05/14/04 

Date: 13 May 2004 21:51:15 -0700

Pardon me for the typo... I am still not able to connect it though. It
keeps giving error "SQL server does not exist or access denied"
although it does exist. Were you able to connect to a SQL Instance
having "\" in the name??
And yes I do not have my sa password blank. I did not put it in my
message.. Thanks for your suggestion anyways :)

Liam Westley <liam.westley@tigernews.co.uk> wrote in message news:<E90A4266-6432-4E70-A9FC-D1531BB28FC4@microsoft.com>...
> If your connection string really is,
> "server=RAMESH\RAMESHSQL, 1433;Databse=Pubs;User ID=sa"
> then it's just a simple mis-spelling of Database
> "server=RAMESH\RAMESHSQL, 1433;Database=Pubs;User ID=sa"
>
> I use the following stock routine in one of my classes, which works on a Pocket PC to SQL Server 2000,
> SqlConnection db = new SqlConnection("server=" + serverName + ";database=" + databaseName + ";User ID=" + userID + ";Password=" + password + ";");
>
> It is important to remember that the emulator effectively has a
network card within it, and this is what enables the direct connection
to SQL Server 2000. If you want an application to run on a real
device, it requires either a wired network card or wireless LAN
connection. You cannot access SQL Server 2000 through a cradle
running ActiveSync as this only supports pass through HTTP and not the
independent TCP/IP connections required for SQL Server 2000.
>
> Liam Westley
>
> P.S. Never leave the admin login sa with a blank password, it's isn't considered good practice :-)

Relevant Pages

  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • ADO.net Orcas Samples Install Problem
    ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OpenDataSource SQL Server xpress problem
    ... I tried your suggestions with some success. ... I tried setting up the .odc file through the Word Mail Merge wizard as ... If I work through the dialog to connect and then click the 'Test Connection' ... but I suspect it's because until recently most SQL Server ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Exception trying to import data from Excel .
    ... An attempt to install Microsoft SQL Server 2005 this week has not gone ... The connection type "EXCEL" specified for connection manager ... to create a connection manager for an unknown connection type. ...
    (microsoft.public.sqlserver.tools)