7ba3cde9   
   From: reb01501@NOSPAMyahoo.com   
      
   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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)