Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: server connection

Show all headers | View raw

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.

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