Re: Help needed for connecting SQl server from PPC Emulator

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

Date: 13 May 2004 21:42:58 -0700

The error message is "SQL server does not exist or access denied". But
the sql server instance does exist coz I am able to connect it through
my desktop App.
Is there any limitation on Sql server instances which have "\" in
their name?? I have another instance of SQL server(7.0 ) which is
named as "Ramesh" and it is able to connect to it successfully. Please
guide me if I am missing something.

"Lloyd Dupont" <net.galador@ld> wrote in message news:<uGZmD4HOEHA.3016@tk2msftngp13.phx.gbl>...
> watch for the error message in the debuger.
> SqlException.ToString() always return "SqlException" because Message was not
> properly marked 'override', however in the debugger you could see the
> Message string which often have an informative value
>
> --
> ihookdb
> Get your data mobile
> http://www.ihookdb.com
>
>
> "Ramesh Singhvi" <ramesh_singhvi@hotmail.com> wrote in message
> news:5f3bbde0.0405121025.9aa78a2@posting.google.com...
> > I wanted some help with connecting to sql server from Pocket PC 2002
> > emulator.
> > I recently upgraded to VS.NET 2003 professional and I am working on a
> > stand alone(windows form) pocket pc app.
> > I have SQL server 2000 on my desktop PC and SQL instance is registered
> > as 'RAMESH\RAMESHSQL'.
> > When I am trying to connect this sql server from a smartdevice app
> > thro the emulator I am getting a "SqlException" error. I also tried
> > putting the port number 1433 in the
> > Connection string but still no difference. My connection string looks
> > like "server=RAMESH\RAMESHSQL, 1433;Databse=Pubs;User ID=sa". I was
> > able to connect to connect to the server from my desktop. Any help
> > would be really appreciated

Relevant Pages

  • Re: Connecting to a sql server database
    ... > line numbered code where the connection string is shown). ... > sql server, hence integrated security fails. ... >> causing the error message and what the correction for this. ...
    (microsoft.public.dotnet.general)
  • Re: Help needed for connecting SQl server from PPC Emulator
    ... watch for the error message in the debuger. ... SqlException.ToString() always return "SqlException" because Message was not ... > I have SQL server 2000 on my desktop PC and SQL instance is registered ... > Connection string but still no difference. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Remote Connection to SQL 2005
    ... I think you have an application, so can you show your Connection String? ... It's going to be the error message which will help us to solve the problem. ... You better investigate the problem from SQL Error Logs if it's only about SQL Server connection. ... If your SQL Server Instance is a Named Instance then ensure the Browser Service is running. ...
    (microsoft.public.sqlserver.setup)
  • Re: OWC10 PivotTable: how to create connection string that specifies UN+PW for OLAP
    ... the client machine display error message inside the ... but continue with the same error message. ... > The one thing I have found is that SQL Server and Analysis server, ... > that login in your connection string. ...
    (microsoft.public.office.developer.web.components)
  • Re: Connecting to a sql server database
    ... You are trying to use integrated security in your app (as is shown in the ... line numbered code where the connection string is shown). ... sql server, hence integrated security fails. ... > causing the error message and what the correction for this. ...
    (microsoft.public.dotnet.general)