I have an ASP.NET application set up on my local hard drive with all pages,
dlls, and SQL server on local machine. However, I have discovered that if I
reboot my machine without a network cable plugged in, and then try to run
the application, I get the following:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.
If I then plug in the network cable, and wait a minute or so, the
application will then work. If I unplug it again, it stops working again.
What gives here? Is there some kind of driver that gets loaded when the PC
is connected to the network that is important somehow for how the
application connects to SQL Server? 8 3214
Just a wild guess...
Is your connection string is based on IP or computer name?
Maybe because u are not on a network, your DCHP is not configured to the
"correct ip".
"BobRoyAce" <bo*@omegasoftwareinc.com> wrote in message
news:ML********************@comcast.com... I have an ASP.NET application set up on my local hard drive with all pages, dlls, and SQL server on local machine. However, I have discovered that if I reboot my machine without a network cable plugged in, and then try to run the application, I get the following:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
If I then plug in the network cable, and wait a minute or so, the application will then work. If I unplug it again, it stops working again. What gives here? Is there some kind of driver that gets loaded when the PC is connected to the network that is important somehow for how the application connects to SQL Server?
The connection string contains an IP...not a computer name.
"Joey Lee" <jo*********@hotmail.com> wrote in message
news:u7**************@TK2MSFTNGP14.phx.gbl... Just a wild guess...
Is your connection string is based on IP or computer name? Maybe because u are not on a network, your DCHP is not configured to the "correct ip".
"BobRoyAce" <bo*@omegasoftwareinc.com> wrote in message news:ML********************@comcast.com...I have an ASP.NET application set up on my local hard drive with all pages, dlls, and SQL server on local machine. However, I have discovered that if I reboot my machine without a network cable plugged in, and then try to run the application, I get the following:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
If I then plug in the network cable, and wait a minute or so, the application will then work. If I unplug it again, it stops working again. What gives here? Is there some kind of driver that gets loaded when the PC is connected to the network that is important somehow for how the application connects to SQL Server?
BobRoyAce,
Can you give an idea how your connectionstring looks like..
Post it if u can
** But u stated ur SQLServer is installed on ur local PC?
And u didn't give it another IP adrees when u installed it?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
ConnectionString = "Persist Security Info=False;Initial Catalog=THEDB;Data
Source=127.0.0.1;user=appuser;password=thepassword ;Connect Timeout=120"
NOTE: All works well as long as network cable is plugged in...just doesnt
work if it's not plugged in...so not a connection string problem. I am
wondering if TCP/IP is required to make the connection and if it isn't in
memory if boot up without cable since it detects that there is no network
connection.
try using 'localhost' as your datasource/server identifier.
HTH,
andy
"BobRoyAce" <bo*@omegasoftwareinc.com> wrote in message
news:Ep********************@comcast.com... ConnectionString = "Persist Security Info=False;Initial Catalog=THEDB;Data Source=127.0.0.1;user=appuser;password=thepassword ;Connect Timeout=120"
NOTE: All works well as long as network cable is plugged in...just doesnt work if it's not plugged in...so not a connection string problem. I am wondering if TCP/IP is required to make the connection and if it isn't in memory if boot up without cable since it detects that there is no network connection.
That didn't help. Ultimately, solution was to install a Microsoft Loopback
network adapter (not an actual physical device, but can select from list).
Once did this, problem went away.
"Newbie" <ad***@indohomeware.com> wrote in message
news:On**************@TK2MSFTNGP12.phx.gbl... try using 'localhost' as your datasource/server identifier. HTH, andy
"BobRoyAce" <bo*@omegasoftwareinc.com> wrote in message news:Ep********************@comcast.com... ConnectionString = "Persist Security Info=False;Initial Catalog=THEDB;Data Source=127.0.0.1;user=appuser;password=thepassword ;Connect Timeout=120"
NOTE: All works well as long as network cable is plugged in...just doesnt work if it's not plugged in...so not a connection string problem. I am wondering if TCP/IP is required to make the connection and if it isn't in memory if boot up without cable since it detects that there is no network connection.
BobRoyAce,
that was why i was asking how u were connecting!!
Cos Microsoft Loopback network adapter is default.
So its better connecting to DataSource = (local) and not 127.0.0.1.
Well good u got it working!
Patrick
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
And it's even better connecting to the instance name.
DataSource = SQLServerInstanceName
or
DataSource = SQLServerName\netsdk
and not 127.0.0.1 *or* (local).
Juan T. Llibre
ASP.NET MVP http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================
"Patrick Olurotimi Ige" <ig*@iprimus.com.au> wrote in message
news:ee****************@tk2msftngp13.phx.gbl... BobRoyAce, that was why i was asking how u were connecting!! Cos Microsoft Loopback network adapter is default. So its better connecting to DataSource = (local) and not 127.0.0.1. Well good u got it working! Patrick *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Savas Ates |
last post by:
in asp page
im getting this error how can i solve it..
yesterday the codes work but i setup visual studio 6.0 now it doesnt
works..
|
by: Bob |
last post by:
Having trouble getting started.
I created an instance of MSDE called VSDOTNET on a computer with the
name of sysdev.
Using MS SQL Web Adminstrator I created a database called temp with a...
|
by: Hermit Dave |
last post by:
Hi,
I am getting this SQLException: Sql Server does not exist or access denied
Here is the situation:
Build machine: VS 2003, Framework 1.1, Windows XP and SQL Server
I have two sets of...
|
by: Dave Dudley |
last post by:
Hi,
I have a new ASP .Net project that has been developed on our
development machine and connects to SQL Server 2000 on the same
machine. It is connecting via a connection string similiar to:...
|
by: RKay |
last post by:
I have a Win2k server running SQL Server 2000. On that box I built a
working web service that pulls data from the database. One of the
services available simply accepts an ado.net connection string...
| |
by: vighnesh |
last post by:
Hi All
I am dealing a project in ASP.NET in which I have to establish a connection
to SQL Server 2000 database,where the database was located on a remote
system.
For this I have used...
|
by: Marcus |
last post by:
I have a function that simply returns TRUE if it can connect to a
particular Sql Server 2005 express, or FALSE if it cannot. I am getting
some strange error codes returned when the computer that...
|
by: itfetish |
last post by:
I've just upgraded our WIndows 2003 (with SBS server) web server
to .Net framework 2.0
(it had 1.1 before)
As I have been working on a web parts page on my laptop, hosting it
there, working...
|
by: LamSoft |
last post by:
I am not going to write a aspx to connect a SQL Server... but it tries to connect the SQL Server...
Some of the Code..
protected void LoginButton_Click(object sender, EventArgs e)
{
if...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |