Re: Help needed for connecting SQl server from PPC Emulator

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Lloyd Dupont (net.galador_at_ld)
Date: 05/14/04 

Date: Fri, 14 May 2004 15:01:20 +1000

mmhh....
just for fun, try this:
"server=RAMESH\\RAMESHSQL, 1433;Database=Pubs;User ID=sa"

I put 2 '\', because \r is a special character 

-- 
ihookdb
Get your data mobile
http://www.ihookdb.com
"Ramesh Singhvi" <ramesh_singhvi@hotmail.com> wrote in message
news:5f3bbde0.0405132042.70d9ad7a@posting.google.com...
> 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
    ... 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)
  • Re: Invalid OLEVERB structure error 80040000 on DTS job
    ... >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >- I copied this DTS package from a 32 bit Windows Server 2003 system. ... >I would only get that error message in the Job History logs though. ...
    (microsoft.public.sqlserver.dts)
  • Re: Classic ASP connectionstring to SQL Server 2005
    ... So this connection string is in the VB6 dll? ... What is the error message? ... Provider cannot be found. ... can you ping the sql server? ...
    (microsoft.public.inetserver.asp.db)
  • Re: ANNOUNCEMENT: New SQL Server security tool - SQL Server 2000 Scan Tool
    ... > This posting is provided "AS IS" with no warranties, and confers no rights. ... >> computers running Windows 2000 or higher and can identify instances ... >> please state the version of SQL Server being used and the error ... >> error message text received, ...
    (microsoft.public.windowsxp.security_admin)
  • Re: ANNOUNCEMENT: New SQL Server security tool - SQL Server 2000 Scan Tool
    ... > This posting is provided "AS IS" with no warranties, and confers no rights. ... >> computers running Windows 2000 or higher and can identify instances ... >> please state the version of SQL Server being used and the error ... >> error message text received, ...
    (microsoft.public.win2000.security)