Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail From: Erland Sommarskog Newsgroups: comp.databases.ms-sqlserver Subject: Re: server connection Date: Fri, 26 Aug 2011 07:29:02 +0000 (UTC) Organization: Erland Sommarskog Lines: 35 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Injection-Date: Fri, 26 Aug 2011 07:29:02 +0000 (UTC) Injection-Info: mx04.eternal-september.org; posting-host="G7+Jz22XqYCG8C6rb1H3YA"; logging-data="20733"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19pgTXnm6beFsSpVzD3upZc" User-Agent: Xnews/2005.10.03 Mime-proxy/1.4.c.4 (Win32) Cancel-Lock: sha1:4LmNvTxNCQwH5X0s8bP0ekvmQdM= Xref: x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:630 Fabiof (fabio.folino@gmail.com) writes: > 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(); So this is the Javascript code? I don't know Javascript, but in some languages \ is used as an escape character, why you need to double it if you want to includee as-is. That is, try: Data Source=.\\SQLEXRESS -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx