Prev: remote call of sys.object_definition()
Next: remote database needs prefix database in sql
From: Scott on 19 Mar 2010 13:23
Using SQL Server Express 2008 SP1 on Windows XP SP3.

Unplugged network cable connection.
When creating the SqlFileStream class an exception is thrown "The network
connection cannot be reached."
This works when the network cable connection is plugged back in.

Does anyone know how SqlFileStream can be made to work when the network
cable is unplugged?

Scott
From: Bob Beauchemin on 19 Mar 2010 15:38
Hi Scott,

I believe that you need to install the loopback adapter (see
http://support.microsoft.com/kb/839013) because the filestream feature needs
a "network" whether you actually have one or not.

Cheers,
Bob Beauchemin
SQLskills

"Scott" <Scott(a)discussions.microsoft.com> wrote in message
news:0D0BA3C1-039B-4BED-80E7-1E85770ECE30(a)microsoft.com...
> Using SQL Server Express 2008 SP1 on Windows XP SP3.
>
> Unplugged network cable connection.
> When creating the SqlFileStream class an exception is thrown "The network
> connection cannot be reached."
> This works when the network cable connection is plugged back in.
>
> Does anyone know how SqlFileStream can be made to work when the network
> cable is unplugged?
>
> Scott

From: Scott on 23 Mar 2010 09:23
Hi Bob,

Thanks for the response.
What happens if the loop back adapter is installed but the machine is
connected to a network? Does the loop back adapter recognize this?

Is there any other solution to this?
It would seem that SQL Server shouldn't care if there is a network present
or not.

Scott

"Bob Beauchemin" wrote:

> Hi Scott,
>
> I believe that you need to install the loopback adapter (see
> http://support.microsoft.com/kb/839013) because the filestream feature needs
> a "network" whether you actually have one or not.
>
> Cheers,
> Bob Beauchemin
> SQLskills
>
> "Scott" <Scott(a)discussions.microsoft.com> wrote in message
> news:0D0BA3C1-039B-4BED-80E7-1E85770ECE30(a)microsoft.com...
> > Using SQL Server Express 2008 SP1 on Windows XP SP3.
> >
> > Unplugged network cable connection.
> > When creating the SqlFileStream class an exception is thrown "The network
> > connection cannot be reached."
> > This works when the network cable connection is plugged back in.
> >
> > Does anyone know how SqlFileStream can be made to work when the network
> > cable is unplugged?
> >
> > Scott
>
> .
>
From: Bob Beauchemin on 23 Mar 2010 10:23
Yes, if the network is present things will work as they should. This is
because filestream uses UNC-type names, which involve the Windows
redirector.

Cheers,
Bob

"Scott" <Scott(a)discussions.microsoft.com> wrote in message
news:20672662-2103-43ED-99E2-3527542560BC(a)microsoft.com...
> Hi Bob,
>
> Thanks for the response.
> What happens if the loop back adapter is installed but the machine is
> connected to a network? Does the loop back adapter recognize this?
>
> Is there any other solution to this?
> It would seem that SQL Server shouldn't care if there is a network present
> or not.
>
> Scott
>
> "Bob Beauchemin" wrote:
>
>> Hi Scott,
>>
>> I believe that you need to install the loopback adapter (see
>> http://support.microsoft.com/kb/839013) because the filestream feature
>> needs
>> a "network" whether you actually have one or not.
>>
>> Cheers,
>> Bob Beauchemin
>> SQLskills
>>
>> "Scott" <Scott(a)discussions.microsoft.com> wrote in message
>> news:0D0BA3C1-039B-4BED-80E7-1E85770ECE30(a)microsoft.com...
>> > Using SQL Server Express 2008 SP1 on Windows XP SP3.
>> >
>> > Unplugged network cable connection.
>> > When creating the SqlFileStream class an exception is thrown "The
>> > network
>> > connection cannot be reached."
>> > This works when the network cable connection is plugged back in.
>> >
>> > Does anyone know how SqlFileStream can be made to work when the network
>> > cable is unplugged?
>> >
>> > Scott
>>
>> .
>>
 | 
Pages: 1
Prev: remote call of sys.object_definition()
Next: remote database needs prefix database in sql