No connection to local SQL Server when no network connection

Hi !
We are using Windows XP,
ADO in our application,
MS SQL Server 2000.
(Programming language: Delphi 5;
ADO components: from Adonis;
The computer is a SONY notebook).
SQL server is running on the same machine as the application.
The application has worked in many, many cases under W2K and even XP.
But on that computer it doesn't work:
When there is no network connection, then the application CANNOT connect to
our DB.
On the other hand, Enterprise Manager CAN connect.
When we plug in the network and restart the computer, then the application
CAN connect.
However, SQL Server is running locally !
The connection string for connecting our app to the database is something
like:
'Provider=SQLOLEDB.1; Password="";Persist Security Info=True;User
ID=Bis;Initial Catalog=BIS;Data Source=127.0.0.1'
How can we fix that problem ?
Is this a problem of MS SQL Server administration ?
Your kind help would be appreciated.
PeterThe soluition is to use named pipes to connect as
Enterprise manager will if IP: 127.0.0.1 cannot connect.
Change your connection string to :
'Provider=SQLOLEDB.1; Password="";Persist Security
Info=True;User
ID=Bis;Initial Catalog=BIS;Data Source=(local)'
This should fix the problem.
>--Original Message--
>Hi !
>We are using Windows XP,
>ADO in our application,
>MS SQL Server 2000.
>(Programming language: Delphi 5;
> ADO components: from Adonis;
> The computer is a SONY notebook).
>SQL server is running on the same machine as the
application.
>The application has worked in many, many cases under W2K
and even XP.
>But on that computer it doesn't work:
>When there is no network connection, then the application
CANNOT connect to
>our DB.
>On the other hand, Enterprise Manager CAN connect.
>When we plug in the network and restart the computer,
then the application
>CAN connect.
>However, SQL Server is running locally !
>The connection string for connecting our app to the
database is something
>like:
> 'Provider=SQLOLEDB.1; Password="";Persist Security
Info=True;User
>ID=Bis;Initial Catalog=BIS;Data Source=127.0.0.1'
>How can we fix that problem ?
>Is this a problem of MS SQL Server administration ?
>Your kind help would be appreciated.
>Peter
>
>.
>|||> Change your connection string to :
> 'Provider=SQLOLEDB.1; Password="";Persist Security
> Info=True;User
> ID=Bis;Initial Catalog=BIS;Data Source=(local)'
It worked.
Thanks a lot !

News server

Hello,
I need a news server where i get other subjects like ... oracle, delphi ...
Can Anyone help me?
Thanks
Leandro Loureiro dos Santos
Vitoria-ES / BRAZILOpen this:
http://groups.google.com/
and type the word "Oracle" or "Delphi".
--
Rohtash Kapoor
http://www.sqlmantra.com
"Leandro Loureiro dos Santos" <leandro@.email.com> wrote in message
news:%23S404UT3DHA.2060@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I need a news server where i get other subjects like ... oracle, delphi
...
> Can Anyone help me?
> Thanks
> Leandro Loureiro dos Santos
> Vitoria-ES / BRAZIL
>|||I prefer read using my Outlook express and a news server (UseNet) ...
I would not like use news in web ...
Thanks
Leandro L S
"Rohtash Kapoor" <rohtash_nospam@.sqlmantra.com> escreveu na mensagem
news:%23v7CjcT3DHA.1052@.TK2MSFTNGP12.phx.gbl...
> Open this:
> http://groups.google.com/
> and type the word "Oracle" or "Delphi".
> --
> Rohtash Kapoor
> http://www.sqlmantra.com
> "Leandro Loureiro dos Santos" <leandro@.email.com> wrote in message
> news:%23S404UT3DHA.2060@.TK2MSFTNGP10.phx.gbl...
> > Hello,
> >
> > I need a news server where i get other subjects like ... oracle, delphi
> ...
> > Can Anyone help me?
> >
> > Thanks
> > Leandro Loureiro dos Santos
> > Vitoria-ES / BRAZIL
> >
> >
>|||Server name: news-read2.maxwell.syr.edu
You can subscribe to following Oracle newsgroups:
comp.databases.oracle
comp.databases.marketplace
comp.databases.server
comp.databases.tools
Also there are other newsgroups.
See the following link to find out other News Servers
http://directory.google.com/Top/Computers/Usenet/Public_News_Servers/
--
Rohtash Kapoor
http://www.sqlmantra.com
"Leandro Loureiro dos Santos" <leandro@.email.com> wrote in message
news:eqptyeT3DHA.3196@.TK2MSFTNGP11.phx.gbl...
> I prefer read using my Outlook express and a news server (UseNet) ...
> I would not like use news in web ...
> Thanks
> Leandro L S
> "Rohtash Kapoor" <rohtash_nospam@.sqlmantra.com> escreveu na mensagem
> news:%23v7CjcT3DHA.1052@.TK2MSFTNGP12.phx.gbl...
> > Open this:
> > http://groups.google.com/
> >
> > and type the word "Oracle" or "Delphi".
> >
> > --
> > Rohtash Kapoor
> > http://www.sqlmantra.com
> >
> > "Leandro Loureiro dos Santos" <leandro@.email.com> wrote in message
> > news:%23S404UT3DHA.2060@.TK2MSFTNGP10.phx.gbl...
> > > Hello,
> > >
> > > I need a news server where i get other subjects like ... oracle,
delphi
> > ...
> > > Can Anyone help me?
> > >
> > > Thanks
> > > Leandro Loureiro dos Santos
> > > Vitoria-ES / BRAZIL
> > >
> > >
> >
> >
>|||On Sat, 17 Jan 2004 18:03:25 -0300, "Leandro Loureiro dos Santos" wrote:
>I need a news server where i get other subjects like ... oracle, delphi ...
>Can Anyone help me?
Here's a very good free news server:
http://news.individual.net/
Others that you can pay for include:
http://www.easynews.com/
http://www.giganews.com/
http://www.forteinc.com/apn/index.php
cheers,
Ross.
--
Ross McKay, WebAware Pty Ltd
"The lawn could stand another mowing; funny, I don't even care"
- Elvis Costello|||Leandro - your ISP's news server should carry all the normal usenet ones...
> I need a news server where i get other subjects like ... oracle, delphi ...
> Can Anyone help me?
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq|||On Sun, 18 Jan 2004 13:32:51 GMT, Neil Pike wrote:
> Leandro - your ISP's news server should carry all the normal usenet ones...
... and if you're lucky, your ISP has decent completion and retention.
I don't know about Up Over, but Down Under, the ISPs here have woeful
retention and pretty spotty completion. This means that some posts are
missed, and what does get picked up also gets dropped again pretty
quickly.
Odds on, you're better off with http://news.individual.net/ than your
ISP's news server. At least, that's the case Down Under. YMMV.
cheers,
Ross.
--
Ross McKay, WebAware Pty Ltd
"Words can only hurt if you try to read them. Don't play their game" - Zoolander

News server

Hello,
I need a news server where i get other subjects like ... oracle, delphi ...
Can Anyone help me?
Thanks
Leandro Loureiro dos Santos
Vitoria-ES / BRAZILOpen this:
http://groups.google.com/
and type the word "Oracle" or "Delphi".
Rohtash Kapoor
http://www.sqlmantra.com
"Leandro Loureiro dos Santos" <leandro@.email.com> wrote in message
news:%23S404UT3DHA.2060@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Hello,
> I need a news server where i get other subjects like ... oracle, delphi

---

...

quote:

---

> Can Anyone help me?
> Thanks
> Leandro Loureiro dos Santos
> Vitoria-ES / BRAZIL
>

---

|||I prefer read using my Outlook express and a news server (UseNet) ...
I would not like use news in web ...
Thanks
Leandro L S
"Rohtash Kapoor" <rohtash_nospam@.sqlmantra.com> escreveu na mensagem
news:%23v7CjcT3DHA.1052@.TK2MSFTNGP12.phx.gbl...

quote:

---

> Open this:
> http://groups.google.com/
> and type the word "Oracle" or "Delphi".
> --
> Rohtash Kapoor
> http://www.sqlmantra.com
> "Leandro Loureiro dos Santos" <leandro@.email.com> wrote in message
> news:%23S404UT3DHA.2060@.TK2MSFTNGP10.phx.gbl...
> ...
>

---

|||Server name: news-read2.maxwell.syr.edu
You can subscribe to following Oracle newsgroups:
comp.databases.oracle
comp.databases.marketplace
comp.databases.server
comp.databases.tools
Also there are other newsgroups.
See the following link to find out other News Servers
http://directory.google.com/Top/Com...c_News_Servers/
Rohtash Kapoor
http://www.sqlmantra.com
"Leandro Loureiro dos Santos" <leandro@.email.com> wrote in message
news:eqptyeT3DHA.3196@.TK2MSFTNGP11.phx.gbl...

quote:

---

> I prefer read using my Outlook express and a news server (UseNet) ...
> I would not like use news in web ...
> Thanks
> Leandro L S
> "Rohtash Kapoor" <rohtash_nospam@.sqlmantra.com> escreveu na mensagem
> news:%23v7CjcT3DHA.1052@.TK2MSFTNGP12.phx.gbl...
delphi[QUOTE]
>

---

|||On Sat, 17 Jan 2004 18:03:25 -0300, "Leandro Loureiro dos Santos" wrote:

quote:

---

>I need a news server where i get other subjects like ... oracle, delphi ...
>Can Anyone help me?

---

Here's a very good free news server:
http://news.individual.net/
Others that you can pay for include:
http://www.easynews.com/
http://www.giganews.com/
http://www.forteinc.com/apn/index.php
cheers,
Ross.
--
Ross McKay, WebAware Pty Ltd
"The lawn could stand another mowing; funny, I don't even care"
- Elvis Costello|||Leandro - your ISP's news server should carry all the normal usenet ones...

quote:

---

> I need a news server where i get other subjects like ... oracle, delphi ..
.
> Can Anyone help me?

---

Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvfor...p?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq|||On Sun, 18 Jan 2004 13:32:51 GMT, Neil Pike wrote:
[QUOTE]
> Leandro - your ISP's news server should carry all the normal usenet ones...[/QUOT
E]
... and if you're lucky, your ISP has decent completion and retention.
I don't know about Up Over, but Down Under, the ISPs here have woeful
retention and pretty spotty completion. This means that some posts are
missed, and what does get picked up also gets dropped again pretty
quickly.
Odds on, you're better off with http://news.individual.net/ than your
ISP's news server. At least, that's the case Down Under. YMMV.
cheers,
Ross.
--
Ross McKay, WebAware Pty Ltd
"Words can only hurt if you try to read them. Don't play their game" - Zoola
nder