Groups > comp.databases.ms-sqlserver > #636

Re: server connection

Path	csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder3.hal-mli.net!nx01.iad01.newshosting.com!newshosting.com!news-out.readnews.com!transit4.readnews.com!postnews.google.com!b34g2000prf.googlegroups.com!not-for-mail
From	Mark D Powell <Mark.Powell2@hp.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: server connection
Date	Wed, 31 Aug 2011 13:03:43 -0700 (PDT)
Organization	http://groups.google.com
Lines	48
Message-ID	<ced6cc2d-5723-4051-b639-ea9b7218feee@b34g2000prf.googlegroups.com> (permalink)
References	<bdedf611-d8d5-4556-9872-efbf714be613@o9g2000vbo.googlegroups.com> <j382d3$k25$1@dont-email.me>
NNTP-Posting-Host	15.219.153.75
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	quoted-printable
X-Trace	posting.google.com 1314821857 32458 127.0.0.1 (31 Aug 2011 20:17:37 GMT)
X-Complaints-To	groups-abuse@google.com
NNTP-Posting-Date	Wed, 31 Aug 2011 20:17:37 +0000 (UTC)
Complaints-To	groups-abuse@google.com
Injection-Info	b34g2000prf.googlegroups.com; posting-host=15.219.153.75; posting-account=qJFqbQkAAACYQSLN0-cvP6ydkRfuOu6u
User-Agent	G2/1.0
X-Google-Web-Client	true
X-Google-Header-Order	ARLEUHCNK
X-HTTP-UserAgent	Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Hewlett-Packard; .NET CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; MS-RTC LM 8),gzip(gfe)
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:636

Show key headers only | View raw

On Aug 26, 8:10 am, "Bob Barrows" <reb01...@NOSPAMyahoo.com> wrote:
> Fabiof wrote:
> > I have an interesting issue connecting to ms sql server.
>
> > I'm connecting to the server with in a legacy asp application just
> > fine. The same application has some page in asp but written in
> > javascript. When I try to connect to the sql server I get the
> > following error.
>
> > Microsoft OLE DB Provider for SQL Server error '80004005'
>
> > [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
> > access denied.
>
> > Here is the connection string. Any help would be appreciated.
>
> > connection_object = Server.CreateObject("ADODB.Connection");
> > connection_object.CursorLocation = 3;
> > connection_object.ConnectionString = "Provider=SQLOLEDB.
> > 1;Password=xxx;Persist Security Info=True;User ID=xxx;Data Source=.
> > \SQLEXPRESS;initial catalog=xxxx;"
>
> > connection_object.Open();
>
> I believe Erland is correct. You could have figured this out using the basic
> ddebugging technique of assigning the string to a variable and using
> response.write to view the content of the variable:
>
> var cstr = "Provider=SQLOLEDB.
> 1;Password=xxx;Persist Security Info=True;User ID=xxx;Data Source=.
> \SQLEXPRESS;initial catalog=xxxx;";
> Response.Write(cstr);
> connection_object.Open(cstr);
>
> Doing so would have made you realize you have a javascript problem rather
> than a sql server problem and allowed you to decide to post your question to
> a javascript group instead.- Hide quoted text -
>
> - Show quoted text -

Could SQLEXPRESS be an instance name and if so would the server name
need to appear before it in the string?

HTH -- Mark D Powell --

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

server connection Fabiof <fabio.folino@gmail.com> - 2011-08-25 18:22 -0700
  Re: server connection Erland Sommarskog <esquel@sommarskog.se> - 2011-08-26 07:29 +0000
  Re: server connection "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2011-08-26 08:10 -0400
    Re: server connection Mark D Powell <Mark.Powell2@hp.com> - 2011-08-31 13:03 -0700
      Re: server connection Henk van den Berg <me@myplace.net> - 2011-09-01 17:55 +0200

csiph-web