Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.ms-sqlserver    |    Notorious Rube Goldberg contraption    |    19,505 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 18,430 of 19,505    |
|    Erland Sommarskog to Fabiof    |
|    Re: server connection    |
|    26 Aug 11 07:29:02    |
   
   7ba3cde9   
   From: esquel@sommarskog.se   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   
|
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca