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

Re: server connection

Date	2011-09-01 17:55 +0200
From	Henk van den Berg <me@myplace.net>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: server connection
References	<bdedf611-d8d5-4556-9872-efbf714be613@o9g2000vbo.googlegroups.com> <j382d3$k25$1@dont-email.me> <ced6cc2d-5723-4051-b639-ea9b7218feee@b34g2000prf.googlegroups.com>
Message-ID	<4e5fab3a$0$2532$e4fe514c@news.xs4all.nl> (permalink)

Show all headers | View raw

Mark D Powell schreef op 31-08-2011 22:03:

>> 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?

It is (instance name) and it does (server name).

"." is shorthand for local machine

Best,
Henk

>
> HTH -- Mark D Powell --

Back to comp.databases.ms-sqlserver | Previous | Next — Previous 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