We began getting the following error this morning, from a php script that's been running for months:
[25-Feb-2013 01:10:17] PHP Warning: odbc_connect(): SQL error: [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server . , SQL state 08001 in SQLConnect in C:\Admin\Scripts\extract_to_sqlserver.php on line 665
The script connects to the local host, and was using the IP address "192.168.0.40". When we changed it to "localhost", it started working again.
Now, to figure out what changed in the environment that caused the IP to stop working all of a sudden...
Maybe your localhost lost its DHCP lease?
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog
, and Twitter
.Freelance Writer: ShadowrunLatchkeys: Nevermore
, Latchkeys: The Bootleg War
, and Latchkeys: Roscoes in the Night
are now available on Nook and Kindle.